Data Integration Analyst at the LEGO Group

Billund, Region of Southern Denmark, Denmark -

Full Time

Start Date

Immediate

Expiry Date

05 Jun, 26

Salary

0.0

Posted On

07 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Migration, Data Mapping, Data Reconciliation, Advanced Excel, Power BI, SQL, Python, ETL/ELT, Data Quality, Data Modelling, Documentation, Root-Cause Analysis, Data Transformation, Version Control, Semantic Layer, Data Dictionaries

Industry

Manufacturing

Description

Job Description Join our team as a Data Integration Analyst: Enhance marketing investment data by unifying insights across platforms. Please note: This is a 12-month cover role at Lead Professional level, based out of our vibrant LEGO Campus (Billund). Relocation assistance is not available for this position. Core Responsibilities Historical data migration and alignment Manually remap, transform, and validate in-year and historical actuals from two legacy planning systems into a single planning platform. Resolve structural, field-level, and granularity differences to align with the target data model; reconcile results at record and aggregate levels to ensure completeness and accuracy. Analytical continuity Standardize legacy and current data to the target architecture to enable consistent year-over-year reporting and trend analysis. Maintain cross-system comparability by defining and applying clear mapping rules, hierarchies, and crosswalks for metrics and dimensions. Documentation and auditability Create and maintain audit-ready documentation of mapping logic, transformation rules, validation checks, and reconciliation outcomes. Establish version-controlled artifacts (e.g., mapping tables, data dictionaries, SOPs) to support audit requirements and provide a durable reference for future integrations. Collaboration and quality control Partner with data engineering, reporting, finance, and business stakeholders to validate outputs, gather feedback, and align on acceptance criteria. Proactively identify inconsistencies, perform root-cause analysis, and resolve issues in a structured, traceable manner; communicate status, risks, and impacts. Play your part in our team succeeding As a Data Integration Analyst, you oversee the migration of marketing investment data from various legacy systems to a unified platform. You take charge of remapping, validating, and reconciling records, addressing structural differences to ensure they fit the new architecture. With your attention to detail and strict quality controls, you guarantee data accuracy and consistency for reporting and analytics. Your efforts also facilitate knowledge transfer across teams, making a significant impact on how we work together. Do you have what it takes? Demonstrated experience in data migration, mapping, and reconciliation across disparate systems and data models. Advanced Excel proficiency (nested formulas, lookups/INDEX‑MATCH, pivot tables) and working knowledge of BI/reporting tools (Power BI preferred) and semantic layer concepts. Exceptional attention to detail with the ability to manage and quality‑check large, complex historical datasets. Strong documentation and process-tracking skills, including creating audit-ready artifacts and maintaining version-controlled materials. Experience in marketing investment, finance, or procurement data environments is an advantage Preferred tools and technical skills: Databricks (SQL, Python); builds auditable transformations and reconciliations in a bespoke cloud environment. Strong SQL; ETL/ELT and orchestration (e.g., Databricks Jobs, ADF/Airflow) for repeatable migration pipelines. Power BI/semantic models; advanced Excel/Power Query; Git-based version control; solid data modelling and data quality practices. #LI-SG2 #LI-Hybrid Applications are reviewed on an ongoing basis. However, please note we do amend or withdraw our jobs and reserve the right to do so at any time, including prior to any advertised closing date. So, if you're interested in this role we encourage you to apply as soon as possible. What’s in it for you? Here is what you can expect: Family Care Leave - We offer enhanced paid leave options for those important times. Insurances – All colleagues are covered by our life and disability insurance which provides protection and peace of mind. Wellbeing - We want our people to feel well and thrive. We offer resources and benefits to nurture physical and mental wellbeing along with opportunities to build community and inspire creativity. Colleague Discount – We know you'll love to build, so from day 1 you will qualify for our generous colleague discount. Bonus - We do our best work to succeed together. When goals are reached and if eligible, you'll be rewarded through our bonus scheme. Workplace - When you join the team you'll be assigned a primary workplace location i.e. one of our Offices, stores or factories. Our hybrid work policy means an average of 3 days per week in the office. The hiring team will discuss the policy and role eligibility with you during the recruitment process. Children are our role models. Their curiosity, creativity and imagination inspire everything we do. We strive to create a diverse, dynamic and inclusive culture of play at the LEGO Group, where everyone feels safe, valued and they belong. The LEGO Group is highly committed to equal employment opportunity and equal pay and seeks to encourage applicants from all backgrounds (eg. sex, gender identity or expression, race/ethnicity, national origin, sexual orientation, disability, age and religion) to apply for roles in our team. The LEGO Group is fully committed to Children’s Rights and Child Wellbeing across the globe. Candidates offered positions with high engagement with children are required to take part in Child Safeguarding Background Screening, as a condition of the offer. Thank you for sharing our global commitment to Children’s Rights. Just imagine building your dream career. Then make it real. Join the LEGO® team today. Children are our role models. Their curiosity, creativity and imagination inspire everything we do. Our founder Ole Kirk Kristiansen made his first wooden toy in 1932. He persevered against the odds until his business was a success. Constantly innovating, never compromising. Building, rebuilding, and striving for the best. It is this resilience and permanent sense of renewal that drives us forward. We are never still. We will always be creating, inventing, and having fun. Build your career brick by brick and play your part in continuing our mission to “inspire and develop the builders of tomorrow”.

Responsibilities

The Data Integration Analyst oversees the migration of marketing investment data from legacy systems to a unified platform, taking charge of remapping, validating, and reconciling records to fit the new architecture. This role requires strict quality controls to guarantee data accuracy and consistency for reporting and analytics while facilitating knowledge transfer across teams.