DESCRIPTION

Job summary
Do you enjoy Big Data, working on cutting edge technologies or creating new/better, smarter algorithms layered on existing technology? Are you frequently looking for ways to help teams be more efficient?

The Data Center Finance team is looking for a talented Data Engineer to help build/enhance the data landscape that shapes decision making and recommendations for our finance and business partners. You will help drive data architecture across many large datasets, perform exploratory data analysis and implement new data pipelines that feed into or from critical data systems at Amazon.

As a Data Engineer, you will develop new data engineering patterns that leverage new cloud architectures, and will extend or migrate existing data pipelines to the architectures as needed. You will also be assisting with integrating the Redshift platform as our primary processing platform to create a curated Data Center data model for the organization to leverage.

You will also be responsible for designing and implementing complex ETL pipelines on the data warehouse platform and other BI solutions to support a rapidly growing and dynamic demand for data, and use it to deliver data as a service, which will have an immediate influence on day-to-day decision making within AWS Infrastructure.

Key job responsibilities

• Design data schema and operate internal data warehouses and SQL/NOSQL database systems
• Design data models, implement, automate, optimize and monitor data pipelines
• Own the design, development and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions
• Analyze and solve problems at their root, stepping back to understand the broader context
• Manage Redshift/Spectrum/EMR infrastructure, and drive architectural plans and implementation for future data storage, reporting, and analytic solutions
• Work on different AWS technologies such as S3, Redshift, Lambda, Glue, etc. and Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
• Must possess strong verbal and written communication skills, be self-driven, and deliver high quality results in a fast-paced environment.
• Conduct rapid prototyping and proof of concepts
• Conceptualize and develop automation tools for bench marking data collection and analytics
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and AWS big data technologies

BASIC QUALIFICATIONS

• 3+ years of experience as a Data Engineer or in a similar role
• Experience with data modeling, data warehousing, and building ETL pipelines
• Experience in SQL

• Bachelor degree in Data Science, Engineering, Statistics, Computer Science, Mathematics or related quantitative field
• Advanced skills in data mining using SQL, ETL, data warehouse as well as Excel
• Proven experience with BI data tools such as Power BI, Tableau, Quicksight
• Coding proficiency in at least one modern programming language (Python, Ruby, Java, etc)
• Ability to complete projects timely and accurately, with strong attention to detail and continuous communication of progress updates to stakeholders

PREFERRED QUALIFICATIONS

• Advanced degree in Data Science, Engineering, Statistics, Computer Science, Mathematics or related quantitative field
• Experience in data mining (SQL, ETL, data warehouse, etc.) and using databases in a business environment with large-scale, complex datasets
• Excellent verbal/written communication & data presentation skills, including experience communicating to both business and technical teams
• Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
• Experience on working with different SQL/NOSQL databases
• Knowledge on data lake platform and difference technologies used in data lake to retrieve and process the data

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.

Pursuant to the Los Angeles Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Workers in New York City who perform in-person work or interact with the public in the course of business must show proof they have been fully vaccinated against COVID or request and receive approval for a reasonable accommodation, including medical or religious accommodation.