Data Engineer - TM1/Planning Analytics

Job summary
How often have you had an opportunity to be a new member of a team that is tasked with solving a huge customer need through disruptive and innovative technology?

The Financial Systems and Analytics Team (FSAT) is seeking a Data Engineer to help lead a flagship multi-year project to inject automated planning and reporting, predictive forecasting, and help shape an end UI, built on the AWS Data Lake. We are the tech team that supports WW Amazon Operations – one of the fastest growing, largest and most complex Supply Chains in the world. This position requires a high level of technical expertise with data engineering concepts.

Key job responsibilities

• Deliver on data architecture projects and implementation of next generation financial solutions.
• Manage AWS resources including EC2, RDS, Redshift, Kinesis, EMR, Lambda etc.
• Build and deliver high quality data architecture and pipelines to support customer reporting needs.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources.
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.
• Collaborate with business users, development teams, and operation engineering teams to tackle business requirements and deliver against high operational standards of system availability and reliability
• Dive deep to resolve problems at their root, looking for failure patterns and suggesting fixes
• Prepare runbooks, methods of procedures, tutorials, training videos on best practices for the team
• Build monitoring dashboards and creation of critical alarms for the system
• Build and enhance software to extend system, application, or tool functionality to improve business processes and meet end user needs while working within the overall system architecture
• Diagnose and resolve operational issues, perform detailed root cause analysis, respond to suggestions for enhancements
• Identify process improvement opportunities to drive innovation
• Rotational on-call availability for critical systems support

About the team
WW Operations Finance is poised for a revolution. Historically, automation and technical infusion has taken a back-seat to important financial functions such as controllership, financial oversight, risk mitigation, and strong investment analysis. Finance is set to be the Chief Story Tellers, and along the way inject machine learning, BI, advanced analytics and technical tools – built to suit finance and business needs.

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
• 4+ years of relevant IBM Cognos TM1/Planning Analytics experience including system configuration, model building and developing reports or dashboards with TM1
• Relevant corporate finance experience exhibiting knowledge of financial planning, budgeting and forecasting functions and related processes
• Bachelor's degree in Finance, Accounting, Engineering, Mathematics or other technical discipline

Preferred Qualifications

• Experience in design and optimization of data-processing systems using AWS services (S3, EMR, Lambda, Glue, Athena, SNS, Cloud Watch, Redshift, Aurora/RDS)
• Experience with Java and experience with scripting languages like Perl, Python, Unix shell scripts, VBA and MS Excel
• Working experience with TM1Py, REST API
• Relevant corporate finance experience exhibiting knowledge of financial planning, budgeting and forecasting functions and related processes.
• Familiarity with other IBM software products
• Experience with design & delivery of formal training curriculum and programs
• Proficiency with Microsoft Project, Visio, and SharePoint
• Project management, scoping, reporting, and scheduling experience a plus
• Bachelor's and/or Master's degree in Finance, Accounting, Engineering, Computer Science, Statistics, Mathematics or other technical discipline
• Excellent written and verbal communication skills with a customer focused, professional demeanor
• Able to work on a diverse team

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.