Data Integration & Reporting Lead

Birmingham
1 week ago
Create job alert

We are looking for a Data Integration & Reporting lead to assess the data landscape across nine manufacturing sites and develop a plan for integrating data into a single source of truth.

Each site currently operates on different ERP systems (Microsoft Business Central, NAV 2018, SAP ECC 5), leading to fragmented financial and customer data. The long-term goal is to centralise data using a Microsoft Fabric-based data warehouse, but first, we need a clear understanding of our existing capabilities, gaps, and business needs.

This 3-month contract will focus on:

Assessing how data is currently structured and used across different sites.
Identifying key challenges in financial and operational reporting.
Building a proof of concept (POC) using Power BI, SQL, and Power Automate.
Providing strategic recommendations for data integration and governance.

Key Responsibilities:

  1. Data Capability & System Assessment

    Map out how financial and customer data is stored and used across sites.
    Engage with finance, IT, and operational teams to understand key reporting pain points.
    Identify data inconsistencies, manual processes, and reporting inefficiencies.

  2. Proof of Concept (POC) & Technical Validation

    Use Power BI to demonstrate how consolidated reporting could work.
    Apply SQL to extract and standardise key data sets from different ERPs.
    Explore Power Automate to reduce manual data handling.

  3. Data Integration & Future Strategy

    Define what data needs to be centralised for better financial and operational visibility.
    Recommend an approach for transitioning towards a centralised Microsoft Fabric data warehouse.
    Develop a roadmap for data governance and integration best practices.

    Key Skills & Experience:

    Proven experience in data integration, strategy, or business intelligence consulting.
    Strong Power BI and SQL skills for prototyping reporting improvements.
    Experience with ERP systems (Business Central, NAV, SAP) and understanding how financial data is structured.
    Knowledge of data warehousing principles (Microsoft Fabric experience is a plus).
    Strong business engagement skills—able to speak with finance, IT, and operations teams to understand reporting needs.

    Ideal Candidate:

    A data strategist who can assess existing systems and recommend a path forward.
    Someone with experience consolidating data across multiple ERPs

Related Jobs

View all jobs

Data Integration Manager

Business Intelligence(BI) Lead

Business Intelligence Technical Lead

Lead Power BI Developer

Data Engineering Lead - AWS & Snowflake

Data Architect / Sr Data Engineer London

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Navigating Data Science Career Fairs Like a Pro: Preparing Your Pitch, Questions to Ask, and Follow-Up Strategies to Stand Out

Data science has taken centre stage in the modern workplace. Organisations rely on data-driven insights to shape everything from product innovation and customer experience to operational efficiency and strategic planning. As a result, there is a growing need for skilled data scientists who can analyse large volumes of data, build predictive models, communicate findings effectively, and collaborate cross-functionally. If you are looking to accelerate your data science career—or even land your first role—attending data science career fairs can be a game-changer. Unlike traditional online applications, face-to-face interactions let you showcase your personality, passion, and communication skills in addition to your technical expertise. However, to stand out in a busy environment, you need a clear strategy: from polishing your personal pitch and asking thoughtful questions to following up with a memorable message. In this article, we’ll guide you through every step of making a strong impression at data science career fairs in the UK and beyond.

Common Pitfalls Data Science Job Seekers Face and How to Avoid Them

Data science has become a linchpin for decision-making and innovation across countless industries, from finance and healthcare to tech and retail. The demand for data scientists in the UK continues to climb, with businesses seeking professionals who can interpret complex datasets, build predictive models, and communicate actionable insights. Despite this high demand, the job market can be extremely competitive—and many applicants unknowingly fall into avoidable traps. Whether you’re an aspiring data scientist fresh out of university, a professional transitioning from a quantitative role, or a seasoned analyst looking to expand your skill set, it’s crucial to navigate your job search effectively. In this article, we explore the most common pitfalls data science job seekers face and provide pragmatic advice to help you stand out. By refining your CV, portfolio, interview strategies, and communication skills, you can significantly increase your chances of landing a rewarding data science role. If you’re looking for your next data science job in the UK, don’t forget to explore the listings at Data Science Jobs. Read on to discover how to avoid critical mistakes and position yourself for success.

Career Paths in Data Science: From Entry-Level Analysis to Leadership and Beyond

Data is the lifeblood of modern business, and Data Scientists are the experts who turn raw information into strategic insights. From building recommendation engines to predicting market trends, the impact of data science extends across virtually every industry—finance, healthcare, retail, manufacturing, and beyond. In the UK, data-driven decision-making is critical to remaining competitive in a global market, making data science one of the most sought-after career paths. But how does one launch a career in data science, and how can professionals progress from entry-level analysts to senior leadership roles? In this comprehensive guide, we’ll explore the typical career trajectory, from junior data scientist to chief data officer, discussing the key skills, qualifications, and strategic moves you need to succeed. Whether you’re a recent graduate, transitioning from another technical field, or an experienced data scientist aiming for management, you’ll find actionable insights on forging a successful career in the UK data science sector.