Amazon Business Intelligence Engineer MODE 

United States, Washington, Seattle 

905816628

Key job responsibilities
Design, develop, and oversee the reporting pipelines to onboard agency managed media metrics into reporting and measurement tool, using appropriate technologies (e.g., SQL, Python, Spark, AWS Lambda, etc.)
Onboard and monitor the new features for current and future roadmap of RAFT (Reporting and Fast Twitch Insights) and TaCS (Taxonomy and Campaign Spend) for reporting and measurement with data of XCM US campaigns to enable data-driven decision-making
Collaborate with stakeholders (marketing, advertising, finance, engineering, science, legal, and product management) to understand business domains, requirements, and expectations
Work closely with owners of data source systems to gain insights into their capabilities and limitationsAdopt best practices in reporting, including ensuring data integrity, designing thorough testing, validating outputs, and maintaining comprehensive documentationA day in the life

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience writing complex SQL queries
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business