Do you want to work on a global project of critical importance to the future of Amazon tackling real neverbeendonebefore challenges of remarkable complexity Do you enjoy fusing marketing customer experience and technical skills to create a holistic datadriven 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 crossfunctional 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 crosschannel 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 dataaware and make informed datadriven 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 datadriven decisionmaking
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 documentation
A day in the life
The successful candidate will demonstrate an ability to influence business owners support thoughtful decisionmaking and adapt to a rapidlyevolving 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 largescale data tools identifying highpriority work and projects that maximize results for key stakeholders and solving complex problems that impact companywide strategic decisions.
5 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
Experience with AWS solutions such as EC2 DynamoDB S3 and Redshift
Experience in data mining ETL etc. and using databases in a business environment with largescale complex datasets
Experience with forecasting and statistical analysis
Adjacency and understanding on media and marketing landscape
Experience in code review and version control tools such as git
Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status disability or other legally protected status.
Los Angeles County applicants: Job duties for this position include: work safely and cooperatively with other employees supervisors and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees supervisors and staff to ensure exceptional customer service; and follow all federal state and local laws and Company policies. Criminal history may have a direct adverse and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above as well as the abilities to adhere to company policies exercise sound judgment effectively manage stress and work safely and respectfully with others exhibit trustworthiness and professionalism and safeguard business operations and the Companys reputation. Pursuant to the Los Angeles County Fair Chance Ordinance we will consider for employment qualified applicants with arrest and conviction records.
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
for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89600/year in our lowest geographic market up to $185000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on jobrelated knowledge skills and experience. Amazon is a total compensation company. Dependent on the position offered equity signon 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 This position will remain posted until filled. Applicants should apply via our internal or external career site.