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 theyre 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.
- 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)
- 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
for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.