Senior Data Engineer

Job Description:

Senior Data Engineer

Location: Galway

We have an outstanding technology opportunity for a data engineer in Ireland to contribute to the delivery of modern data solutions for Fidelity Technology Strategy and Planning. As a Senior Data Engineer your work will empower 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. Applications & technologies may include but are not limited to: PowerApps, PowerBI, Tableau, and other BI tools, intranet sites, proprietary systems, and data feeds that may flow between these and other systems. 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 integrations are performant, reusable, and scalable.

• 5+ years of related experience in data engineering, data analysis, data warehouses, data lakes.
• Strong experience with relational database technologies (Oracle SQL & PL/SQL, Postgres, or similar RDBMS).
• Experience with Snowflake, Dataverse, AWS RDS, Azure, or 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
• Proven experience in understanding multi-functional enterprise data, navigating between business analytic needs and data.

• You are self-motivated and function well within a team delivery format
• You have excellent organizational and communication skills
• Proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer global environment following design & coding best practices.
• Outstanding SQL skills and experience performing deep data analysis on multiple database platforms.
• Ability to develop 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 best practices (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).
• Experience working with data in Jira, Jira Align, Workforce Connect domain is a plus

• 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. Fidelity Internal Information
• Produce scalable, resilient, cloud-based systems design aligned with our long-term strategy.
• Collaborate with chapter leads, squad 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.