Data Engineer
We have an outstanding opportunity for a highly experienced data engineer to contribute to the delivery of modern data solutions for Fidelity Technology Strategy and Planning. As a Data Engineer you will contribute directly to the development and support of data management capabilities for internal applications and 3rd party data integrations. This data will be used to empower BI & analytics solutions to enable leaders to make real-time business decisions, better optimize their portfolio of work delivery, and bring more value to Fidelity and our customers. This understanding empowers both associates and leaders to look across squads/teams, product areas, and domains to better understand dependencies, shared work progress and how their work connects to Fidelity’s overall strategy and Enterprise Priorities. There are complex data movement requirements from internal and external data sources into our common ecosystem. We require an engineer who has significant experience in the design and implementation of strong data models to ensure our data solutions are performant, reusable, and scalable.
The Expertise we’re looking for
- 6+ years of related experience in data engineering, data analysis, data warehouses, data lakes and Data Modeling.
- Good experience with relational database technologies (Oracle SQL & PL/SQL, Postgres, or similar RDBMS).
- Experience with Snowflake, AWS RDS, Azure, and other Cloud Data warehousing services.
- Strong expertise in all aspects of data movement technologies (ETL/ELT) and experience with Control-M and schedulers, Python and shell scripting
- Demonstrable experience in understanding multi-functional enterprise data, navigating between business analytic needs and data.
- Experience with Data Modeling & techniques to design Analytical and OLTP data designs
The Skills you bring
- You are self-motivated and function well within a team delivery format
- You have excellent organizational and communication skills
- Proven track record as a leader with vision and mentor, working in collaborative teams to deliver high quality data solutions in a multi-developer global environment following design & coding standards.
- Outstanding SQL skills and experience performing deep data analysis on multiple database platforms.
- Ability to develop highly reliable ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake SnowSQL.
- Knowledge and expertise of data modelling techniques and standard processes (Relational, Dimensional), plus any prior experience with data modelling tools (eg. PowerDesigner).
- Prior experience with Data ingestion tool sets (e.g Apache NiFi, Kafka) is advantageous.
- Experience with API’s, Python, Power apps is advantageous.
- Experience in Data Architecture (Database design, performance optimization).
The Value you deliver
- Simplifying and effectively communicating technical challenges, solutions options, and recommendations to business partners and technology leadership.
- Provide technical leadership and support in data and solutioning to team members.
- Produce scalable, resilient, cloud-based systems design aligned with our long-term strategy.
- Collaborate with team leads, tech leads and architects on setting the technical roadmaps.
- Recognizing opportunities to bring emerging technologies to deliver innovative solutions to meet business challenges.
- Understand detailed requirements and deliver solutions that meet or exceed customer expectations.
- Take ownership and accountability.
- Adaptability to a changing and challenging workload.
Fidelity’s hybrid working model blends the best of both onsite and offsite work experiences. Having the majority of our associates work onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most roles listed as Hybrid will require associates to work onsite all business days of every other week in a Fidelity office. This does not apply to roles listed as Remote or Onsite.
Note: If you are a FINRA registered internal employee who is considering moving to a non-licensed role, you may want to proactively have a conversation with the hiring manager to understand the potential impact to your registrations before a final hiring decision is made.
The hourly pay rate range for this position is $61.00-81.00 per hour.
Placement in the range will vary based on job responsibilities and scope, geographic location, candidate’s relevant experience, and other factors.