BI Developer

SAGE GROUP PLC; North East; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading technology company in the UK is seeking a BI Developer to transform raw data into reliable datasets for analytics and insights. This role involves building efficient data pipelines, collaborating with stakeholders, and supporting the integration of AI in workflows. Ideal candidates should have over 3 years of data engineering experience, with strong skills in data transformation and tools like SQL and Power BI. This hybrid role requires both independent and collaborative work in a fast-paced environment.

Benefits

Comprehensive health, dental, and vision coverage

Work away scheme for up to 10 weeks a year

On-going training and professional development

Paid 5 days yearly to volunteer through Sage Foundation

Flexible work patterns

Qualifications

• 3+ years of experience in data modelling, data engineering, or a related analytical role.
• Experience with AI and machine learning integration in workflows is desirable.
• Knowledge of metadata and data governance practices is beneficial.

Responsibilities

• Design and maintain data models and transformation pipelines.
• Ensure data processes are automated and scalable.
• Collaborate with stakeholders to translate analytical requirements.
• Support integration of AI and machine learning capabilities.

Skills

Data transformation and modelling techniques

Proficiency in SQL

Experience with Power BI

Familiarity with version control

Understanding of workflow automation

Agile environment experience

Tools

Snowflake

dbt

Microsoft Fabric

Power Automate

AWS Glue

Azure Data Factory

Job description

Overview

Job Description: As a BI Developer at Sage, you'll play a vital role in transforming raw data into trusted, well-structured datasets that drive reporting, analytics, and business insights. You'll support the Performance Marketing team by building scalable, documented, and efficient data pipelines and dimensional models that enable data-driven, results-focused marketing strategies. Working closely with stakeholders, you'll ensure your solutions align with business goals and unlock performance insights. You'll be part of a team dedicated to making data meaningful and accessible, empowering smarter decisions and better ways of working. You'll also help evolve our data capabilities by automating processes and integrating AI technologies boosting insight generation, efficiency, and continuous improvement across all marketing initiatives. This is a hybrid role - 3 days in office 2 days at home. Location - Newcastle or Winnersh.

Key Responsibilities

• Design and maintain data models and transformation pipelines that integrate data from multiple business systems.
• Develop dimensional schemas to support consistent and reliable reporting and analytics.
• Contribute to the creation and maintenance of a trusted source of data that supports consistent and reliable business insights across teams.
• Ensure data processes are automated, scalable, and aligned with business timelines.
• Support the integration of AI and machine learning capabilities into data workflows to enhance analytics and operational processes.
• Maintain clear and comprehensive documentation for data models, KPIs, and business logic.
• Troubleshoot data issues and ensure high data quality and integrity across systems.
• Collaborate with stakeholders to understand analytical requirements and translate them into effective data solutions.
• Operate within agile or iterative delivery frameworks and communicate effectively across teams and functions.
• Strong proficiency in data transformation and modelling techniques using tools such as Snowflake, dbt, and SQL.
• Experience with business intelligence and reporting platforms (e.g., Power BI, Microsoft Fabric), including semantic modelling.
• Familiarity with version control and collaborative development workflows (e.g., GitHub, GitLab).
• Understanding of workflow automation and low-code platforms (e.g., Power Automate, Power Apps, or similar).
• Ability to work both independently and collaboratively in a fast-paced, agile environment.
• Desirable: Experience with cloud-based data integration and orchestration tools (e.g., AWS Glue, Azure Data Factory).
• Desirable: Exposure to AI and machine learning integration in analytics workflows (e.g., Microsoft Copilot, or similar AI assistants).
• Desirable: Knowledge of metadata and data governance practices using tools such as Collibra.
• Desirable: Familiarity with marketing technologies (e.g., Eloqua, Google Analytics) and understanding of marketing performance metrics and KPIs.

Qualifications

• 3+ years of experience in data modelling, data engineering, or a related analytical role.
• Technical / Professional Qualifications:
• Comprehensive health, dental and vision coverage.
• Work away scheme for up to 10 weeks a year.
• On-going training and professional development.
• Paid 5 days yearly to volunteer through our Sage Foundation.
• Flexible work patterns and hybrid working.

Advert details: Function Global Marketing Strategy; Country United Kingdom; Office Location Winnersh; Work Place type Hybrid.

Note: This description reflects the information provided in the job description and retains the original language without translation.