Senior/Data Engineer

Senior/Data Engineer - Asset Management We are seeking a skilled Data Engineer to support and enhance our growing data, reporting, and analytics function. This role will involve working closely with business users, developing modern reporting solutions, and strengthening our data platform across our data lake and data warehouse environments.Key Responsibilities: Reporting

• Deliver MI and BI reporting across the business.
• Analyse and report on data from the in-house data warehouse, Excel models, and other internal/external data sources.
• Build, maintain, and enhance Power BI reports and dashboards.
• Migrate existing business reports into Power BI and support users with ongoing enhancements.
• Collaborate directly with users to gather requirements for new reports, data extracts, and analytical outputs.
• Handle ad-hoc reporting requests and help users resolve data issues.

ETL & Data Pipeline Support

• Monitor, manage, and support ETL processes, ensuring timely and accurate data flows.
• Diagnose issues across the full data path, Power BI semantic models, stored procedures, views, tables, and underlying source data.
• Develop, maintain, and expand ETL pipelines for ingestion into the data lake and data warehouse.
• Liaise with third parties regarding file deliveries and resolve import or data quality issues.
• Perform log and error analysis, tracing data problems back to their source.
• Log and manage defects through the internal issue-management system.
• Maintain and enhance technical documentation and internal wikis.

Development & Testing

• Perform database development and modelling, including stored procedures, table creation, and view design.
• Develop automated solutions to replace manual processes and streamline business workflows.
• Modernise existing data management, reporting, and ETL processes.
• Conduct both manual and automated testing to validate deliverables.

Essential Skills & Experience

• Strong enthusiasm for learning the business domain and exploring new technologies.
• Hands-on experience with Azure SQL, SQL Server, or Azure Synapse.
• SQL programming experience, including writing and optimising stored procedures.
• Full SDLC experience with an agile development mindset.
• ETL development using Azure Data Factory or SSIS.
• Advanced Excel skills including data connections, analysis, and Power Query.
• Solid understanding of ETL concepts and data integration.

You must have Financial Services Experience. If this sounds of interest, please apply!

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk