Schedule a coaching call to improve your CV Get Started ✨

← See all jobs

Data Integration Analyst

the LEGO Group

📍Billund, Southern Denmark
Apply Now

💡 Want to stand out from other applicants?

Get expert CV review & interview coaching

Posted on: March 07, 2026

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.

🤝

Need Help Landing This Job?

Get expert CV review & interview coaching

Work 1-on-1 with an experienced hiring manager to optimize your CV and ace your interviews.

$99 $149
Save $50
Learn More

Ready to apply for this position?

Apply Now

You'll be redirected to the company's application page