Amazon Sr Business Intelligence Eng MODE 

United States, Washington, Seattle 

775646444

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.)
* Complete new data onboarding for current and future roadmap of RAFT (Reporting and Fast Twitch Insights) and TaCS (Taxonomy and Campaign Spend) for reporting and measurement with agencies outside of US to enable data-driven decision-making
* Onboard new Lines of Businesses to RAFT and TaCS by designing the data model, developing the reporting pipelines and creating the dashboard
* 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 limitations
* Deliver minimally to moderately complex data analysis to support business needs
* Adopt best practices in reporting, including ensuring data integrity, designing thorough testing, validating outputs, and maintaining comprehensive documentationA day in the life

- 10+ years of professional or military experience
- 5+ years of SQL experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience using Cloud Storage and Computing technologies such as AWS Redshift, S3, Hadoop, etc.
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience building measures and metrics, and developing reporting solutions
- 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience