Job Description
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 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.
Job Classification
Industry: Internet
Functional Area / Department: Engineering - Software & QA
Role Category: Software Development
Role: Data Engineer
Employement Type: Full time
Contact Details:
Company: Amazon
Location(s): Hyderabad
Keyskills:
Data modeling
Analytical
Datastage
SCALA
data governance
PLSQL
Informatica
SSIS
Analytics
Python