Principal Data Engineer

Position Description:

Produces scalable, resilient, Cloud-based systems design using multiple methodologies -- data warehousing, data visualization, and data integration. Simplifies Online Transaction Processing (OLTP) using relational database technologies (Oracle SQL and PL/SQL) and Snowflake. Constructs and compares models using data modelling tools and data ingestion tool sets, including Apache NiFi and Kafka. Sets up reliable infrastructure to perform data-related tasks, particularly with Kafka, to stream analytics. Delivers and supports Cloud strategies including migrating legacy products and implementing Software as a Service (SaaS) integrations (for data-sharing purposes). Designs, develops and modifies software systems to predict and measure outcomes and consequences of design, using scientific analysis and mathematical models.

Primary Responsibilities:

• Crafts and implements operational data stores and data lakes in a production environment.
• Coordinates project functionality, using DevOps and Continuous Integration/Continuous Delivery (CI/CD) methodologies and tools.
• Performs deep data analysis on multiple database platforms hosted in AWS and Azure.
• Develops Data pipelines to move data to and from Snowflake and AWS Cloud resources, using Python.
• Analyzes information to determine, recommend, and plan installation of a new system or modification of an existing system.
• Monitors functioning of equipment to ensure system operates in conformance with specifications.
• Determines system performance standards.
• Confers with systems analysts and other software engineers/developers to design systems and obtain information on project limitations and capabilities, performance requirements, and interfaces.
• Develops and maintains software system testing and validation procedures, programming, and documentation.
• Assists in establishing and maintaining industry standards in systems and security.

Education and Experience:

Bachelor’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Data Engineer (or closely related occupation) designing Data applications in Cloud using Python and databases (Snowflake, Azure Dataverse, and Oracle).

Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Data Engineer (or closely related occupation) designing Data applications in Cloud using Python and databases (Snowflake, Azure Dataverse, and Oracle).

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise (“DE”) performing data movement processes (migration, ingestion, and sync-up) for legal, compliance, risk, and security applications, using Python, Kubernetes, and Snowflake.
• DE implementing Snowflake Data Lake, Stored Procedure, views, relationships, and flows for legal, compliance, risk, and security applications on a Cloud Platform, using custom connectors; and implementing Power BI reports using Snowflake and Oracle.
• DE implementing data components (databases, tables, views, types, stored procedures, functions, roles, and queries) for legal, compliance, risk, and security applications on relational databases (Oracle), using SQL and PL/SQL queries.
• DE implementing enterprise level job scheduling and creating compliance aggregate reports for legal, compliance, risk, and security applications on a customer identification program, using Control-M.

#PE1M2

#LI-DNI

Fidelity’s hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.

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.