Principal Data Engineer

Fidelity Investments•Durham, NC

8h•Hybrid

About The Position

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.

Requirements

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

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.