Business Analyst I, AWS EMEA

AWS Marketing s vision is to inspire and empower our customers and partners to unlock their cloud potential. Our team shapes AWSs industry perception, drives customer growth, and fosters the adoption of AWS services across a global and diverse customer base. Our Marketing strategy continuously adapts to stay ahead of our digital-first world and ever-changing technology, industry, and customer requirements. Join us for an opportunity to support digital marketing to accelerate customer acquisition and enable sales to reach customers with a winning value proposition.

We are looking for a Business Analyst to support the AWS EMEA Marketing Ops team. In this role you will influence systems and frameworks leveraged by end customers and multiple cross-functional teams. You will apply both business and process acumen in a fast-paced, ambiguous and innovative environment. Our ideal teammate is curious, has an eye for details and always insists on the highest standards. He/she has deep knowledge in data analysis and is able to wrangle the expected data from any data source.

Key job responsibilities
Data Ingestion, Data Transformation, Data Comparison, Data Validation and Data Monitoring of multiple data sources from multiple different systems
Create and Manage ETL jobs, resolve any issues arising during the execution of the jobs
Extract data from multiple systems using SQL queries and ETL jobs based on support ticket requests
Monitor health of Data sources and ETL Pipeline Infrastructure with the help of dashboards
Monitoring & Resolution of Trouble Tickets within defined SLA s.
Diving deep into large data sets to identify patterns, gap areas using SQL, excel and other data manipulation languages - Experience in Excel (macros, index, conditional list, arrays, pivots, lookups)
- 2+ years of complex Excel VBA macros writing experience
- Bachelors degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL