Principal, Data Engineer

Fidelity Investments • Full-time • Merrimack, New Hampshire, United States • $128.61k - $161.00k / year • 3m ago

Job Description:

Principal, Data Engineer

We have an outstanding opportunity for a highly experienced data engineer to contribute to the delivery of modern data solutions for Fidelity Technology Strategy and Planning. As a Principal Data Engineer you will contribute directly to the development and support of data management capabilities for internal applications and 3rd party data integrations. This work may also extend to tech leadership responsibilities, guiding the work of other team members. This data will be used to empower BI & analytics solutions to enable leaders to make real-time business decisions, better optimize their portfolio of work delivery, and bring more value to Fidelity and our customers. This understanding empowers both associates and leaders to look across squads/teams, product areas, and domains to better understand dependencies, shared work progress and how their work connects to Fidelity’s overall strategy and Enterprise Priorities. There are complex data movement requirements from internal and external data sources into our common ecosystem. We require an engineer who has significant experience in the design and implementation of strong data models to ensure our data solutions are performant, reusable, and scalable.

The Expertise we’re looking for

8+ years of related experience in data engineering, data analysis, data warehouses, data lakes.
Strong experience with relational database technologies (Oracle SQL & PL/SQL, Postgres, or similar RDBMS).
Experience with Snowflake, AWS RDS, Azure, and other Cloud Data warehousing services.
Strong expertise in all aspects of data movement technologies (ETL/ELT) and experience with Control-M and schedulers, Python and shell scripting
Proven experience in understanding multi-functional enterprise data, navigating between business analytic needs and data.

The Skills you bring

You are self-motivated and function well within a team delivery format
You have excellent organizational and communication skills
Proven track record as a thought leader and mentor, working in collaborative teams to deliver high quality data solutions in a multi-developer global environment following design & coding best practices.
Outstanding SQL skills and experience performing deep data analysis on multiple database platforms.
Ability to develop highly reliable ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake SnowSQL.
Knowledge and expertise of data modelling techniques and best practices (Relational, Dimensional), plus any prior experience with data modelling tools (eg. PowerDesigner).
Prior experience with Data ingestion tool sets (e.g Apache NiFi, Kafka) is advantageous.
Experience with API’s, Python, Power apps is advantageous.
Experience in Data Architecture (Database design, performance optimization).

The Value you deliver

Simplifying and effectively communicating technical challenges, solutions options, and recommendations to business partners and technology leadership.
Provide technical leadership and support in data and solutioning to team members.
Produce scalable, resilient, cloud-based systems design aligned with our long-term strategy.
Collaborate with team leads, tech leads and architects on setting the technical roadmaps.
Recognizing opportunities to bring emerging technologies to deliver innovative solutions to meet business challenges.
Understand detailed requirements and deliver solutions that meet or exceed customer expectations.
Take ownership and accountability.
Adaptability to a changing and challenging workload.

Certifications:

Category:

Information Technology

Fidelity’s hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.

Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.