Senior Solution Architect, Data & Analytics

As a Solution Architect for D&A, you'll bring energy, curiosity, and pragmatism to shaping Pandora’s D&A journey and direction and you will be responsible for designing and delivering end-to-end data platform solutions across our Data platform stack - Azure Synapse, and Databricks environments at Pandora.

In this hands-on architectural role, you will translate business requirements into technical solutions, work alongside lead engineers to propose architectural direction, and guide implementation across key transformation projects including SAP, Salesforce, POS and o9. Working "in the trenches" with engineering teams across supply chain, commerce, manufacturing, corporate tech and omni-channel, you will ensure solutions are scalable, maintainable, and aligned with data solution architecture principles, enabling Pandora's journey to becoming the world's leading jewellery company.

Key accountabilities include:

• Designing end-to-end data platform solutions (Azure Synapse platform, Databrick platform) that align with data solution architecture principles.
• Working directly with lead engineers to propose architectural direction, review technical designs, and ensure solutions meet scalability, performance, and maintainability requirements.
• Providing architectural guidance across transformation projects (SAP S/4HANA, Salesforce, o9, POS implementations) ensuring data integration patterns support business objectives.
• Designing integration architectures that connect source systems (SAP, Salesforce, o9, POS, e-commerce) to our data platform through our streaming platform Kafka.
• Architect Databricks wheels and DevOps artifacts and enablers for engineering teams.
• Architecting solutions for both centralised approaches (Synapse with CDM/RDM models, tabular models in Analysis Services) and lakehouse patterns (Databricks with decentralized principles).
• Reviewing and providing feedback on technical designs and code architecture from lead engineers, ensuring adherence to data platform standards and best practices.
• Defining and documenting solution patterns and best practices that builds quality across our data products.
• Leading technical design sessions with engineering teams, stakeholders, and lead engineers to solve complex data platform challenges collaboratively.
• Creating technical documentation including solution designs, architecture decision records (ADRs), data flow diagrams, and integration specifications.
• Supporting modernisation and migration from legacy to cloud-native solutions, designing transitional architectures that maintain business continuity.
• Mentoring teams on solution design patterns, cloud-native architecture, and data platform best practices through hands-on collaboration.

What is needed to succeed:

• 5-7+ years of hands-on experience designing and implementing data platform solutions with proven delivery of production-grade systems at scale.
• Strong Python development skills for data engineering workflows, and experience with orchestration frameworks and testing patterns.
• Strong SQL development skills including query optimization, indexing strategies, partitioning design, and performance tuning across SQL Server, Azure Synapse dedicated pools, and Databricks SQL.
• Deep experience with Databricks lakehouse architecture, working with Delta Lake features (ACID transactions, time travel, merge operations), implementing medallion architectures, and designing data products with clear interfaces.
• Technical expertise with Azure Synapse including designing star schemas and optimization techniques specific to each compute option.
• Practical experience designing end-to-end data pipelines including orchestration with Azure Data Factory or Databricks workflows, implementing error handling, retry logic, monitoring, and alerting patterns.
• Practical experience with streaming architecture and lambda architecture.
• Experience designing data quality frameworks as computational governance, embedding validation rules, data contracts, and quality checks within pipeline logic rather than post-processing validation.
• Demonstrated experience architecting solutions across both centralised patterns (dimensional modeling, Kimball, tabular models) and federated patterns (lakehouse, data mesh principles).
• Practical knowledge of tabular model design in Analysis Services, including DAX calculations, aggregations, partitioning strategies, and query performance optimization for Power BI consumption.
• Understanding of retail, manufacturing, finance or supply chain business processes and how data flows through a business.
• Strong collaboration skills working with lead engineers and development teams in a peer-based environment, proposing architectural direction and reviewing technical designs collaboratively.
• Ability to work "in the trenches" alongside engineering teams, writing code when needed to prove concepts or unblock teams, while maintaining architectural perspective.
• Excellent communication skills translating technical architecture into understandable concepts for both technical and business stakeholders, including creating solution designs, architecture decision records, and data flow diagrams.

Did we get your attention?

We hope you got all your questions answered and feel confident applying for this position. If you see yourself in the role and would like to become a part of Pandora’s future, please do not hesitate to apply! We are an international team, so please make sure to send us your application in English to be considered. We look forward to hearing from you!

We process applications on a continuous basis, which is why we encourage you to send your application as soon as possible. You can also read more about Pandora on our corporate site www.pandoragroup.com.

Icing on the cake
You will be working out of our beautiful Digital & Technology Hub in Copenhagen, in a rapidly growing environment of highly skilled and experienced colleagues, which is a key initiative that goes along with Pandora’s experience & ambitions.Besides our beautiful interior design, we are also proud of our LEED Gold Certification for Energy and Environmental Design. This means that we use as few natural resources as possible and that we use them with respect. The result is a professional and dynamic space that is unique, comfortable and inspirational – and delivers a true Pandora experience to anyone who works here or comes to visit.

About Pandora 
Pandora is the world's largest jewellery brand, specialising in the design, crafting and marketing of accessible luxury jewellery made from high-quality materials. Each piece is created to inspire self-expression, allowing people to share their stories and passions through meaningful jewellery. Pandora jewellery is sold in more than 100 countries through 6,800 points of sale, including more than 2,700 concept stores. 

Headquartered in Copenhagen, Denmark, Pandora employs 37,000 people worldwide and crafts its jewellery using only recycled silver and gold. Pandora is committed to leadership in sustainability and has set out to halve greenhouse gas emissions across its value chain by 2030. Pandora is listed on the Nasdaq Copenhagen stock exchange and generated revenue of DKK 31.7 billion (EUR 4.2 billion) in 2024. 

Recognised by the Financial Times as one of Europe’s Best Workplaces and ranked #1 among Danish companies, Pandora is committed to building an inclusive and diverse workplace. We believe that reflecting the diversity of society in how we engage with our customers is essential to fulfilling our purpose: to give a voice to people’s loves. We are dedicated to nurturing a culture where everyone feels respected, valued, and empowered to thrive.