We are looking for a Data Engineer to join our application team! Within Amazon’s Corporate Financial Planning & Analysis team (FP&A), we enjoy a unique vantage point into everything happening within Amazon.
As part of that, this role would be part of a team that is responsible for Company’s enterprise-wide Financial Planning & Analytics solutions.
Do you have solid Data engineering skills, but are eager for an opportunity to gain skills in other aspects of building & maintaining an enterprise-
scale analytics system, such as exposure to Amazon Web Services (AWS), data lake, data modeling, and master dimension management?
In addition to requiring a high level of technical expertise in ETL software, you will work closely with peer financial and business teams to continuously optimize timelines, processes, and system automation.
Ideal candidates will have expertise in all phases of the data life-cycle management process and successful experience working in a fast-
paced, results-oriented environment.
The data flowing through our platform directly contributes to decision-making by our CFO and all levels of finance leadership.
If you’re passionate about building tools that enhance productivity, improve financial accuracy, and improve work-life harmony for a large and rapidly growing finance user base, come join us!
Key Responsibilities :
Design, development, enhancement, and support of data acquisition from various source systems.
Design Data Warehouse including new subject area development and integration with existing data models
Works closely with key stakeholders, business representatives and technical resources to gather requirements.
Creates / modifies data extraction pipelines into a standardized approach that can be repeatable and reusable.
Implement best practices around ETL development, data validation, and data security.
Establish controls around the processes and addresses performance issues with appropriate technical solutions.
Implements a robust enterprise wide repository designed to ensure analysts will be able to access the data for final presentation to end users.
Provides technical leadership and mentoring to other members of the team to assist in their technical growth.
Serves as member of on-call rotation for critical off-hour support requests.
Collaborate with 3rd party software vendors on issue resolution and product enhancements.
5 years of ETL experience with intermediate to advanced skills
3 years of hands-on experience in writing complex, highly-optimized SQL queries across large data sets
2 years of experience in scripting / programming languages such as Python, Java
Knowledge of distributed systems as it pertains to data storage and computing
Quick learner with a positive attitude, professional demeanor, and strong analytical and troubleshooting skills.
Excellent communication (verbal and written) and interpersonal skills, and an ability to effectively communicate with both business and technical teams.
Bachelor's Degree in Information Systems, Computer Science, Engineering, Math, Finance / Accounting, or a related discipline
Familiarity with AWS solutions such as S3, Redshift, Aurora, Dynamo DB and EMR.
Familiarity with IBM Cognos Product Suite -BI / TM1 OLAP cube modeling
Knowledge of related BI technologies (Tableau, QlikView, MicroStrategy, AWS Quicksight).
Metadata design and implementation
Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations.
Master’s degree in Information Systems, Computer Science, Engineering, Math, Finance / Accounting, or a related discipline.