Senior Data Engineer

A leading not-for-profit organization is seeking a Senior Data Engineer to lead the migration from SQL Server on-premises to Azure cloud. This role involves integrating various data sources, ensuring data integrity, and supporting strategic goals with cutting-edge data solutions.

Client Details

The client is a prominent not-for-profit organization in the sports sector. They are dedicated to enhancing their data capabilities to support strategic goals and operational processes, particularly focusing on the migration from on-premises SQL Server to Azure cloud infrastructure. They aim to improve transparency, access to information, and data-driven decision-making across various lines of business.

Description

• Lead the development and support of the organization's data infrastructure.
• Design and deliver a data management capability enabling data mining and reporting.
• Integrate proprietary data sources into the data warehouse.
• Own data workflows and associated metadata.
• Drive the implementation from on-premises to full Azure SQL.
• Create and maintain protocols and guidelines for managing external data sources.
• Implement controls to ensure data integrity.
• Deliver documentation supporting infrastructure and processes.
• Manage Data Management and Governance across Azure Dataverse.
• Investigate, analyze, and resolve data issues.
• Liaise with external data providers on structure, supply, quality, and frequency of data delivery.
• Support application developers with data structuring queries.
• Monitor and evaluate tools and technologies.

Profile

The successful candidate for this Senior Data Engineer role will possess the following:

• Over 5 years of experience in data engineering and development.
• Extensive experience in database design (both relational and dimensional).
• Proven track record with ETL processes, data warehousing, and data modeling.
• Hands-on experience with Azure SQL, Microsoft Azure Data Factory, and Microsoft Dataverse.
• Experience in managing both structured and unstructured data.

• Strong expertise in data management and governance.
• Proficiency in user requirements elicitation.
• Ability to integrate proprietary data sources into a data warehouse.
• Skilled in implementing controls to ensure data integrity.
• Competence in investigating, analyzing, and resolving data issues.
• Familiarity with Dynamics365, PowerBI, API development (including GraphQL), Azure Data Lake, and Data Bricks is a plus.

• Analytical and critical thinker with a keen attention to detail.
• Action-oriented and continuously learning.
• Strong ability to influence others and build relationships.
• Excellent communication skills to interact with both technical and non-technical stakeholders.
• Passion for sports and an understanding of its impact is desirable.

Job Offer

• Competitive Salary: Up to £60k per annum.
• Flexible Working: Opportunity to work remotely with just one day a week in the London office.
• Generous Holiday Allowance: Ample paid time off to ensure a healthy work-life balance.
• Professional Development: Access to training and development programs to enhance your skills and career growth.
• Cutting-Edge Technology: Work with the latest Azure cloud technologies and data solutions.
• Impactful Work: Contribute to meaningful projects that support the sports sector and drive strategic goals.