BI Data Engineer

Coats is a world leader in thread manufacturing and structural components for apparel and footwear, as well as an innovative pioneer in performance materials. These critical solutions are used to create a wide range of products, including ones that provide safety and protection for people, data and the environment.

Trusted by the world's leading companies to deliver crucial, innovative, and sustainable solutions, we provide value-adding products including apparel, footwear and specialty threads.

With a proud heritage dating back more than 250 years and a spirit of evolution to constantly stay ahead of changing market needs, we have operations across 50 countries with a workforce of over 17,000, serving our customers worldwide.

Following the acquisition of Texon and Rhenoflex, new Coats Footwear now has a complete range of footwear components to meet your needs, from heel counters to toe puffs and everything in-between. Through our technologically diverse product portfolio, we can cater to both current and future trends, setting new standards in the process, turning customer ideas into a reality and accelerating sustainability.

Headquartered in the UK, Coats* connects talent, textiles, and technology to make a better and more sustainable world.

For more info, visit our website: www.coats.com

Role Purpose:

A BI Data Engineer is responsible for designing, building, and optimizing scalable data solutions that enable reliable reporting and data-driven decision-making across the organization. The role supports business performance by transforming data from enterprise systems into high-quality, performance-optimized analytics assets, ensuring accuracy, consistency, and accessibility of information for stakeholders.

This position involves implementing backend data engineering processes to integrate data from SAP, SAP BW, databases, and third-party systems into target platforms such as Azure Data Factory and Microsoft Fabric. Responsibilities include developing and maintaining ETL/ELT pipelines, building data models in data warehouses and lakehouses, optimizing Power BI semantic models and datasets, and automating reporting processes using Azure Power Platform while ensuring performance and capacity efficiency.

In addition, the Data Engineer must independently develop Power BI dashboards and reports that deliver meaningful insights, KPIs, and performance metrics through effective data modeling and visualization design.

The role also contributes to data governance using Microsoft Fabric capabilities, including managing data catalog structures, and works closely with business users to translate analytical requirements into scalable technical solutions while supporting modernization and platform migration initiatives.

Principal Accountabilities and Key Activities

Products

• Design secure and resilient IT solutions across the Coats Data Landscape including Azure, SAP BI, etc.
• Azure Data Services for data engineering tasks (e.g., Azure Data Factory, Azure Synapse, Azure SQL).
• Power BI for dashboard development and reporting.
• MS SQL for database management and query development.
• SAP BI, SAP DS, and HANA SQL (added advantage).
• Microsoft Fabric for integrated data solutions across data engineering, analytics, and governance.
• Data Cataloging tools and practices for managing data assets and ensuring data discoverability
• Ensuring data accuracy and consistency.

Process

• Deliver timely services to meet agreed business outcomes.
• Design, develop, and deploy interactive reports and dashboards in Power BI.
• Utilize complex DAX formulas for data analysis and visualization.
• Implement ETL (Extract, Transform, Load) processes for data integration.
• Automate data processes using Azure Power Platform (Power Automate, Power Apps).
• Work closely with business users to gather reporting requirements and identify key metrics.
• Deliver quick wins for urgent reporting needs within 1-2 weeks.
• Create detailed plans with estimated timelines for complex requests.
• Support and train BI power users in report development and insights generation.
• Leverage Microsoft Fabric for seamless data integration, management, and governance.
• Develop and maintain a data catalog to ensure organized, well-documented, and easily accessible data assets.
• Project Delivery as required

Partners

• Internal teams: Work with BI and other Data Teams.
• Business stakeholders: Liaise with business users to gather and refine reporting requirements.
• External vendors (if needed): Collaborate on integrating third-party tools or resolving specific technical challenges.
• Provide Subject Matter expertise to functional engagement activity.

Education, Qualifications and Experience

Essential

IT professional

• Bachelor's or Master degree in Computer Science, Information Technology, Data Management, Data Science, or a related field.
• 3+ years of experience in BI development and Support Projects with expertise on Data Extraction, Modelling, Reporting and Support.
• Strong experience in Power BI, including DAX, data modeling, and report/dashboard creation with visualizations and data insights.
• Proficiency in MS SQL for complex queries and database management.
• Experience with Azure Data Engineering tools (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database).
• Automation experience with Azure Power Platforms (Power Automate, Power Apps, etc).
• Solid knowledge of Microsoft Fabric for unified data solutions across engineering and analytics.
• Good knowledge of creating and managing a data catalog to improve data organization and accessibility.
• Good Understanding of SAP Functional Modules Flow
• Excellent communication, analytical and presentation skills with ability to work in fast paced environments

Desirable

• Exposure to SAP BI, SAP Data Services, and HANA SQL.
• Microsoft certifications (e.g., Data Analyst Associate, Azure Data Engineer, Microsoft Fabric).
• Strong communication, collaboration, and problem-solving skills.
• Ability to prioritize tasks and meet deadlines in a fast-paced environment
• ITIL awareness
• Project / Program Management certification
• Subject Matter Certification
• Data Science exposure