Senior Data Engineer / Developer (Remote, Full-Time) [HR221]

Smart Working Solutions

2d•Remote

About The Position

As a Senior Data Engineer / Developer, you will take primary ownership of data across the business, delivering end-to-end data engineering solutions and supporting backend development. This senior, hands-on role is approximately 75% data engineering and 25% backend development. You will work closely with the CFO on financial analysis and reporting, and alongside two existing developers when deeper application development is needed. The role focuses on improving the existing data environment, supporting financial operations, and delivering practical solutions that improve efficiency and business visibility. You will work independently, own work from concept through production, and make commercially sensible technical decisions. This is primarily a data ownership and engineering position rather than a reporting-focused or data analyst role. The position includes work across Azure, HubSpot, Xero, Stripe, and Power BI, including data pipelines and integrations, financial and membership analysis, backend data services and REST APIs, and automation of manual business processes. You will collaborate with the CFO and leadership to turn business and financial requirements into practical solutions, while handling sensitive payroll and financial information with care.

Requirements

Strong SQL and T-SQL expertise, including data modelling and experience improving legacy SQL databases.
Hands-on experience building and maintaining data pipelines and integrations within Microsoft Azure, including Azure SQL, Azure Data Factory, and Azure Data Lake Storage.
Commercial backend development experience, including REST API development, system integrations, and Git.
Strong Power BI experience, including DAX, Power Query / M, Dataflows, and Paginated Reports.
Ability to evaluate Power BI costs and limitations and assess alternative business intelligence solutions without depending on a single tool.
Experience automating business processes and data workflows and delivering practical automation solutions.
Ability to translate business and financial requirements into working data engineering solutions.
Demonstrated end-to-end ownership of data engineering requirements, from initial concept through production delivery.
Strong data engineering expertise combined with backend development capability, suited to a role split of approximately 75% data engineering and 25% backend development.
Experience working with existing or legacy data environments and identifying pragmatic improvements.
Excellent spoken English communication skills, including the ability to explain technical work and sensitive financial information clearly to the CFO and senior leadership.
Ability to work independently, take initiative, and deliver solutions without relying on detailed specifications.
Collaborative approach to working with a small development team while maintaining ownership of individual deliverables.
Commercial awareness and sound technical judgement, including the ability to recommend more cost-effective tools or approaches.
Trustworthiness and discretion when handling confidential payroll, financial, and business information.

Nice To Haves

Experience with financial processes and systems, including payroll, invoicing, billing automation, Xero, or Stripe.
Experience in financial modelling and forecasting.
Experience with .NET and Azure application development.
Experience working with HubSpot data, marketing cost analysis, or marketing attribution.
Familiarity with Metabase or other business intelligence and reporting tools.
Experience using Fivetran.

Responsibilities

Take end-to-end ownership of business data requirements, managing work independently from concept through production.
Collaborate with two existing developers when deeper application development is required.
Prioritise payroll-related data requirements and develop a new invoicing system to automate the highly manual invoicing process.
Assess the legacy SQL database and wider Azure data environment, recommending and implementing practical improvements.
Build and maintain data pipelines and integrations across Azure, HubSpot, Xero, and Stripe.
Analyse club financial performance and membership utilisation, producing reports for clubs and internal dashboards.
Combine HubSpot and financial data to provide visibility into campaign costs, customer acquisition costs, and overall business costs.
Develop data services, REST APIs, and backend functionality to integrate data and insights into the application.
Maintain the existing Power BI environment and evaluate its suitability against cost and reporting requirements; recommend alternative tools where they provide better value.
Automate manual business processes and data handling using Power Automate or other appropriate tools.
Work with the CFO and leadership to translate financial and business requirements into practical data solutions.
Deliver analysis against established business KPIs to support financial reporting and decision-making.
Evaluate technical approaches pragmatically, prioritising improvements to existing systems over unnecessary rebuilds.
Handle sensitive payroll and financial information responsibly and confidentially.