At a Glance
- Tasks: Design and implement data pipelines, create dashboards, and support users with BI tools.
- Company: SOFYNE is a tech leader in digital transformation for major industries since 2005.
- Benefits: Enjoy remote work options, training opportunities, and a dynamic work environment.
- Other info: Work with top clients and gain exposure to cutting-edge technologies.
- Why this job: Join a collaborative team making an impact in Industry 4.0 with innovative solutions.
- Qualifications: Experience in BI roles, strong SQL skills, and proficiency in Power BI required.
The predicted salary is between 42000 - 84000 £ per year.
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
#J-18808-Ljbffr
Data Analytics Engineer Development and Integration / Consulting & Business Transformation · Lo[...] employer: SOFYNE ACTIVE TECHNOLOGY
Contact Detail:
SOFYNE ACTIVE TECHNOLOGY Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analytics Engineer Development and Integration / Consulting & Business Transformation · Lo[...]
✨Tip Number 1
Familiarise yourself with the specific Microsoft technologies mentioned in the job description, such as Azure Data Factory and Power BI. Having hands-on experience or projects showcasing your skills in these areas can set you apart from other candidates.
✨Tip Number 2
Network with current employees or professionals in the field through platforms like LinkedIn. Engaging in conversations about their experiences at SOFYNE can provide valuable insights and potentially give you a referral.
✨Tip Number 3
Prepare to discuss your previous projects that involved data pipelines and SQL transformations. Be ready to explain your thought process and the impact of your work on business outcomes, as this will demonstrate your practical knowledge and problem-solving skills.
✨Tip Number 4
Showcase your communication skills by preparing examples of how you've successfully collaborated with stakeholders in the past. This role requires strong engagement with various departments, so highlighting your ability to gather requirements and deliver training will be beneficial.
We think you need these skills to ace Data Analytics Engineer Development and Integration / Consulting & Business Transformation · Lo[...]
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data analytics, SQL scripting, and Power BI. Use keywords from the job description to demonstrate that you meet the specific requirements of the Data Analytics Engineer role.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data analytics and your understanding of SOFYNE's mission. Mention specific projects or experiences that align with the responsibilities outlined in the job description.
Showcase Technical Skills: In your application, emphasise your proficiency in Azure Data Factory, SQL Server, and Python. Provide examples of how you've used these technologies to solve problems or improve processes in previous roles.
Highlight Collaboration Experience: Since the role involves working with various stakeholders, include examples of past collaborations. Describe how you gathered requirements and translated them into technical solutions, showcasing your communication skills.
How to prepare for a job interview at SOFYNE ACTIVE TECHNOLOGY
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, Power BI, and Azure Data Factory. Bring examples of past projects where you designed data pipelines or created dashboards, as this will demonstrate your hands-on expertise.
✨Understand the Business Context
Research SOFYNE and its role in digital transformation. Understand how data analytics contributes to their success and be ready to discuss how you can add value to their projects and clients.
✨Prepare for Stakeholder Engagement
Since collaboration is key in this role, think of examples where you've successfully gathered requirements from stakeholders. Be ready to explain how you translated those needs into technical solutions.
✨Demonstrate a Customer Service Mindset
Highlight your ability to communicate effectively and support end users. Share experiences where you provided training or assistance, showcasing your professionalism and commitment to customer satisfaction.