Data Engineer I, Profitability Insights Manager

PRISM (Profitability Insights Manager) vision is to be the source of truth for AWS profitability and provide Finance and the business with insights that help to guide investment decisions and optimize profitability.
PRISM generated profit and loss statements across multiple intersections like customer, contract, partner, service and sales.
As a data engineer in PRISM you will be responsible for integrating with finance data from upwards of 15+ systems at scale. We run complex allocation logic for our customers to provide a profitability view. We also compare the modelling with actuals and provide insights through AI. The team provides ample opportunity to innovate and solve ambiguous problems at scale

Key job responsibilities
1. Deliver features in the data pipelines to meet customer needs on profitability
2. Generate actionable insights from the data so that Finance customers can do differentiated work
3. Scale the data pipeline for the ever increasing data volume
4. Ability to learn and leverage the latest data analytical tools
5. Work on the end to end experience from sourcing the data, defining the data model/architecture, implementing a reporting layer and generating analytics and insights

A day in the life
1. Collaborate with stakeholders across customer finance, sales finance, service finance, deal modelling teams
2. Constantly strive to improve the efficiency of the data pipeline. e.g. Reduce the time taken to load data, ability to define the data model that simplifies visualization, adhere to data governance frameworks

About the team
PRISM (Profitability Insights Manager) is the profit and loss (P&L) statement solution for AWS. The web-based interface currently enables AWS Finance users to quickly generate customer and sales P&Ls. In the future, users will also be able to generate P&Ls across product and infrastructure region dimensions, delivering a detailed historical P&L for any customer, territory, or product intersection.

PRISM is important because it provides AWS Finance with visibility into the financial performance of all customers, whether they're on public or private pricing. Private pricing means offering financial incentives to specific customers, and has become an important selling level for AWS. A granular, period-over-period P&L gives analysts and leaders the data they need to drive insights that impact the business.

Basic Qualifications

- 1+ years of data engineering experience
- 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)

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.

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.