Do 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 WIMSI (WW Integrated Marketing & Systems Intelligence) 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 new features for current and future roadmap of reporting and measurement products .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 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 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.
- 5+ years of SQL experience
- 1+ years of SQL, ETL or Oracle experience
- 1+ years of processing large, multi-dimensional datasets from multiple sources experience
- 1+ years of performing statistical analysis experience
- 1+ years of developing automated reporting experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience with theory and practice of design of experiments and statistical analysis of results
- Experience with AWS technologies
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience with theory and practice of information retrieval, data science, machine learning and data mining
- Experience managing, analyzing and communicating results to senior leadership
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 Company’s 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 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.
USA, CA, Santa Monica - 130,400.00 - 176,300.00 USD annually
USA, NY, New York - 143,400.00 - 194,000.00 USD annually
USA, WA, Seattle - 130,400.00 - 176,300.00 USD annually
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 new features for current and future roadmap of reporting and measurement products .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 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 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
- 10+ years of professional or military experience- 5+ years of SQL experience
- 1+ years of SQL, ETL or Oracle experience
- 1+ years of processing large, multi-dimensional datasets from multiple sources experience
- 1+ years of performing statistical analysis experience
- 1+ years of developing automated reporting experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience with theory and practice of design of experiments and statistical analysis of results
- Experience with AWS technologies
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience with theory and practice of information retrieval, data science, machine learning and data mining
PREFERRED QUALIFICATIONS
- Experience working directly with business stakeholders to translate between data and business needs- Experience managing, analyzing and communicating results to senior leadership
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 Company’s 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 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.
The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.
USA, CA, Santa Monica - 130,400.00 - 176,300.00 USD annually
USA, NY, New York - 143,400.00 - 194,000.00 USD annually
USA, WA, Seattle - 130,400.00 - 176,300.00 USD annually