Job Title: Data Engineer
Location: London
Type: Permanent, Full-time
Department: Group IT
Reports to: Software Development Manager
**IDEALY HAS PHINSYS EXPERIENCE**
About the Role
We are looking for a skilled Data Engineer to join a dynamic IT team within a well-established, regulated organisation. This role offers the opportunity to work on critical data platforms, support financial reporting processes, and play a key part in a strategic transition to cloud-based technologies.
You will be responsible for maintaining and developing data solutions, supporting SQL Server environments, and contributing to the design of modern, scalable data architecture.
Key Responsibilities
* Support critical data processing between core systems and the Enterprise Data Warehouse, ensuring accurate and timely reporting
* Manage and monitor ETL pipelines, identifying and resolving data issues and performance bottlenecks
* Act as a technical point of contact during financial close periods (monthly, quarterly, year-end)
* Perform root cause analysis on data issues and implement effective solutions
* Collaborate with IT and business teams to resolve data challenges and improve processes
* Identify opportunities to automate and optimise manual workflows
* Contribute to the design of a cloud-based “Single Source of Truth” data platform
* Design, develop and maintain ETL workflows using modern tools (e.g. Azure Data Factory, Databricks)
* Optimise database performance through query tuning, indexing and partitioning strategies
* Support CI/CD practices using Azure DevOps
* Produce and maintain technical documentation
* Provide ad-hoc data extraction, reporting, and general IT support as required
Technical Skills & Experience
* Strong experience with SQL Server, including T-SQL, stored procedures, and performance tuning
* Solid understanding of ETL processes and tools (SSIS, Azure Data Factory)
* Experience with cloud platforms such as Azure (Synapse, Databricks, Fabric) or Snowflake
* Familiarity with Azure DevOps and source control best practices
* Experience working with Visual Studio (VS2022+)
* Knowledge of data warehousing concepts and architectures
Desirable:
* Experience supporting financial systems (e.g. accounting or policy systems)
* Azure DBA experience
* Knowledge of Azure Analysis Services or SSAS
* Experience with C#, ASP.NET MVC, or web application development
* Familiarity with AI tools such as GitHub Copilot
* Exposure to VBA or SharePoint Online
Skills & Attributes
* Strong analytical and problem-solving skills
* Ability to work effectively with business stakeholders and gather requirements
* Excellent communication skills (written and verbal)
* Ability to prioritise and perform under pressure
* Collaborative team player with strong relationship-building skills
* Familiarity with Agile methodologies