Position Description:
Develops Extract, Load, Transform/Extract, Transform, Load (ELT/ETL) pipelines to move data to and from Snowflake data stores using Python and Snowflake SnowSQL. Develops product roadmaps using multi-functional enterprise data focused on business analytic needs and data. Migrates legacy products and implements Software as a Service (SaaS) integrations. Develops operational data stores and lakes in production environments. Performs data analysis on multiple database platforms. Draws on in-depth knowledge of the business or function to provide business unit-wide solutions by developing complex, multi-faceted software applications. Researches and recommends new technologies in support of the strategic direction of the business unit and participates in the research and recommendation of appropriate models, methods, tools, and technologies to achieve business-unit-wide solutions.
Primary Responsibilities:
-
Translates and incorporates business vision and strategy to architectural strategy recommendations at the functional level.
-
Participates in high-level, cross- functional architecture design teams.
-
Identifies and consults with internal and external technical resources to produce cross-company strategic designs.
-
Consults on development and delivery of major technology initiatives for the business unit.
-
Consults on deployment of major project deliverables.
-
Consults on the documentation of major technology application.
-
Oversees the technical implementation of cross-divisional or company architectural components.
-
Initiates and drives project or strategy discussions with users or external groups to resolve issues.
-
Sets vision, goals, and direction of team/organization.
-
Plans and leads organization-wide initiatives.
-
Provides leadership, technical supervision, and expertise to multiple teams in broad technical areas on complex organization-wide projects.
-
Advises senior management on technical strategy.
-
Researches and recommends new technologies.
-
Works across groups to identify opportunities for organization-wide technology initiatives.
-
Regularly provides guidance, training, and coaching to other team members for performance and career development.
-
Identifies and plans for future resource needs.
-
Determines technical approaches at a strategic level for the business unit.
Education and Experience:
Bachelor’s degree (or foreign education equivalent) in Computer Science, Applied Computer Science, Engineering, Information Technology, Information Systems, Information Management, or a closely related field and six (6) years of experience as a Director, Software Engineering (or closely related occupation) designing and implementing highly scalable and high performance ETL programs - to move data from OLTP to OLAP - using stored procedures, functions, triggers, and cursors (within Oracle and SQL Server databases).
Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Applied Computer Science, Engineering, Information Technology, Information Systems, Information Management, or a closely related field and four (4) years of experience as a Director, Software Engineering (or closely related occupation) designing and implementing highly scalable and high performance ETL programs - to move data from OLTP to OLAP - using stored procedures, functions, triggers, and cursors (within Oracle and SQL Server databases).
Skills and Knowledge:
Candidate must also possess:
-
Demonstrated Expertise (“DE”) conducting data analysis for data extraction by writing complex SQL queries, using SQL Developer, Snowflake, and SnowSQL; performing data modeling using Erwin; and performing data mart design, analyzing data models, and designing database tables within relational and analytical database environments, using SQL Server, Oracle, and Snowflake.
-
DE migrating data to and from Snowflake data stores by designing and implementing highly scalable and performant ETL/ELT pipelines in On-Premises and Cloud environments, using Python, Nifi, Snowflake, and SnowSQL.
-
DE creating scripts (using UNIX Shell, BASH, Python, and PERL) and database procedures (using PL/SQL and SnowSQL programming); implementing load dependencies using Control-M, workflow scheduler, Windows scheduler, and Autosys; and developing Web applications using HTML5, CSS3, and JavaScript.
-
DE developing workflows in Cloud and On-Premises environments using AWS EC2, S3, ECS, EKS, Lambda, RDS, Concourse, and Docker; and creating data visualizations using Tableau, PowerBI, and DOMO.
Company Overview
Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients’ money.
Join Us
At Fidelity, you’ll find endless opportunities to build a meaningful career that positively impacts peoples’ lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees’ Choice Award, we have been recognized by our employees as a Best Place to Work in 2023. And you don’t need a finance background to succeed at Fidelity—we offer a range of opportunities for learning so you can build the career you’ve always imagined.
At Fidelity, our goal is for most people to work flexibly in a way that balances both personal and business needs with time onsite and offsite through what we’re calling “Dynamic Working”. Most associates will have a hybrid schedule with a requirement to work onsite at a Fidelity work location for at least one week, 5 consecutive days, every four weeks. These requirements are subject to change.
We invite you to Find Your Fidelity at fidelitycareers.com.
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.
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.
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.
We welcome those with experience in jobs such as Software Developer, Computer Technician, and Computer User Support Specialist and others in the Computers and Technology to apply.
