Data Engineer, Ad Finance, Display Finance BI
DESCRIPTION
Amazon is looking for a motivated individual with strong database, analytical skills and technology experience to join the Display Ads Finance team.
Key job responsibilities
- Owning the design, operations and improvements for the Organizations Datawarehouse infrastructure
- Maintain, improve and manage all ETL pipelines and clusters
- Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency
- Define metrics and KPIs to measure success of strategic initiatives and report on their progress
- Develop relationships and processes with finance, sales, business operations, solution delivery team, partner, BD, and other cross-functional stakeholders
- Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.
- Collaborate with data scientists, BIEs and BAs to deliver high quality data architecture and pipelines.
A day in the life
In this position the successful candidate will be responsible for partnering with Finance and Business leaders to expand and optimize data infrastructure that supports weekly, monthly, quarterly and annual for the Display Ads Finance group and our stakeholders.
About the team
The candidate should enjoy creating pipelines, analyzing data, recommending and implementing solutions to facilitate financial and metrics reporting.
- Plan, design, implement, and manage a deployment of self-service data platform & visualization in Quicksight
- Create and maintain ETL procedures and SQL queries to bring data in from data warehouse and alternate data sources
- Utilize database technologies, including Redshift, AWS EMR and Quicksight to design, develop, and evaluate analyses and highly innovative business intelligence tools and reporting
- Scripting language such as Python preferred
- Establish scalable, efficient, automated processes for large scale data analyses
- Support the development of performance dashboards that encompass key metrics to be reviewed with senior leadership and sales management
- Work with business owners and partners to build data sets that answer their specific business questions
- Support Financial Analysts, Sales Operations Leads and beyond in analyzing usage data to derive new insights and fuel customer success
BASIC QUALIFICATIONS
- 3+ years of data engineering experience
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with SQL
PREFERRED QUALIFICATIONS
- Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
- Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)