Sr. BI & Data Architect [Fixed Term Contract] at Cint

United Kingdom

Company Description Who We Are Cint is a pioneer in research technology (ResTech). Our customers use the Cint 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 Cint 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! Job Description Cint is seeking a Senior BI Data Architect (Infrastructure & Optimization) to lead the technical evolution of our data platform for a period of 6-8 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 Databricks Lakehouse, drive the migration of complex 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 Unity Catalog structure — Catalogs, Schemas, and Volumes — to create a governed, secure, and well-documented data environment that serves as a Single Source of Truth across the organization. Lead the migration of complex business logic from legacy systems into a unified Databricks Lakehouse, refactoring tightly coupled SQL into modular, maintainable, and performant code. Architect our internal transformation framework using open-source tooling (Delta Live Tables or custom Python/SQL Spark pipelines), building scalable pipelines without reliance on managed SaaS platforms. Serve as the resident 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 Databricks 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 (GitHub 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 complex 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 Qualifications Required 8+ years in Data Engineering or Data Architecture, with deep, hands-on experience in the Databricks ecosystem (Unity Catalog, Delta 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 Snowflake, Redshift, or SQL Server into a Lakehouse architecture. Proven experience building data transformation workflows using Delta Live Tables or custom Python/SQL Spark pipelines. Strong command of dimensional modeling (Star and Snowflake schemas) and how to apply these patterns within a Lakehouse environment. Hands-on Unity Catalog experience, including permissions management, data lineage, and catalog governance. Fluency with Delta 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, Metabase, Superset) — you can build and govern a semantic model, not just consume one. Experience with CI/CD pipelines and version control workflows (Git / GitHub 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 complex 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 unified data standard. Nice to Have Experience with dbt Core (OSS) or a similar SQL-based transformation framework; familiarity with transformation layer best practices is a strong asset. Familiarity with Databricks 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. Additional Information #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 ideas to life. We do what we say We’re accountable for our work and actions Excellence comes as standard We’re open, honest and kind, 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 Cint We’re proud to be recognised in Newsweek’s 2025 Global Top 100 Most Loved Workplaces®, reflecting our commitment to a culture of trust, respect, and employee growth. In June 2021, Cint 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. Cint Group AB (publ), listed on Nasdaq Stockholm, this growth has made Cint a strong global platform with teams across its many global offices, including Stockholm, London, New York, New Orleans, Singapore, Tokyo and Sydney. (www.cint.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.