Principal Data Engineer

Fidelity Investments•Boston, MA

9d•Remote

About The Position

Position Description: Applicants are permitted to work remotely from an at home worksite anywhere in the United States. Designs and implements single and multi-tenant data solutions using cloud database technologies. Develops and implements Proof of Concepts (PoCs), frameworks, and real-time pipelines, using SQL, Amazon Web Services (AWS), Snowflake, and Python. Manages data integration, ensuring high data quality and accessibility, using Snowflake and Extract, Transform, Load (ETL) / Extract, Load, Transform (ELT) tools (Informatica). Builds RESTful APIs using Spring Boot, Java, and Python. Develops scalable and robust data solutions for websites using SQL, MySQL, and SQLMI. Builds, maintains, and performs tunning of stored procedures. Assists in planning and execution of user acceptance testing. Proposes modifications and improvements based on user needs.

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) developing ETL framework to transfer files, creating PL/SQL scripts, and creating implementation plan during production implementation.
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) developing ETL framework to transfer files, creating PL/SQL scripts, and creating implementation plan during production implementation.
Demonstrated Expertise (“DE”) performing conceptual data modeling, designing, and developing multi-tenant data solutions for websites using MySQL Workbench, and DataGrip; coordinating database operations and data storage and retrieval using SQL, stored procedures, and triggers on MySQL, Snowflake, and Cloud technologies.
DE performing ETL, ELT, and data integration processes with complex data transformations, using SQL, Python, PowerDesigner, Unix shell scripting, and JSON/ XML Parsing; performing full life cycle analysis and development of Operational and Transactional applications built using Angular; and tuning SQL query performance using TOAD, SQL Developer, and MySQL workbench.
DE interpreting requirements within an Agile environment and developing APIs to move data to and from multiple sources including files and Application Programming Interfaces (APIs) to on-premise or Cloud databases (AWS or Azure) using SpringBoot, Java, and Python.
DE applying Continuous Integration/Continuous Deployment (CI/CD) practices to database releases -- automated deployments -- using Jenkins, JenkinsCore and Urban Code Deploy (uDeploy), applying SDLC best practices -- source code management (Git, Stash, and SourceTree) and documentation using software -- Atlassian Confluence and draw.io.

Responsibilities

Participates in architecture design teams.
Defines and implements application level architecture.
Develops applications on complex projects, components, and subsystems for the division.
Recommends development testing tools and methodologies and reviews and validates test plans.
Responsible for QA readiness of software deliverables.
Develops comprehensive documentation for multiple applications or subsystems.
Establishes full project life cycle plans for complex projects across multiple platforms.
Responsible for meeting project goals on-time and on-budget.
Advises on risk assessment and risk management strategies for projects.
Plans and coordinates project schedules and assignments for multiple projects.
Acts as a primary liaison for business units to resolve various project/technology issues.
Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.
Advises senior management on technical strategy.
Mentors junior team members.
Develops comprehensive documentation for multiple applications in support of corporate initiatives.
Performs independent and complex technical and functional analysis for multiple simultaneous projects.
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.