Principal Data Engineer

Position Description:

Designs and implements single and multi-tenant data solutions. Builds restful Application Programming Interfaces (APIs) using SpringBoot, Java, and Python. Builds scalable and robust data solutions for Websites using a range of technologies -- Azure, Azure Functions, and Azure Logic Apps. Develops new PL/SQL packages and procedures to update database records and retrieve data for display in the user interface via APIs and Web services. Builds, maintains, and tunes stored procedures using Cloud database technologies -- Snowflake and Azure SQL Database. Leverages data integration processes -- Extract, Load, Transform (ELT) and Extract, Transform, Load (ETL). Automates with various scripting languages, including Python. 

Primary Responsibilities:

• Develops, innovates and manages software and data applications to improve the delivery of data solutions to customers.
• Designs, implements, and maintains a wide variety of processes, platforms, and products.
• Develops and supports software system testing and validation procedures, programming, and documentation.
• Designs and develops computer and network software or specialized utility programs.
• Analyzes user needs and software requirements to determine feasibility of design within time and cost constraints.
• Confers with data processing or project managers to obtain information on limitations or capabilities for data processing projects.
• Consults with customers or other departments on project status, proposals, or technical issues -- software system design or maintenance.
• Confers with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance requirements, and interfaces.
• Mentors junior team members.
• Responsible for QA readiness of software deliverables.
• Advises senior management on technical strategy.

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) performing application development using plan administration systems in a workplace investment domain. 

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) performing application development using plan administration systems in a workplace investment domain.

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise (“DE”) performing enterprise data cataloging, discovery, governance, and correlating and mapping all Personally Identifiable Information (PII) data, using Alation and Big ID; and creating new logical and physical data models using data modeling techniques -- Entity-Attribute-Value (EAV), Star, and Snowflake.  
• DE performing ETL and ELT processes with complex data transformations, using Informatica Powercenter, SnapLogic, Unix shell scripting, and XML Parsing; consuming and interacting with external Web services, including SOAP and RESTful services, within mappings and workflows; and developing and implementing innovative ideas using Artificial Intelligence/Machine Learning (AI/ML). 
• DE designing, developing, and delivering robust, efficient, and scalable database code and constructs with large datasets, using PL/SQL, MS SQL Server, DB2, Sybase, Oracle Exadata, Cloud technologies (MS Azure), and Snowflake; and creating Native Stored Procedures (NSPs) in DB2 Database. 
• DE performing data analysis from the Salesforce Customer Relation Management (Salesforce.com) system, using Salesforce Object Query Language (SOQL) and the Salesforce Object Model; creating reports using Microsoft Power BI; performing code deployment and source code management using GIT, Jenkins, CODEX and Udeploy; and scheduling and monitoring of jobs with CTRL M scheduling tool.

#PE1M2

#LI-DNI

Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles. Some roles may have unique onsite requirements. Please consult with your recruiter for the specific expectations for this position.

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.