Posted 11 days ago
No clicks
**Principal Data Engineer** Leads architecture, design, and development ofcomplex, scalable data processing systems and software applications. Utilizes SQL, PL/SQL, Java, Python, Shell, Oracle, SQL Server, Snowflake, and AWS Cloud technologies. Implements CI/CD pipelines using Jenkins, Terracore, GitHub, and uDeploy. Ensures data quality and security through database tuning and optimization techniques. Collaborates with stakeholders to resolve project/technology issues and advises senior management on technical strategy. Requires a Bachelor's (5 years) or Master's (3 years) degree in relevant field, plus proven experience as a Principal Data Engineer. Must exhibit DE in data warehousing, ETL/ELT development, Cloud-native applications, and data governance. Proficient in programming languages, Agile methodologies, and financial services standards.
- Compensation
- $155,325 – $166,000 USD
- City
- Not specified
- Country
- Not specified
Currency: $ (USD)
Full Job Description
Job Description:
Position Description:
Architects, crafts, and develops highly scalable distributed data processing systems and software applications. Writes and optimizes SQL queries and stored procedures using SQL, PL/SQL, Java, Python, and Shell scripting languages for development of data pipelines. Incorporates and streamlines test automation into software application builds, using Continuous Integration/Continuous Delivery (Cl/CD) methodologies - Jenkins, Terracore, GitHub and uDeploy. Creates data driven business solutions using data warehousing, mart concepts, and relational databases -- Oracle, SQL Server, and Snowflake on Amazon Web Services (AWS) Cloud. Implements and supports databases in an Amazon Web Services (AWS) Cloud Infrastructure environment. Creates and maintains database schemas and objects such as tables, views, indexes, and triggers for easy access of database systems. Confers with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance requirements, and interfaces.
Primary Responsibilities:
Develops applications on complex projects, components, and subsystems for the division.
Troubleshoots and resolves issues with databases and related systems.
Ensures the delivery of effective, efficient, and high-quality data movement and data integration patterns.
Ensures the scalability, reliability, performance, and security of the databases by performing database tunes and optimization techniques.
Monitors and optimizes database performance by implementing various database designs and models techniques.
Advises senior management on technical strategy.
Acts as a primary liaison for business units to resolve various project/technology issues.
Develops comprehensive documentation for multiple applications or subsystems.
Develops or directs software system tests or validation procedures, programs, or documentation.
Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.
Mentors junior team members.
Education and Experience:
Bachelors 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 building highly scalable Business Intelligence (BI) and analytical solutions on Cloud and on-premise platforms in a financial services environment, using Data Warehouse and Mart techniques.
Or, alternatively, Masters 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 building highly scalable Business Intelligence (BI) and analytical solutions on Cloud and on-premise platforms in a financial services environment, using Data Warehouse and Mart techniques.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise (DE) designing and building Data Warehouses and performing Extract, Transform, and Load (ETL) development, using Oracle, PL/SQL, Informatica, Control-M, or UNIX; and building and maintaining (CI/CD) pipelines using Terracore (for application code deployment), Jenkins, GitHub, or uDeploy.
DE coordinating and implementing all aspects of the Software Development Lifecycle (SDLC) in support of applications deployment according to financial services standards, security requirements, software development best practices, and Agile methodologies, using JIRA for project management, and programming languages and frameworks (JavaScript, Node.js, and React).
DE developing Cloud-native applications and migrating on-premise data centric applications to Cloud, using Snowflake and AWS; and migrating data to and from Snowflake data stores by designing and implementing performant ETL/Extract Load, and Transform (ELT) pipelines in Cloud environments, using Python, Snowflake, and SnowSQL.
DE developing effective data solutions that meet end user demands on Snowflake, using Spark SQL and Python; and classifying, analyzing, and governing data assets to ensure data quality and compliance, using Alation and Collibra.
Salary: $155,325.00 to $ 166,000.000/year.
#PE1M2
#LI-DNI
Certifications:
Category:
Information TechnologyPlease be advised that Fidelitys 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.
Apply
All fields are required.
Benefits that balance life and work
From our fully paid parent leave to our on-site health and wellness centers, our benefits support the belief that more balance you have, the better you can achieve your goals.
Company overview
Company overview
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 experience.
Reasonable accommodations
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 contact the HR Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 3.
Equal opportunity employer
Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop, and retain a diverse workforce is to build an enduring culture of inclusion and belonging.
Applicant screening
At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.
AI Guidelines
Learn about our guidelines for use of AI when applying for a Fidelity job
