Data Analytics Engineer

SOFYNE ACTIVE TECHNOLOGY; London; Hybrid; GBP 50,000 - 75,000; Full time

Job summary

A leading company in technology integration is seeking a Data Analytics Engineer (BI-Focused) in London. The role involves designing data pipelines on Azure, developing SQL transformations, and creating insightful Power BI dashboards. Apply today to be part of a dynamic and growing team, fostering digital transformation in various industrial sectors.

Qualifications

• Previous experience as a BI Consultant, Data Analyst, or Analytics Engineer.
• Strong SQL scripting and data modeling skills.
• Proficiency in Power BI, Azure Data Factory or Microsoft Fabric.

Responsibilities

• Design and implement data pipelines using Azure Data Factory.
• Develop and maintain SQL-based transformations in SQL Server.
• Build and optimize Power BI dashboards for business decisions.

Skills

SQL scripting

Data modeling

Power BI

Azure Data Factory

Python

Communication

Stakeholder engagement

Job description

JOB DESCRIPTION

• Job title: Data Analytics Engineer (BI-Focused)
• Reports to: Lead Data Manager
• Location: London (Holborn), remote 2d/w.

JOB SUMMARY

This role contributes to the success of SOFYNE by designing and implementing robust data pipelines, transforming and modelling data, and delivering insightful dashboards and reports. The Data Analytics Engineer will collaborate with stakeholders across all departments to gather business requirements, design scalable data solutions using Microsoft technologies, and deliver training to empower end users.

PRINCIPAL MISSIONS

• Design and implement data pipelines using Azure Data Factory or Microsoft Fabric.
• Develop and maintain SQL-based transformations and data models (e.g., star schema, snowflakes) in SQL Server, Fabric Datawarehouse/Lakehouse.
• Build and optimize Power BI dashboards and reports to support business decision-making.
• Collaborate with stakeholders to gather requirements and translate them into technical solutions.
• Perform basic data analysis using Python (e.g., pandas, matplotlib) when needed.
• Ensure data quality, governance, and documentation across all solutions.

Provide training and support to end users on BI tools and data literacy.

REQUIREMENTS

• Previous experience as a BI Consultant, Data Analyst, or Analytics Engineer.
• Strong SQL scripting and data modeling skills.
• Proficiency in Power BI (data modeling, DAX, report design).
• Experience with Azure Data Factory and/or Microsoft Fabric for pipeline development (or python pipeline development)
• Understanding of data warehouse design and ETL/ELT best practices
• Strong communication and stakeholder engagement skills.
• Customer service mindset with integrity, professionalism and confidentiality.
• Self-motivated, diligent, and results oriented.
• Willingness to learn and grow in a dynamic environment.
• Nice to have CI/CD understanding.

SOFYNE Active Technology has been integrating and deploying MES, LES and PLM solutions since 2005.

We support and advise more than 30 major industrial accounts in their innovation and digital transformation projects towards Industry 4.0.

With offices across Europe, we cover the audit, integration, evolution, application maintenance, support and change management needs of our customers.

Our approach is built around the framework and capabilities of a large company with the heart and soul of a small business, fostering high quality and performance services, agile development and added value for our clients, in the automotive, energy, aerospace and defense, consumer products and luxury sectors.

All this acquired knowledge is what enables us to best understand how these evolutions impact manufacturing information systems.

Sofyne Active Technology is certified with the international standard ISO27001.

Key Figures:

• 6 offices: Lyon (FR), Versailles (FR), Krakow (PL), Geneva (CH), London (UK), Porto (PT)
• 200 experts
• 35 customers (ranked in the Fortune Global 500)
• 30 000 days of project / year
• 1350 training days (2024)

SOFYNE is a talent maker!

#LI-KB1