The Data Engineer designs, builds, integrates and maintains data solutions using the firm's strategic data platforms, with a particular focus on Microsoft Fabric and the firm's financial systems. The role translates business, finance and reporting needs into secure, maintainable and supportable data solutions that improve data quality, enable automation and deliver measurable value.
Working within the Data Engineering Team, the role combines data solution design with hands-on data ingestion, transformation, modelling, integration and reporting. The Data Engineer works closely with Finance, business stakeholders, Product Owners, Architecture, Cyber Security, Infrastructure, platform owners and service teams throughout the data lifecycle, from discovery and design through deployment, support and continuous improvement.
What You'll Do
- Analyse business, finance and reporting needs, working closely with Finance teams to understand financial data, controls and reconciliations, and translate requirements into practical data designs and delivery options.
- Design, build and maintain Microsoft Fabric pipelines, lakehouses, warehouses, data models and reporting layers, with reliable ingestion and transformation processes that deliver trusted, consistent and usable financial information.
- Integrate financial systems, enterprise platforms, internal systems, APIs and data services, selecting appropriate batch or real-time processing, platform capabilities, extensions or custom code.
- Deliver secure, maintainable, scalable and supportable solutions aligned with enterprise architecture and approved platform patterns, working with platform owners and governance teams to meet security, privacy, data quality, retention and operational requirements.
- Apply effective source control, testing, release and deployment practices; diagnose and resolve issues across pipelines, integrations, models, financial systems and dependent services; and monitor, support and continuously improve deployed solutions.
- Maintain clear designs, technical documentation, data lineage and support information; explain options, decisions and trade-offs to technical and non-technical stakeholders; and provide realistic estimates, identify risks and dependencies, and communicate delivery progress
- Review colleagues' work, contribute to shared standards, reusable components and good engineering practice, and evaluate emerging Microsoft Fabric and data capabilities for measurable value within appropriate controls.
Who We're Looking For
- Experienced in designing and delivering enterprise data solutions, ideally in a complex financial or professional services environment.
- Strong ability to understand business and finance processes and translate requirements into effective data solutions.
- Strong knowledge of Microsoft Fabric, including Data Factory, OneLake, lakehouses, warehouses, notebooks and Power BI.
- Knowledge of SQL, data modelling, data integration patterns, APIs and appropriate use of Python or Spark.
- Understanding of data security, privacy, quality, governance, lineage and operational support requirements.
- Experience applying structured testing, source control, release management and deployment practices to data solutions.
- Ability to diagnose problems across data pipelines, integrations, models, financial systems and dependent services.
- Ability to produce clear data designs, technical documentation, data dictionaries and support information.
Why Choose Us?
Addleshaw Goddard is a place where you are not just valued but encouraged to reach your full potential. Our culture promotes improvement, growth, and collaboration, making us the natural choice for top-tier clients. We celebrate diversity and are committed to creating an inclusive environment for all our employees.