Amazon
Business Intelligence Engineer, MODE
Amazon, Seattle, Washington, us, 98127
Job ID: 2795808 | Amazon.com Services LLCDo you want to work on a global project of critical importance to the future of Amazon, tackling real never-been-done-before challenges of remarkable complexity? Do you enjoy fusing marketing, customer experience, and technical skills to create a holistic, data-driven picture? If so, the Amazon MODE (Media Operations, Data, and Execution) team is seeking an enthusiastic and skilled Business Intelligence Engineer to join our global, cross-functional team. As the Business Intelligence Engineer, you will play a pivotal part in establishing a standardized data platform with clean, reliable, and accessible data feeds. This platform will support the functional areas of cross-channel media strategy and planning, buying, marketing operations, campaign reporting, and measurement. By providing trustworthy data, technology, and tools, you will empower the business to become more data-aware and make informed, data-driven decisions. In this role, you will collaborate closely with stakeholders across marketing, advertising, finance, engineering, legal, and product management. If you are excited by the prospect of tackling complex, ambiguous challenges and driving the development of new media planning and campaign lifecycle products and features, we encourage you to apply for this transformative opportunity.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-makingCollaborate with stakeholders (marketing, advertising, finance, engineering, science, legal, and product management) to understand business domains, requirements, and expectationsWork closely with owners of data source systems to gain insights into their capabilities and limitationsDeliver minimally to moderately complex data analysis to support business needsAdopt best practices in reporting, including ensuring data integrity, designing thorough testing, validating outputs, and maintaining comprehensive documentationA day in the life
The successful candidate will demonstrate an ability to influence business owners, support thoughtful decision-making, and adapt to a rapidly-evolving environment. They will collaborate with executives and business units across Amazon, bring excellent verbal and written communication skills, and prioritize the most impactful projects and programs to drive businesses forward. A typical day in this role provides an opportunity of building innovative solutions with large-scale data tools, identifying high-priority work and projects that maximize results for key stakeholders, and solving complex problems that impact company-wide strategic decisions.BASIC QUALIFICATIONS
3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experienceExperience with data visualization using Tableau, Quicksight, or similar toolsExperience with data modeling, warehousing and building ETL pipelinesExperience writing complex SQL queriesExperience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelingExperience developing and presenting recommendations of new metrics allowing better understanding of the performance of the businessPREFERRED QUALIFICATIONS
Experience with AWS solutions such as EC2, DynamoDB, S3, and RedshiftExperience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasetsExperience with forecasting and statistical analysisAdjacency and understanding on media and marketing landscapeExperience in code review and version control tools, such as gitAmazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit
here .Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit
here .Posted:
August 30, 2024 (Updated 2 days ago)
#J-18808-Ljbffr
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-makingCollaborate with stakeholders (marketing, advertising, finance, engineering, science, legal, and product management) to understand business domains, requirements, and expectationsWork closely with owners of data source systems to gain insights into their capabilities and limitationsDeliver minimally to moderately complex data analysis to support business needsAdopt best practices in reporting, including ensuring data integrity, designing thorough testing, validating outputs, and maintaining comprehensive documentationA day in the life
The successful candidate will demonstrate an ability to influence business owners, support thoughtful decision-making, and adapt to a rapidly-evolving environment. They will collaborate with executives and business units across Amazon, bring excellent verbal and written communication skills, and prioritize the most impactful projects and programs to drive businesses forward. A typical day in this role provides an opportunity of building innovative solutions with large-scale data tools, identifying high-priority work and projects that maximize results for key stakeholders, and solving complex problems that impact company-wide strategic decisions.BASIC QUALIFICATIONS
3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experienceExperience with data visualization using Tableau, Quicksight, or similar toolsExperience with data modeling, warehousing and building ETL pipelinesExperience writing complex SQL queriesExperience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelingExperience developing and presenting recommendations of new metrics allowing better understanding of the performance of the businessPREFERRED QUALIFICATIONS
Experience with AWS solutions such as EC2, DynamoDB, S3, and RedshiftExperience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasetsExperience with forecasting and statistical analysisAdjacency and understanding on media and marketing landscapeExperience in code review and version control tools, such as gitAmazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit
here .Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit
here .Posted:
August 30, 2024 (Updated 2 days ago)
#J-18808-Ljbffr