Remote Senior Data Engineer & Backend Developer (Azure)

Remote; San Francisco (CA); Remote; USD 170,000 - 230,000; Full time

Job summary

Smart Working is seeking a Senior Data Engineer / Developer to own data across the business, delivering end-to-end data engineering solutions and supporting backend development. This hands-on role will be ~75% data engineering and ~25% backend work, collaborating with the CFO and two developers to improve the data environment and enable better financial reporting.

You will build pipelines across Azure, HubSpot, Xero and Stripe, maintain Power BI, and translate business needs into practical data

Qualifications

• Strong SQL and T-SQL expertise with data modelling experience.
• Hands-on experience building and maintaining data pipelines and integrations within Microsoft Azure.
• Commercial backend development experience including REST API development and system integrations.
• Strong Power BI experience with DAX, Power Query, Dataflows and Paginated Reports.
• Ability to translate business and financial requirements into working data engineering solutions.
• End-to-end ownership of data engineering requirements from concept to production delivery.

Responsibilities

• Take end-to-end ownership of data across the business from concept through production.
• Collaborate with two developers for deeper application development.
• Prioritise payroll-related data needs and develop a new invoicing system.
• Assess and improve legacy SQL databases and the wider Azure data environment.
• Build and maintain data pipelines across Azure, HubSpot, Xero and Stripe.
• Analyse club financial performance and membership usage for reports and dashboards.
• Combine HubSpot and financial data to reveal campaign costs and CAC.

Skills

SQL

T-SQL

Data pipelines

Backend development

Power BI

Automation

English communication

Tools

Azure

Azure SQL

Azure Data Factory

Azure Data Lake Storage

REST APIs

Git

HubSpot

Xero

Stripe

Power Automate

Job description

Smart Working is seeking a Senior Data Engineer / Developer to own data across the business, delivering end-to-end data engineering solutions and supporting backend development. This hands-on role will be ~75% data engineering and ~25% backend work, collaborating with the CFO and two developers to improve the data environment and enable better financial reporting.

You will build pipelines across Azure, HubSpot, Xero and Stripe, maintain Power BI, and translate business needs into practical data