Data Engineer

Cardo Group is seeking a talented Data Engineer / Analytics Engineer with strong Azure experience to support the build, enhancement and ongoing modernisation of our Azure data platform. You'll work across multiple data sources (APIs, SQL databases, and legacy systems) to deliver clean, validated, well-structured datasets that power reporting and analytics across the organisation. This is a hands-on delivery role with light architectural input and close collaboration with our systems team, business analysts and data team., * Build, maintain and enhance Azure data pipelines using ADF, Azure Fabric, Azure Data Lake, SQL and related services.

• Lead and support the ingestion and migration of data from multiple sources including APIs, SQL databases and legacy on prem systems.
• Develop, optimise and maintain data models, schemas and tables for analytics, BI and operational reporting.
• Implement automated data QA, validation and completeness checks across pipelines and ingestions.
• Monitor, investigate and resolve pipeline failures, data integrity issues and performance bottlenecks.
• Apply agreed data standards and contribute to platform wide best practices.
• Work closely with business analysts to understand, translate and define business rules, logic and transformation requirements within the data layer.
• Maintain and develop the data dictionary, ensuring new sources, fields, logic changes and lineage are clearly documented and communicated.
• Contribute to outlining and documenting key architectural patterns, data flows and technical designs for the Azure platform.
• Work with SFTP connectors, scheduled file drops, webhook triggered ingestions and secure transfer mechanisms.
• Designing or maintaining API integrations (authentication, pagination, throttling, incremental loads) - depending on experience.
• Work with systems team and / or business analysts to clarify requirements, prioritise work and deliver robust data solutions.
• Support iterative platform improvements as the organisation consolidates and modernises its data estate.

• 2-4 years in a data engineer, analytics engineer or similar role.
• Strong hands on experience with Azure data tools (ADF, Synapse, Data Lake, Azure SQL, Fabric).
• Experience ingesting and transforming data from APIs, SQL databases and other heterogeneous sources.
• Good SQL skills and understanding of relational/analytical data modelling.
• Experience with data validation, reconciliation and QA processes.
• Working knowledge of SFTP, webhooks or secure data transfer patterns.
• Ability to collaborate effectively with business analysts and technical teams.

Advantageous Skills & Experience

• Experience with CI/CD, Git and DevOps practices.
• Familiarity with analytics engineering approaches (e.g., dbtstyle workflows).
• Broader cloud or software engineering experience.
• Experience with API integration development.

• Competitive Pay
• 25 days holiday, plus bank holidays
• Range of Salary Sacrifice Schemes [holiday purchase, EV schemes, AVC Pension contributions]
• Life Assurance cover
• Wellbeing Resources and Counselling services
• Retail & Lifestyle Discount Platform
• Enhanced Family Leave Provisions
• Recognition initiatives and awards

Please note all our roles are subject to Background, Identity & Security checks before commencement of employment.

Cardo Group is a trusted provider of building maintenance, refurbishment, and retrofit services for social housing and public sector buildings across the UK. With nationwide coverage and skilled local teams, we deliver a reliable end-to-end service that ensures homes and public spaces are safe, sustainable, and well-maintained. We specialise in responsive repairs and voids, planned maintenance, energy-efficiency upgrades, compliance works, and major improvement programmes. Our approach combines quality workmanship, strong resident communication, and efficient project delivery to achieve the best outcomes for customers and communities. Driven by ambitious growth plans, we continue to expand our capabilities and adapt to the evolving needs of our clients. Our reputation is built on consistent service delivery, trusted partnerships, and a commitment to doing things the right way. As we grow, so do the opportunities - for our people, our clients, and the communities we support. Cardo Group is becoming one of the UK's most forward-thinking maintenance and retrofit providers., Why Join Cardo Group? We are committed to creating a workplace where everyone feels valued, respected, and empowered to succeed. Diverse perspectives strengthen our business, drive innovation, and help us better serve the communities we work with. Our commitment to Equity, Diversity, and Inclusion is rooted in our core values: * Teamwork - We collaborate, support one another, and achieve more together. * Integrity - We act with honesty, fairness, and transparency in everything we do. * Excellence - We set high standards and deliver quality for our people and our customers. * Respect - We value every individual and create a space where all voices are heard. We ensure fair opportunities, embrace diverse backgrounds and experiences, and foster a culture where everyone truly belongs. Join us on our ambitious, exciting, and inclusive journey.