smart-working-solutions - Senior Data Engineer / Developer (Remote, Full-Time) [HR221]
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, limitations and alternative business intelligence solutions without being dependent on a single tool. • Experience automating business processes and data workflows, with the ability to deliver practical automation solutions. • Proven 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 to production delivery. • Strong data engineering expertise combined with genuine backend development capability, suitable for a role split 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, with 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. • Experience working 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.
Responsibilities
• Take end-to-end ownership of data across the business, independently managing requirements from concept through to production. • Collaborate with two existing developers where deeper application development is required. • Prioritise payroll-related data requirements and develop a new invoicing system to automate the existing 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, accounting for approximately 25% of the role. • Maintain the existing Power BI environment and evaluate its suitability against cost and reporting requirements, recommending alternative tools where they provide better value. • Automate manual business processes and data handling using Power Automate or other appropriate tools. • Work closely with the CFO and leadership to translate financial and business requirements into practical data solutions. • Deliver meaningful analysis against established business KPIs, supporting financial reporting and decision-making. • Evaluate technical approaches pragmatically, prioritising improvements to existing systems where appropriate rather than unnecessary rebuilds. • Handle sensitive payroll and financial information responsibly, maintaining appropriate confidentiality and care.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT