Job Description:
Designs and delivers data lakes, data warehouses, and report platforms. Develops data and analytics solutions on Snowflake Cloud Platform andprovidestechnical guidance in the implementation and practice of relational database technologies and tools -- Snowflake, Oracle, SQL Server, and PL/SQL. Works with teams to support multiple source databases andbuildsextract replication metrics using replication and programming tools.Buildsautomated pipelines to deploy to various environments and services using Amazon Web Services (AWS), Python, Concourse, Jenkins core, and Groovy script.
Primary Responsibilities:
Designs, implements, andmaintainsdata structures, batch jobs, and interfaces to external systems.
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) designing and buildingdatabaseand data models in a financial services environment.
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) designing and buildingdatabaseand data models in a financial services environment.
Candidate must alsopossess:
Demonstrated Expertise ("DE") translating business requirements into technical validations -- examining data to determine accuracy, quality, or condition using SQL, Python, Java, and Scala; and automating the Continuous Integration and Continuous Delivery (CI/CD) Rest APIs pipeline for deployments using Stash, GitHub, Jenkins, anduDeploy.
DE developing data ingestion frameworks using Python to load structured data from relational databases into a Cloud Software as a Service (SaaS) Data Lake Platform (Snowflake), using AWS, NIFI, Java, Snowflake, and Python.
DE developing data masking, reconciliation framework, and comparison dashboard metrics using Bigdata, Python, Java, Snowflake, and Airflow.
DE building metadata-driven frameworks for file feed data ingestion to load data into Snowflake using AWS, Python, Java, Snowflake, and Airflow.
Certifications: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.