Data Engineer

Amazon; Greater London; On-site; GBP 65,000 - 80,000; Full time

Job summary

A leading e-commerce company in Greater London is looking for a Business Intelligence Engineer to join their Prime Video Finance BI team. The successful candidate will be responsible for producing key business reporting, building scalable data solutions, and working with stakeholders to translate challenges into technical requirements. This role offers a chance to solve complex problems on a massive scale using cloud-based AWS services and will have a direct impact on day-to-day decision-making across the Prime Video platform.

Qualifications

• Experience with one or more query languages (e.g., SQL, PL/SQL, DDL).
• Experience with big data technologies like Hadoop, Hive, Spark.
• Experience as a Data Engineer or in a similar role.

Responsibilities

• Solve data warehousing problems on a massive scale using AWS.
• Work closely with global partners and technical teams.
• Develop efficient systems and tools to process data.

Skills

Data modeling

ETL pipelines

SQL

Python

KornShell

Tools

Hadoop

Hive

Spark

Informatica

Job description

Description

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 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.

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.