This opportunity offers the chance to take ownership of a customer-focused Golden Layer data domain within a remote working environment connected to Canary Wharf. The role is centred on Databricks, SQL, Python/Spark, dimensional modelling, and high-volume transaction processing, with responsibility for data quality, lineage, workflow scheduling, and runtime optimisation. This position will play an important part in shaping scalable data products and supporting analytics consumers through well-defined technical standards and interface contracts.
Required Experience:
- Experience owning Golden Layer facts and dimensions, including customer, identifier, consent, transaction, redemption, and feedback models
- Experience with source-to-target mapping, SCD history handling, CDC, and historical backfill
- Experience resolving cross-system data quality issues and historical reload challenges
- Experience supporting orchestration, CI/CD, testing, observability, and production environments
- Experience working with high-volume transaction processing and performance optimisation
Required Skills:
- Expert SQL
- Strong Python and Spark capability
- Strong Databricks expertise
- Dimensional modelling and data product modelling
- SCD1 and SCD2 design and implementation
- Workflow scheduling, trigger dependency management, and freshness monitoring
- Data lineage, data quality management, and technical documentation
- Ability to define technical standards and interface contracts for downstream consumers
Preferred Qualifications:
- Experience in CRM, loyalty, consent, and customer identity domains
- Exposure to CIS, Comarch, SFMC, AWS/Data Hub, and analytics consumer environments
About Airswift:
Airswift is an international workforce solutions provider within the energy, process and infrastructure industries. Airswift serves as a strategic partner to clients, offering a turnkey workforce solution to capture and deliver the top talent needed to complete successful projects by aligning with unique project needs. With over 1000 employees and 9,000 contractors operating in over 60 countries, Airswift's geographical reach and pool of talent available is unmatched in the industry.