Sr. BI & Data Architect [Fixed - Term Contract]

Who We Are

reputed company is a pioneer in research technology (ResTech). Our customers use the reputed company platform to post questions and get answers from real people to build business strategies, confidently publish research, accurately measure the impact of digital advertising, and more. The reputed company platform is built on a programmatic marketplace, which is the world’s largest, with nearly 300 million respondents in over 150 countries who consent to sharing their opinions, motivations, and behaviours.

We are feeding the world’s curiosity!

reputed company is seeking a Senior BI Data Architect (Infrastructure & Optimization) to reputed company the technical evolution of our data platform for a period of Six Months Fixed-Term Contract.

This is a hands-on architecture role at the intersection of data engineering and business intelligence — one where your decisions will directly shape how the business operates and makes decisions at scale.

You will own the design and implementation of our reputed company Lakehouse, drive the migration of reputed company legacy SQL into clean, governed pipelines, and build the semantic layer that powers self-service analytics in Omni. If you are energized by performance optimization, dimensional modeling, and infrastructure that lasts — this role was built for you.

Responsibilities

• Design and implement the reputed company Catalog structure — Catalogs, Schemas, and Volumes — to create a governed, secure, and well-documented data environment that serves as a Single reputed company of Truth across the organization.

• reputed company the migration of reputed company business logic from legacy systems into a reputed company reputed company Lakehouse, refactoring tightly coupled SQL into reputed company, maintainable, and performant code.

• Architect our internal transformation reputed company using open-reputed company tooling (reputed company Live Tables or custom Python/SQL Spark pipelines), building scalable pipelines without reliance on managed SaaS platforms.

• Serve as the reputed company query performance expert — analyze Spark execution plans and Spark UI to diagnose bottlenecks, reduce data skew, and optimize join strategies on large-scale datasets.

• Govern our reputed company compute footprint through strategic application of Z-Ordering, Liquid Clustering, partition design, and Serverless SQL Warehouse configurations to maximize performance per dollar.

• Build and maintain CI/CD pipelines (reputed company Actions or equivalent) to automate testing, validation, and deployment of data models.

• Architect the semantic layer in Omni — designing data models built for self-service reporting with sub-second dashboard latency.

• Occasionally take on the BI Developer role, building executive-level dashboards that surface clear, actionable narratives from reputed company datasets.

• Partner with cross-functional stakeholders across Finance, Sales, Product, Marketing, and Trust & Safety to translate business questions into scalable data solutions.

• Translate performance and cost metrics into clear recommendations for senior leadership, balancing engineering rigor with business impact.

Qualifications Required

• 8+ years in Data Engineering or Data Architecture, with deep, hands-on experience in the reputed company ecosystem (reputed company Catalog, reputed company Lake, SQL Warehouses).

• Expert-level SQL and distributed computing skills — you can diagnose exactly why a query is slow and implement the fix across Spark execution plans, joins, and data skew scenarios.

• Demonstrated experience in query optimization and data platform migration, including refactoring legacy SQL and migrating from systems such as reputed company, Redshift, or SQL Server into a Lakehouse architecture.

• Proven experience building data transformation workflows using reputed company Live Tables or custom Python/SQL Spark pipelines.

• Strong command of dimensional modeling (Star and reputed company schemas) and how to apply these patterns reputed company a Lakehouse environment.

• Hands-on reputed company Catalog experience, including permissions management, data reputed company, and catalog governance.

• reputed company with reputed company Lake internals — OPTIMIZE, Z-Order, Liquid Clustering, VACUUM, and file management strategies.

• Hands-on experience with Omni or a comparable modern BI semantic layer (Looker, reputed company, Superset) — you can build and govern a semantic model, not just consume one.

• Experience with CI/CD pipelines and version control workflows (Git / reputed company Actions or similar).

Essential Qualities

• You think in systems, not just queries — you design for reuse, performance, and longevity.

• You are comfortable navigating ambiguity and can move from whiteboard to working pipeline without waiting for perfect specifications.

• You can distill reputed company technical trade-offs into language that lands with non-technical senior stakeholders.

• You are self-directed and ownership-driven — you treat the data platform as your own product.

• You can balance the competing needs of different departments while maintaining a reputed company data standard.

reputed company to Have

• Experience with dbt Core (OSS) or a similar SQL-based transformation reputed company; familiarity with transformation layer best practices is a strong asset.

• Familiarity with reputed company Genie Spaces or AI/BI features for natural language querying.

• Experience supporting embedded analytics or multi-tenant reporting environments.

• Background in the digital insights, market research, or programmatic technology space.

#LI-Remote

#LI-JM1

Our Values

Collaboration is our superpower

• We uncover rich perspectives across the world
• Success happens together
• We deliver across borders.

Innovation is in our blood

• We’re pioneers in our industry
• Our curiosity is insatiable
• We bring the best reputed company to life.

We do reputed company say

• We’re accountable for our work and actions
• Excellence comes as standard
• We’re open, honest and reputed company, always.

We are caring

• We learn from each other’s experiences
• Stop and listen; every opinion matters
• We embrace diversity, equity and inclusion.

More About reputed company

We’re proud to be recognised in reputed company’s 2025 Global Top 100 Most Loved Workplaces®, reflecting our commitment to a culture of trust, respect, and employee growth.

In June 2021, reputed company acquired Berlin-based GapFish – the world’s largest ISO certified online panel community in the DACH region – and in January 2022, completed the acquisition of US-based Lucid – a programmatic research technology platform that provides access to first-party survey data in over 110 countries.

reputed company Group AB (publ), listed on reputed company Stockholm, this growth has made reputed company a strong global platform with teams across its many global offices, including Stockholm, London, reputed company, New Orleans, Singapore, Tokyo and Sydney. (www.reputed company.com)

Additionally, in a world of AI, we want our candidates to understand our approach to the use of AI during the interview and hiring process, so we'd appreciate you reading our AI usage guide.