Data Engineer

Amazon; Greater London; On-site; GBP 60,000 - 100,000; Full time

Job summary

A leading digital entertainment company seeks a Business Intelligence Engineer to support its Prime Video service. This role involves solving large-scale data warehousing problems, building scalable ETL pipelines, and delivering data products for strategic decision-making. Candidates should have experience with data modeling, query and scripting languages, and possess problem-solving skills. The work will influence the day-to-day decisions across Prime Video and greatly contribute to its performance.

Qualifications

• Experience with data modeling, warehousing, and building ETL pipelines.
• Familiar with SQL and one or more query languages like HiveQL or SparkSQL.
• Experience in a Data Engineer role or similar.

Responsibilities

• Solve data warehousing problems on a massive scale.
• Develop efficient systems to process data and create actionable KPIs.
• Work with global business partners to deliver data products.

Skills

Data modeling

ETL pipelines

SQL

Python

Problem solving

Tools

Hadoop

Spark

Informatica

Job description

Job ID: 3156785 | Amazon Digital UK Limited

Amazon’s Prime Video is a premium on-demand video entertainment service that offers customers the greatest choice in what to watch from popular Amazon Original TV shows such as The Grand Tour, Jack Ryan, The Boys and the recent Golden Globe winning The Marvelous Mrs. Maisel, to Original Movies like the Oscar‑winning Manchester by the Sea and The Salesman. The service also offers TV shows that are exclusively available for Prime members in each country such as American Gods, Mr Robot and Outlander, and more recently live sport including the US Open tennis and Premier League football. Prime Video is at the forefront of the entertainment industry and growing fast – now available in more than 240 countries and territories worldwide – and we work in a dynamic, and exciting environment where innovating on behalf of our customers is at the heart of everything we do. If this sounds exciting to you, please read on.

Prime Video Finance BI team seeks a business intelligence engineer to support Prime Video strategy and performance. You will be responsible for the production of key business reporting to leadership, building scalable data solutions to complex problems and performing ad‑hoc deep dives to better understand and value performance metrics. You will work with upstream tech teams to create complex data ingestion pipelines for critical data sources, and create actionable KPIs for business teams. In this role, you will also work with key business stakeholders from Finance and Business organizations to identify challenges and translate them into technical requirements that can be solved with BI and Analytics tools.

Key job responsibilities

You’ll solve data warehousing problems on a massive scale and apply cloud‑based AWS services to solve challenging problems around big data processing, data warehouse design, self‑service data access, automated data quality detection and building infrastructure as a code. You’ll be part of the team that focuses on automation and optimization for all areas of DW/ETL maintenance and deployment.

You’ll work closely with global business partners and technical teams on many non‑standard and unique business problems and use creative problem solving to deliver data products that underpin Prime Video strategic decision making, from content selection to on‑platform customer experience. You’ll develop efficient systems and tools to process data, using technologies that can scale to seasonal spikes and easily accommodate future growth. Your work will have a direct impact on the day‑to‑day decision making across Prime Video.

Basic Qualifications

• Experience with data modeling, warehousing and building ETL pipelines
• Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala)
• Experience with one or more scripting language (e.g., Python, KornShell)
• Experience with SQL
• Experience as a Data Engineer or in a similar role

Preferred Qualifications

• Experience with big data technologies such as Hadoop, Hive, Spark, EMR
• Experience with any ETL tool like Informatica, ODI, SSIS, BODI, Datastage, etc.

Amazon is an equal opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice (https://www.amazon.jobs/en/privacy_page) to know more about how we collect, use and transfer the personal data of our candidates.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.