Principal Data Engineer

Job Title

Designs, develops, and implements scalable data engineering, analytics and reporting solutions to support business needs. Builds robust data infrastructure and reporting platforms, using Oracle SQL, PL/SQL, Python, Airflow, Oracle Business Intelligence Enterprise Edition (OBIEE) / Oracle Analytics Server (OAS), Unix Shell Scripting, and Snowflake. Develops and supports data acquisition, Extract, Transform, and Load (ETL) pipelines, and reporting applications in both on-premises and Cloud-based (Amazon Web Services (AWS)) environments. Collaborates with product owners, data analysts, and data modelers to deliver high-quality, resilient, and extensible data solutions. Ensures alignment to enterprise data, analytics and insights strategy, taxonomy, and DevSecOps practices.

Primary Responsibilities:

• Drives the execution of multiple development work streams and ensures design and architecture is scalable, resilient, and extensible.
• Confers with systems analysts and other software engineers/developers to design systems and obtain information on project limitations, capabilities, performance requirements, and interfaces.
• Develops software system testing and validation procedures, programming, and documentation.
• Collaborates with peers via daily code reviews, pair programming, or interactive discussions.
• Architects, crafts, and develops highly scalable distributed data processing systems.
• Develops solutions that improve developer efficiency and shares knowledge about new techniques and technologies.
• Ensures technology decisions and implementation align with architecture standards and strategies.
• Evaluates and recommends technology and frameworks for flexibility, long-term viability, and time to market.
• Provides guidance, training, and coaching to other team members.
• Plans organization wide initiatives.
• Identifies and plans for future resource needs.

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 data analysis, solution design, and development for Data Lake, ETL, Reporting and Analytic processes.

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 data analysis, solution design, and development for Data Lake, ETL, Reporting and Analytic processes.

Skills and Knowledge:

• Demonstrated Expertise creating conceptual and logical data models to depict functional business entity interactions, using Systems Applications and Products (SAP) Power designer and MS Visio; creating Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) models in line with architectural standards; designing ETL processes to enable data loads into physical database tables; and performing WORM compliant storage for compliance and data masking, using IBM Optim.
• DE performing data analysis and profiling across subject areas within investment management and distribution in the financial services industry, using Microsoft Excel, Toad, SQL Developer, and MS Visio; and designing and developing robust data reconciliation processes to support data quality and completeness in a multi-year data migration project for an OLTP database, using Oracle SQL and PL SQL.
• DE designing and developing back-end applications according to business user requirements, using Oracle, PL/SQL, and Informatica; designing and developing Unix Shell and Oracle PL/SQL scripts and Informatica ETL mappings to bulk load data from data systems and sources into OLTP database according to business user requirements; and designing and developing Control-M jobs to automate and schedule end-to-end processes.
• DE performing in all aspects of the Software Development Lifecycle (SDLC) -- participating in architecture and business discussions and delivering innovative solutions in line with software development best practices and Agile methodologies; and reviewing representative use cases, defining technology and modernization strategies, and publishing key decisions in discernable format to all consumers.

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.