Position Description:
Works closely with the business units and architects to gather requirements, plan, design, develop and deploy on-premises and cloud-based applications. Writes SQL queries in Oracle/Snowflake and performs performance optimization for large datasets. Develops ETL/ELT pipelines to move data to and from Snowflake data store using Python, AWS and Snowflake.
Primary Responsibilities:
Analyzes business requirements and delineates possible roadmaps and milestone plans to achieve the desired strategic initiatives.
Collaborates with various business units to fulfill their needs as well as their customer’s, provides technical support such as application and framework development and data management solution and implementation.
Develops ingestion and transformation frameworks to establish data pipelines that can collect logs and enable metadata for the consumption layer.
Provides exploratory analysis and framework development, product development and enhancements, and platform and infrastructure solutions and support.
Delivers actionable insights to various business units by way of data convergence, establishes lower costs for innovation.
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 five (5) years of experience as a Principal, Data Engineer (or closely related occupation) building source for finance data lakes to support reporting and analytical needs using Allocation Rendering Tool (ART) /Anaplan/Snowflake and Python.
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 three (3) years of experience as a Principal, Data Engineer (or closely related occupation) building source for finance data lakes to support reporting and analytical needs using Allocation Rendering Tool (ART) /Anaplan/Snowflake and Python.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise (“DE”) designing and developing Oracle database applications that processes Flat Files using shell scripts; and utilizes Informatica Workflows, database objects stored procedures, Informatica Power Center, and SQL Developer for data processing.
DE performing development within the software development lifecycles using Informatica Power Center, Oracle, Netezza, Microsoft SQL Server, and Unix Shell scripting; and moving data across database using iSQL.
DE designing and developing highly scalable Cloud data warehouses using Cloud computing tools -- Amazon Web Services (AWS) (EMR, S3, CloudFormation), pyspark and Apache NiFi -- and private Computing tools (Hive, Sqoop and HDFS).
DE developing Python-based data ingestion applications to load structured data from relational databases and Anaplan APIs into a Cloud SaaS based Data Lake Platform using Snowflake, Amazon Web Services (AWS) (Lambda, S3, or EC2), Jenkins, GitHub, AtScale, Power BI, and Control-M.
#PE1M2
#LI-DNI
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.
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.
Top Skills
Similar Jobs
What you need to know about the Charlotte Tech Scene
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
