Senior Data Engineer

Hays plc
Charing Cross, United Kingdom
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
£ 80K

Job location

Charing Cross, United Kingdom

Tech stack

Microsoft Excel
Agile Methodologies
Automation of Tests
Data Integration
ETL
Data Warehousing
Database Development
Microsoft SQL Server
SQL Azure
Systems Development Life Cycle
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Data Streaming
Azure
Powerquery
Data Lake
Data Management
Azure
Data Pipelines

Job description

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! #4769393 - George

Requirements

  • 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! #4769393 - George

Apply for this position