Fidelity logo

Principal Data Engineer

Fidelity
  • Durham, North Carolina
  • Remote
    2 days ago
    Fidelity

    Job Description

    Fidelity will not provide immigration sponsorship for this position.

    Job Description:

    Note: Fidelity will not provide immigration sponsorship for this position.

     

    Position Description:

     

    Designs and develops Extract, Transform, Load (ETL) reporting and analytics solutions using ETL tools (Informatica and Snaplogic). Develops innovative solutions to support scalable, secure, and high-performance data environments. Maintains enterprise data warehouse using RMDS (Snowflake and PostgreSQL), Cloud platforms and services (AWS -- IAM, EC2, S3, Lambda, and RDS), and data manipulation languages and frameworks (Java, Python, and Jason). Develops sophisticated Continuous Integration/Continuous Delivery (CI/CD) pipeline using Maven, Jenkins, Stash, Ansible, and Docker. Writes SQL and stored procedures on relational databases. Performs debugging, analyzing and production support application development based on Jira stories in an Agile environment.

     

    Primary Responsibilities:

     

    • Designs and develops complex data integration solutions.
    • 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.
    • Solves production issues.
    • Interacts with business partners to understand business requirements and assist in generation of technical requirements.
    • 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.
    • Mentors junior engineers.
    • Performs independent and complex technical and functional analysis for multiple divisional initiatives.

     

    Education and Experience:

     

    Bachelor’s 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) designing, building and supporting scalable data pipelines for large scale ETL, real-time, batch systems and reporting platforms in a financial services environment.

     

    Or, alternatively, Master’s 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) designing, building and supporting scalable data pipelines for large scale ETL, real-time, batch systems and reporting platforms in a financial services environment.

     


    Skills and Knowledge:

     

    Candidate must also possess:

     

    ·         Demonstrated Expertise designing and developing data pipelines for data warehouses (ETL), using Python within Agile frameworks (Scrum), in a financial services domain; integrating the data pipelines with PL/SQL; creating batch jobs using schedulers; and identifying bottlenecks in ETL packages.

    ·         Demonstrated Expertise building and maintaining ETL pipelines using Python; developing SQL scripts or stored procedures to process large datasets in relational environments; and improving data workflows and data availability for business operations using PL/SQL with databases (Oracle, Postgres or Snowflake).

    ·         Demonstrated Expertise applying DevOps principles throughout the software development life cycle (SDLC); and building and promoting CI/CD pipelines using Jenkins, and Bitbucket or GitHub to automate deployments.

    ·         Demonstrated Expertise improving system reliability and supporting continuous delivery of data engineering solutions, using Cloud platforms -- AWS or GCP; delivering real time reports with actionable insights to stakeholders.

    #PE1M2

    #LI-DNI

    Fidelity’s 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 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.

    Numbers & Facts

    LocationDurham, North Carolina (
    Remote
    )
    IndustryBanking
    Company Size10,000 employees or more
    Year Founded1946
    Websitehttps://jobs.fidelity.com/

    About Company

    We help over ~40 million people feel more confident in their most important financial goals, manage employee benefit programs for nearly 23,000 businesses, and support more than 3,600 advisory firms* with innovative investment and technology solutions to grow their businesses. Our diverse businesses and independence give us insight into the entire market and the stability needed to think and act for the long term as we deliver value to you.

    Skills

    • AWS Lambdaunmatched
    • Agile Programming Methodologiesunmatched
    • Amazon Elastic Compute Cloud (EC2)unmatched
    • Amazon Simple Storage Service (S3)unmatched
    • Amazon Web Services (AWS)unmatched
    • Ansibleunmatched
    • Atlassian JIRAunmatched
    • Best Practicesunmatched
    • Business Operationsunmatched
    • Cloud Computingunmatched
    • Computer Scienceunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Integrationunmatched
    • Data Managementunmatched
    • Data Setsunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Debugging Skillsunmatched
    • Dockerunmatched
    • ERISA (Employee Retirement Income Security Act of 1974)unmatched
    • Emerging Technologyunmatched
    • Financial Servicesunmatched
    • Functional Analysisunmatched
    • GCP (Good Clinical Practices)unmatched
    • Informaticaunmatched
    • Information Technology & Information Systemsunmatched
    • Investment Servicesunmatched
    • Javaunmatched
    • Jenkinsunmatched
    • Leadershipunmatched
    • Mavenunmatched
    • Mentoringunmatched
    • Microsoft Exchange Serverunmatched
    • Oracleunmatched
    • Oracle PL-SQLunmatched
    • PostgreSQLunmatched
    • Problem Solving Skillsunmatched
    • Product Designunmatched
    • Production Supportunmatched
    • Python Programming/Scripting Languageunmatched
    • Regulationsunmatched
    • Relational Databases (RDBMS)unmatched
    • Reliability Engineeringunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Databasesunmatched
    • Scalable System Developmentunmatched
    • Scripting (Scripting Languages)unmatched
    • Scrum Project Management and Software Developmentunmatched
    • Securitiesunmatched
    • Securities Investmentsunmatched
    • Snowflake Schemaunmatched
    • Software Administrationunmatched
    • Software Configuration Managementunmatched
    • Software Developmentunmatched
    • Software Engineeringunmatched
    • Source Code/Configuration Management (SCM)unmatched
    • State Laws and Regulationsunmatched
    • Static Analysisunmatched
    • Stored Proceduresunmatched
    • Systems Reliabilityunmatched
    • Team Playerunmatched
    • Technical Writingunmatched
    • Technical/Engineering Designunmatched
    • Test Automationunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder