LOG IN
SIGN UP
Canary Wharfian - Online Investment Banking & Finance Community.
Sign In
Forgot password?
Don't have an account?
or
Join Canary Wharfian
By signing up, you agree to our Terms & Conditions and Privacy Policy.
or

Principal Data Engineer

ExperiencedVisa sponsorship available
Fidelity Investments logo

at Fidelity Investments

Asset Management

Posted 3 days ago

No clicks

**Principal Data Engineer** Designs and implements highly scalable, Cloud-based data management and reporting platform components. Develops data models, reports, and visualizations for business intelligence using AI assisted development tools. Architects data consumption patterns, builds CI/CD pipelines, and troubleshoots complex data pipeline issues. Collaborates with senior leadership and mentors junior engineers. Requires a BS/MS in Computer Science/Engineering, and 5/3 years of experience in data engineering with a focus on financial and Medicare data warehousing. Expertise in: Python, Apache NiFi; Snowflake, PostgreSQL; AWS (EC2, S3, Lambda); ETL, data integration; and Cloud data warehousing. Full-time, onsite role.

Compensation
Not specified

Currency: Not specified

City
Not specified
Country
Not specified

Full Job Description

Fidelity will not provide immigration sponsorship for this position.

Job Description:

Position Description:

Designs and implements highly scalable, reusable Cloud-based data management and reporting platform components. Designs and develops data models, reports, and visualizations to support business intelligence and uses AI assisted development tools for data pipeline development. Crafts and evolves foundational Cloud data platform patterns to support significantly increased data volumes, usage concurrency, and cross region consumption for global markets. Develops complex, extensible metrics frameworks and reporting models that can be reused across multiple analytics and BI solutions. Architects scalable data consumption patterns from Cloud data lakes that accommodate diverse analytical workloads, including batch, near real time, and high performance reporting use cases. Builds and refines CI/CD pipelines for data platforms that support complex deployment scenarios, versioned data assets, and environment specific configurations at scale. Defines and documents technical standards, design patterns, and best practices for data engineering and reporting solutions within the team. Troubleshoots and resolves complex data pipeline, platform, and reporting issues involving cross system dependencies and large scale datasets. Implements performance, reliability, and cost efficient optimizations across Cloud data platforms to sustain growth in data volume and user demand. Contributes to architectural decision making for Cloud data platforms by evaluating trade offs in scalability, maintainability, and extensibility of reporting and analytics solutions.

Primary Responsibilities:

  • Designs and develops scalable database, data-pipeline, and data integration solutions supporting analytics and web applications.
  • Implements innovative solutions for financial advisors using the latest technology in a collaborative and engaging environment.
  • Independently designs, develops, and implements data integration solutions using best practices across both cloud-based and traditional infrastructure technologies.
  • Delivers data centric data integration solutions with transformation logic to be consumed by customers.
  • Performs software configuration management, test automation, version control, and static code analysis.
  • Integrates data with end-to-end development activities.
  • Creates, updates, and maintains technical documentation for software-based projects and products.
  • Support SIT and UAT planning, release coordination, and production readiness.
  • Partner with product owners, analysts, and engineers to translate business needs into robust data solutions.
  • Participates in architecture, technical design, and product implementation discussions.
  • Develops and implements advanced data engineering frameworks.
  • Advises senior leadership on data infrastructure and technology solutions and provides data extracts to stakeholders.
  • Provide technical guidance and mentorship to less-experienced engineers.
  • Performs independent and complex technical and functional analysis for multiple divisional initiatives.

Education and Experience:

Bachelors degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Data Engineer (or closely related occupation) building financial and Medicare data warehouse applications using data modeling and Extract, Transform, and Load (ETL) processing.

Or, alternatively, Masters degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal Data Engineer (or closely related occupation) building financial and Medicare data warehouse applications using data modeling and Extract, Transform, and Load (ETL) processing.

Skills and Knowledge:

Candidate must also possess:

  • Demonstrated Expertise designing and delivering enterprise data pipelines; building scalable solutions with Python and Apache NiFi; integrating Snowflake and PostgreSQL (including stored procedures) and APIdriven ingestion using JSON and JOLT; establishing CI/CD pipelines using DevOps and Groovy; performing cloudnative execution on AWS (EC2, S3, Lambda, Secrets Manager, CloudFormation); supporting data quality and reliability using iCEDQ and PyFlowX; enabling analytics through Dataverse, Power BI semantic modeling, and PowerApps; ensuring auditability and operational visibility; and leveraging AIassisted development tools to accelerate delivery and troubleshooting, including applying AI techniques to data quality, anomaly detection, schema evolution, and metadata governance.
  • Demonstrated Expertise implementing enterprisescale ETL, data integration, and business analytics solutions within FinTech and healthcare (Medicare) data domains; designing, building, and optimizing ETL workflows using IBM DataStage with UNIX Shell scripting; integrating data from mainframe files, flat files, and relational databases (Netezza, Oracle, DB2, and Snowflake); implementing data transformation logic, performance tuning, and automated data profiling; and orchestrating multistage pipelines to ensure data accuracy, regulatory alignment, and consistency across downstream systems.
  • Demonstrated Expertise designing and implementing automated data workflows and batch orchestration solutions; migrating and coordinating workloads across scheduling platforms (including Apache Airflow, TWS, and ControlM); managing task dependencies, parallel execution, and audit logging using Directed Acyclic Graphs (DAGs); executing DataStage and Snowflake jobs using UNIX scripts; and improving scalability, reliability, and operational transparency for enterprise data pipelines.

Demonstrated Expertise designing and implementing Cloud Data Warehousing solutions using Snowflake and Oracle to store, process, and analyze data; developing complex SQL and procedural logic for reporting and data validation; optimizing transformations and aggregations using common table expressions (CTEs), window functions, and pivoting techniques; developing ingestion pipelines using Snowflake, Airflow, and ETL scripts; and implementing Change Data Capture (CDC) strategies for incremental and bulkload optimizations across cloud environments (AWS and Azure).

#PE1M2

#LI-DNI

Fidelitys Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.

Certifications:

Category:

Information Technology

Please be advised that Fidelitys 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.

Apply

All fields are required. Candidates should limit the number of roles they apply to at any given time.

Benefits that balance life and work

From our fully paid parent leave to our on-site health and wellness centers, our benefits support the belief that more balance you have, the better you can achieve your goals.

Benefits

Company overview

Company overview 

At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experience. 

Reasonable accommodations

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, or by calling 800-835-5099, prompt 2, option 3.

Equal opportunity employer

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.

Applicant screening

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 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.

AI Guidelines

Learn about our guidelines for use of AI when applying for a Fidelity job

Return to job search

Principal Data Engineer

Compensation

Not specified

City: Not specified

Country: Not specified

Fidelity Investments logo
Asset Management

3 days ago

No clicks

at Fidelity Investments

ExperiencedVisa sponsorship available

**Principal Data Engineer** Designs and implements highly scalable, Cloud-based data management and reporting platform components. Develops data models, reports, and visualizations for business intelligence using AI assisted development tools. Architects data consumption patterns, builds CI/CD pipelines, and troubleshoots complex data pipeline issues. Collaborates with senior leadership and mentors junior engineers. Requires a BS/MS in Computer Science/Engineering, and 5/3 years of experience in data engineering with a focus on financial and Medicare data warehousing. Expertise in: Python, Apache NiFi; Snowflake, PostgreSQL; AWS (EC2, S3, Lambda); ETL, data integration; and Cloud data warehousing. Full-time, onsite role.

Full Job Description

Fidelity will not provide immigration sponsorship for this position.

Job Description:

Position Description:

Designs and implements highly scalable, reusable Cloud-based data management and reporting platform components. Designs and develops data models, reports, and visualizations to support business intelligence and uses AI assisted development tools for data pipeline development. Crafts and evolves foundational Cloud data platform patterns to support significantly increased data volumes, usage concurrency, and cross region consumption for global markets. Develops complex, extensible metrics frameworks and reporting models that can be reused across multiple analytics and BI solutions. Architects scalable data consumption patterns from Cloud data lakes that accommodate diverse analytical workloads, including batch, near real time, and high performance reporting use cases. Builds and refines CI/CD pipelines for data platforms that support complex deployment scenarios, versioned data assets, and environment specific configurations at scale. Defines and documents technical standards, design patterns, and best practices for data engineering and reporting solutions within the team. Troubleshoots and resolves complex data pipeline, platform, and reporting issues involving cross system dependencies and large scale datasets. Implements performance, reliability, and cost efficient optimizations across Cloud data platforms to sustain growth in data volume and user demand. Contributes to architectural decision making for Cloud data platforms by evaluating trade offs in scalability, maintainability, and extensibility of reporting and analytics solutions.

Primary Responsibilities:

  • Designs and develops scalable database, data-pipeline, and data integration solutions supporting analytics and web applications.
  • Implements innovative solutions for financial advisors using the latest technology in a collaborative and engaging environment.
  • Independently designs, develops, and implements data integration solutions using best practices across both cloud-based and traditional infrastructure technologies.
  • Delivers data centric data integration solutions with transformation logic to be consumed by customers.
  • Performs software configuration management, test automation, version control, and static code analysis.
  • Integrates data with end-to-end development activities.
  • Creates, updates, and maintains technical documentation for software-based projects and products.
  • Support SIT and UAT planning, release coordination, and production readiness.
  • Partner with product owners, analysts, and engineers to translate business needs into robust data solutions.
  • Participates in architecture, technical design, and product implementation discussions.
  • Develops and implements advanced data engineering frameworks.
  • Advises senior leadership on data infrastructure and technology solutions and provides data extracts to stakeholders.
  • Provide technical guidance and mentorship to less-experienced engineers.
  • Performs independent and complex technical and functional analysis for multiple divisional initiatives.

Education and Experience:

Bachelors degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Data Engineer (or closely related occupation) building financial and Medicare data warehouse applications using data modeling and Extract, Transform, and Load (ETL) processing.

Or, alternatively, Masters degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal Data Engineer (or closely related occupation) building financial and Medicare data warehouse applications using data modeling and Extract, Transform, and Load (ETL) processing.

Skills and Knowledge:

Candidate must also possess:

  • Demonstrated Expertise designing and delivering enterprise data pipelines; building scalable solutions with Python and Apache NiFi; integrating Snowflake and PostgreSQL (including stored procedures) and APIdriven ingestion using JSON and JOLT; establishing CI/CD pipelines using DevOps and Groovy; performing cloudnative execution on AWS (EC2, S3, Lambda, Secrets Manager, CloudFormation); supporting data quality and reliability using iCEDQ and PyFlowX; enabling analytics through Dataverse, Power BI semantic modeling, and PowerApps; ensuring auditability and operational visibility; and leveraging AIassisted development tools to accelerate delivery and troubleshooting, including applying AI techniques to data quality, anomaly detection, schema evolution, and metadata governance.
  • Demonstrated Expertise implementing enterprisescale ETL, data integration, and business analytics solutions within FinTech and healthcare (Medicare) data domains; designing, building, and optimizing ETL workflows using IBM DataStage with UNIX Shell scripting; integrating data from mainframe files, flat files, and relational databases (Netezza, Oracle, DB2, and Snowflake); implementing data transformation logic, performance tuning, and automated data profiling; and orchestrating multistage pipelines to ensure data accuracy, regulatory alignment, and consistency across downstream systems.
  • Demonstrated Expertise designing and implementing automated data workflows and batch orchestration solutions; migrating and coordinating workloads across scheduling platforms (including Apache Airflow, TWS, and ControlM); managing task dependencies, parallel execution, and audit logging using Directed Acyclic Graphs (DAGs); executing DataStage and Snowflake jobs using UNIX scripts; and improving scalability, reliability, and operational transparency for enterprise data pipelines.

Demonstrated Expertise designing and implementing Cloud Data Warehousing solutions using Snowflake and Oracle to store, process, and analyze data; developing complex SQL and procedural logic for reporting and data validation; optimizing transformations and aggregations using common table expressions (CTEs), window functions, and pivoting techniques; developing ingestion pipelines using Snowflake, Airflow, and ETL scripts; and implementing Change Data Capture (CDC) strategies for incremental and bulkload optimizations across cloud environments (AWS and Azure).

#PE1M2

#LI-DNI

Fidelitys Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.

Certifications:

Category:

Information Technology

Please be advised that Fidelitys 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.

Apply

All fields are required. Candidates should limit the number of roles they apply to at any given time.

Benefits that balance life and work

From our fully paid parent leave to our on-site health and wellness centers, our benefits support the belief that more balance you have, the better you can achieve your goals.

Benefits

Company overview

Company overview 

At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experience. 

Reasonable accommodations

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, or by calling 800-835-5099, prompt 2, option 3.

Equal opportunity employer

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.

Applicant screening

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 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.

AI Guidelines

Learn about our guidelines for use of AI when applying for a Fidelity job

Return to job search