AWS Marketing’s vision is to inspire and empower our customers and partners to unlock their cloud potential. Our team shapes AWS's 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
- Bachelor's degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Experience in Online Advertising/Marketing/Sales/Digital Media
- Experience scripting for automation (e.g., Python, Perl, Ruby)
- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Bachelor's degree in computer science, engineering, mathematics or equivalent 2+ years relevant experience in business analyst, data analyst, or statistical analyst role. Experience visualizing data with business intelligence tools like Power BI, Tableau.
- Data-collection and analysis skills; strong ability using Excel for data analysis and modeling.
- Communication and writing.
- Effectively communicates with both business and technical teams.
Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.