Data Engineer
Job Description
Amazon.com Services LLC invites you to join as a Data Engineer in New York, NY (onsite). The role offers a salary range of USD 101,300 to 160,000 per year and places you on the PV Global Brand Insights team, where you’ll build data pipelines and generate insights to help Prime Video understand and deliver value to customers. This position emphasizes collaboration across research, data science, business intelligence, and data engineering to enable self-service analytics and AI-driven workflows.
Benefits
- Health insurance
- Sign-on payments
- Restricted stock units (RSUs)
- 401(k) matching
- Paid time off
- Parental leave
- Adoption and Surrogacy Reimbursement coverage
- Employee Assistance Program (EAP)
Responsibilities
- Build and optimize data models and pipelines for complex global datasets
- Own ongoing data quality and self-service access to datasets for business intelligence, AI-based tools, and Model Context Protocols (MCP)
- Improve metadata to enhance AI results
- Collaborate with research program leads, data scientists, BI engineers, and other data engineers to maintain stable, performant data solutions
- Write secure, stable, testable, and maintainable code with minimal defects
- Apply appropriate data design approaches and make judicious trade-offs without over-engineering
- Optimize resource usage, including system hardware, data storage, query optimization, and AWS infrastructure
- Participate actively in code reviews, design discussions, and roadmap planning
- Resolve root causes of complex problems while balancing stakeholder requirements with team needs
- Stay current on the latest innovations in the field, including ways that AI can be better used by stakeholders to analyze and visualize data
- Develop and maintain automated reporting and dashboards to provide visibility into brand, marketing, and social performance and allow stakeholders to self-serve insights
Requirements
- 2+ years of data engineering experience
- Experience with data modeling, warehousing, and building ETL pipelines
- Experience with one or more query languages such as SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, or Scala
- Experience with one or more scripting languages such as Python or KornShell
- Foundational knowledge of designing and implementing data schemas, including normalization and relational vs dimensional modeling
- Familiarity with professional software engineering practices across the full software development life cycle, including coding standards, architectures, code reviews, source control, continuous deployment, testing, and operational excellence
- Experience using BI tools such as Tableau or Adobe to visualize data
Technologies
- SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala
- Python, KornShell
- Tableau, Adobe
- Hadoop, Hive, Spark, EMR, Pig, Informatica, ODI, SSIS, BODI, Datastage
- S3, Redshift, Sagemaker, Kinesis, Lambda, EC2
About the team
The PV Global Brand & Marketing Insights team informs global marketing decisions by representing the customer voice for the Global Marketing organization. Our work spans multiple countries to uncover universal customer truths while respecting local nuance, partnering with in-country insights leads. We collaborate with teams responsible for planning and executing strategies to shape the future of the Prime Video brand.