Business Intelligence Engineer, AdTech & Programmatic Analytics

Amazon • New York, NY

1d • Onsite

About The Position

The Analytics Team supporting the Programmatic Solutions Consulting (PSC) organization seeks a Business Intelligence Engineer to join our team in New York City. This role will focus on the design, development, and management of analytical tools and reporting as an end-to-end owner. These solutions will help accelerate our efforts to optimize the efficiency and effectiveness of our partner teams who service our advertising customers. We produce analyses and reporting to surface opportunities to engage with customers, track those engagements, measure the impact, and share actionable insights with senior leaders to inform business decisions and programs. PSC leadership, regional and country managers, Program Managers, and partner teams, such as Finance and Product, will serve as your main customers.

Requirements

• 3+ years of SQL, ETL or Oracle experience
• 3+ years of processing large, multi-dimensional datasets from multiple sources experience
• 3+ years of performing statistical analysis experience
• 3+ years of developing automated reporting experience
• 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 in Statistical Analysis packages such as R, SAS and Matlab
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Nice To Haves

• 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 large-scale, complex datasets

Responsibilities

• Design and develop automated, user-friendly measurement pipelines, reports, and dashboards to support internal partners.
• Recommend new metrics, techniques, and strategies to enhance customer experience.
• Collaborate with cross-functional teams to gather data requirements.
• Enable data-driven decision-making by retrieving and aggregating data from multiple sources, presenting it in a clear and actionable format.
• Work with engineering and product teams to identify product gaps and trends.
• Manage the request intake process, prioritizing tasks in partnership with stakeholders.
• Own the design, development, and maintenance of ongoing metrics, reports, analyses, and dashboards to inform key business decisions.
• Participate in strategic and tactical planning discussions.
• Collaborate with subject matter experts to translate business requirements into technical specifications.

Benefits

• sign-on payments
• restricted stock units (RSUs)
• 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
• parental leave

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed