Principal Data Engineer

Job Description:

Position Description:

Develops Web based applications for database use within Cloud environments

• Snowflake and Amazon Web Services (AWS). Designs software capabilities for data engineering, modeling, and analysis in an Oracle Exadata Platform and Snowflake Enterprise Data Lake. Develops and deploys pipelines within a Cloud native infrastructure. Performs data analysis on database platforms using SQL. Develops Extract, Load, Transform/Extract, Transform, Load (ELT/ETL) pipelines using Informatica PowerCenter and schedule jobs (Ctrl-M). Performs Shell scripting and scheduling using programming languages -- Python and Spark. Designs, builds, and maintains OBIEE and/or Power BI Reporting Platforms. Coordinates project functionalities using DevOps and Continuous Integration/Continuous Delivery (CI/CD) tools and methodologies. Enhances application-level architecture by delivering Amazon Web Services (AWS) data engineering services across the enterprise. Implements process improvements throughout the Software Development Lifecycle (SDLC) according to Agile methodologies

• Kanban and SCRUM.

Primary Responsibilities:

• Develops and maintains complex data platforms.

• Establishes full project life cycle plans for complex projects across multiple platforms.

• Builds data pipelines to facilitate consistent delivery of functional software from release-to-release.

• Responsible for meeting project goals on time and on budget.

• Plans and coordinates project schedules and assignments for multiple projects.

• Builds technical solutions to drive an enhanced data consumption and reports strategy.

• Simplifies and communicates technical challenges, solutions options, and recommendations to business partners and technology leadership.

• Provides technical leadership and support in data and solutioning to team members.

• Advises senior management on technical strategy.

• Develops, maintains, and enhances Web application reporting.

• Leads a team of data engineers to enhance Web applications and enhance and increase the resiliency of reporting platforms.

• Builds reliable products using test automation frameworks and Agile methodologies.

• Designs, develops, implements, and supports complex technology products on behalf of customers.

• Develops and maintains databases according to database warehousing and data mart concepts and principles.

• Mentors junior team members.

Education and Experience:

Bachelor's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Data Engineer (or closely related occupation) performing complex data analysis to implement data warehouse and ETL solutions, in a retirement benefits administration environment.

Or, alternatively, Master's degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Data Engineer (or closely related occupation) performing complex data analysis to implement data warehouse and ETL solutions, in a retirement benefits administration environment.

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise ("DE") designing, implementing, testing, and performing code review of ETL data pipelines to create and perform quality assurance of code, using Informatica workflows, sessions, and mappings; and automating and scheduling jobs in Ctrl-M.

• DE performing database optimization and performance tuning using Realtime SQL; monitoring reports using Oracle Enterprise Manager on an Oracle Exadata Platform (Oracle 12c); optimizing queries, using SQL Profiling and Optimizer Hints; and designing and developing SQL and PL SQL -- stored procedures, functions, views, indexes, materialized views, triggers, and partitioning tables -- using SQL Developer.

• DE performing data engineering, migration, and modelling in a Cloud based data warehouse platform using Snowflake; and developing code, maintaining version controls, and performing automated deployments using CI/CD tools (GIT, Source Tree, Jenkins and UDeploy).

• DE identifying and implementing current and emerging technologies according to enterprise requirements; and gathering and streamlining business requirements to create strong and concise technical specifications.

#PE1M2

Certifications:

Company Overview

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.

Join Us

At Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts peoples' lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees' Choice Award, we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don't need a finance background to succeed at Fidelity-we offer a range of opportunities for learning so you can build the career you've always imagined.

Fidelity's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).

At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

We invite you to Find Your Fidelity at fidelitycareers.com.

Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to accommodations@fmr.com.