Principal Data Engineer

Fidelity•Westlake, TX

About The Position

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.

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 data analysis, solution design, and development for Data Lake, ETL, Reporting and Analytic processes.
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.
Demonstrated Expertise (“DE”) creating conceptual and logical data models to depict functional business entity interactions, using Systems Applications and Products (SAP) Power designer and MS Visio.
DE creating Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) models in line with architectural standards.
DE designing ETL processes to enable data loads into physical database tables.
DE 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.
DE 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.
DE 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.
DE 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.
DE reviewing representative use cases, defining technology and modernization strategies, and publishing key decisions in discernable format to all consumers.

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.