Senior Software Engineer - Data Focused (Remote, Full-Time) [AS275]

**About Smart Working** At Smart Working, we believe your job should not only look right on paper but also feel right every day. This isn’t just another remote opportunity - it’s about finding where you truly belong, no matter where you are. From day one, you’re welcomed into a genuine community that values your growth and well-being. Our mission is simple: to break down geographic barriers and connect skilled professionals with outstanding global teams and products for full-time, long-term roles. We help you discover meaningful work with teams that invest in your success, where you’re empowered to grow personally and professionally. Join one of the highest-rated workplaces on Glassdoor and experience what it means to thrive in a truly remote-first world. **About the Role** As a Senior Software Engineer (Data-Focused), you will play a key role in supporting and maintaining a business-critical data platform responsible for calculating dentist pay across the UK. Working within an established engineering team, you will help ensure the reliability of complex data ingestion pipelines, resolve production issues, and contribute to tactical improvements that strengthen engineering processes and platform stability. This is a highly data-focused engineering position requiring strong problem-solving skills, the ability to work independently through ambiguity, and close collaboration within a Kanban team. You'll operate across a complex, heavily customised environment while helping introduce better engineering practices without undertaking a full platform rebuild. ### Responsibilities - Support and maintain data ingestion pipelines, including connectors that pull data from NHS systems, practice management systems, and laboratory or equipment sources using APIs and screen-scraping. - Own and support the BigQuery ingestion layer and the downstream SQL Server and SQL Azure processing responsible for calculating dentist pay. - Proactively identify, investigate and resolve data ingestion issues while improving platform observability and monitoring. - Handle enterprise customer support requests and tactical enhancement requests for the existing platform. - Work across a highly distributed, brownfield, heavily customised environment supporting multiple bespoke customer deployments. - Review and occasionally adjust SQL-driven commands used by the legacy on-premises Delphi connector where required. - Contribute to tactical process improvements, including introducing source control through GitHub Enterprise and improving CI/CD practices using Azure DevOps. - Perform light-touch maintenance of the existing .NET web application. - Trace and resolve complex issues across stored procedures, Common Table Expressions (CTEs), SQL Server business logic and distributed systems. - Solve ambiguous production problems independently while collaborating within a Kanban team. - Help improve SDLC controls and engineering processes in an environment where production changes currently occur without CI/CD safeguards. - Deliver careful production changes while responding quickly to live customer issues. ### Requirements - 5+ years’ experience in data engineering, including data pipelines and ingestion, ideally using GCP BigQuery, Airflow and Cloud Composer; equivalent large-scale data pipeline experience on another cloud platform may also be considered. - 5+ years’ experience with SQL Server and T-SQL, including stored procedures, Common Table Expressions (CTEs), and business logic implemented within the database. - 2+ years’ experience with GCP tooling, specifically BigQuery, Airflow and Cloud Composer; Azure Data Factory or a similar data integration platform may be considered as an alternative. - 2+ years’ experience with Azure, including SQL Azure, Azure Functions and Azure DevOps; equivalent AWS or GCP hosting experience may also be considered. ### Nice To Have - Experience with **.NET / C#** for maintaining and supporting existing applications. - Experience wor…