Senior Data Engineer

Job Description: Position Description: Designs and implements single and multi-tenant applications data processes using data models techniques and database technologies – Snowflake and Azure SQL. Creates Application Program Interfaces (APIs) using SpringBoot and Java. Develops Python scripts to gather data files from scan location and load to Azure MYSQL database, using Extract, Load, Transform (ELT). Develops database triggers to mask sensitive data using SQL and PLSQL in lower environments. Develops database and Python scripts for GitHub to deploy code to higher environments using Continuous Integration/Continuous Deployment (CI/CD) pipelines. Primary Responsibilities: Automates the process of dropping files from one LAN location to another by executing the Informatica Workflow. Builds custom databases and middle tiers to support custom web sites. Develops SQL scripts to create database objects -- Tables, Views, and Procedures. Analyzes the existing data engineering processes. Proposes new solutions to effectively manage the data and improve security of the applications. Develops frameworks to perform data quality checks and to validate business requirements. Collaborates across different teams to work on a project. Develops and improves data capabilities for software platforms and products. Writes test plans, cases, specifications, and coverage. 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 three (3) years of experience as a Senior Data Engineer (or closely related occupation) building solutions for extracting and transforming data from diversified sources (Databases, APIs, Web logs, and files) in a financial services domain. 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 one (1) year of experience as a Senior Data Engineer (or closely related occupation) building solutions for extracting and transforming data from diversified sources (Databases, APIs, Web logs, and files) in a financial services domain. Skills and Knowledge: Candidate must also possess: Demonstrated Expertise (“DE”) building infrastructure for optimal extraction, transformation, and loading of data from data sources, using SQL (Oracle, SQL MI, and MySQL), AWS and Azure big data technologies, and structured/unstructured data from files. DE building tools that use the data pipeline to provide actionable insights into key business performance metrics, using Extract, Transform, and Load (ETL)/ELT tools (Informatica Snaplogic, or AWS Services) on Cloud Data warehouse (Snowflake). DE performing release engineering activities (CI/CD), deploying pipelines, and performing code versioning, using GitHub and BitBucket. DE creating programmatic scripts to extract, transform, and manipulate data, using Python; and creating interactive marketing results dashboards using Business Intelligence (BI) tools -- Power BI and Tableau. #PE1M2 Certifications: Category: Information Technology 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. At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation please contact the following: For roles based in the US: Contact the HR Leave of Absence/Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 2 For roles based in Ireland: Contact AccommodationsIreland@fmr.com For roles based in Germany: Contact Accommodationsgermany@fmr.com Fidelity Privacy Policy