Job Description
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.
Top Skills
What We Do
We are the LEGO Group, the company behind the world’s most loved LEGO® bricks. Our brand name derived from the two Danish words Leg Godt, which mean “Play Well”.
We’ve been sparking imaginations and inspiring the builders of tomorrow since 1932. This is our mission and what motivates our colleagues around the world every day.
Today, we remain proudly family-owned with headquarters in Billund, Denmark. We have regional hubs in Boston, USA; London, UK; Shanghai, China; and Singapore, as well as 7 manufacturing facilities around the world.
These places are home to 28,000+ colleagues in everything from design and engineering to digital technology and marketing. Together we learn, imagine and build – creating play experiences that are sold in over 130 countries worldwide.
A purposeful and responsible global brand where creativity helps to inspire builders all around the world. Just imagine being part of that!
