BI & Data Engineer.

Business Intelligence & Data Engineer

The Business Intelligence & Data Engineer role will be undertaken by a proactive and highly motivated individual. This position combines advanced technical expertise in data engineering, reporting, and analytics with a strategic focus on data management and governance. You will play a central role in shaping the organisation's data landscape, landscape supporting decision making within the creative agency, ensuring high-quality, scalable, and secure reporting and analytics solutions on areas such as client profitability, resource utilisation and SaaS tool recharging.

You will be responsible for leading end-to-end delivery of BI and data engineering initiatives - including project scoping, stakeholder engagement, solution design, technical development, rollout, and continuous improvement. This role also includes responsibility for the organisation's Power BI and reporting environment, data pipelines, and data strategy.

The ideal candidate is detail-oriented, technically skilled, and comfortable working across both technical and commercial teams. A strong sense of ownership, curiosity, and a passion for automation, data quality, and process improvement are essential for success.

AREAS OF IMPACT

Project Delivery & Process Improvement

• Design, build, and maintain robust ETL/ELT pipelines to support reporting and advanced analytics.
• Ensure data from multiple sources (APIs, databases, cloud platforms, SaaS tools) is ingested, transformed, and integrated into centralised data models.
• Manage and optimise the Power BI environment, including dataset refreshes, gateway configuration, performance tuning, and governance.
• Act as the technical owner of reporting platforms, ensuring scalability, reliability, and security.

Reporting & Analytics

• Develop and maintain high-quality reports, dashboards, and visualisations in Power BI and other BI tools.
• Define and track key performance indicators (KPIs) that support decision-making across business units.
• Promote self-service analytics by enabling business teams to access, interpret, and use trusted data.
• Ensure reporting environments follow best practices in modelling, DAX optimisation, and data security.
• Translate business questions into actionable insights and present data tailoring to creative, client and operational stakeholders.
• Automation of reporting workflows via API's.

Data Management, Security & Governance

• Implement and enforce data quality, lineage, and governance frameworks.
• Conduct regular data validation and cleansing initiatives across core systems.
• Work with system owners and external vendors to enhance data integrations and resolve data-related issues.
• Ensure compliance with data privacy and information security policies.
• Define data standards, metadata management practices, and source-of-truth alignment across the organisation.

Data Strategy & Enablement

• Contribute to the organisation's data strategy, including architecture, tooling, and process evolution.
• Identify opportunities to leverage new technologies (cloud platforms, automation, AI/ML) to improve efficiency and insights.
• Deliver internal training sessions in Power BI, SQL, and data best practices to promote data literacy.
• Partner with business stakeholders to scope and prioritise data-driven initiatives that align with strategic goals.
• Drive adoption of BI tools across the business providing training and support so teams can make data-informed decisions

KNOWLEDGE, SKILLS & BEHAVIOURS

Technical Skills

• Strong expertise in SQL, APIs, Power BI, DAX, Power Query, Power Automate.
• Proficiency in data engineering tools (e.g., Python, dbt, SSIS, Azure Data Factory, or similar ETL/ELT tools).
• Hands-on experience with data modelling and star-schema design for BI environments.
• Familiarity with cloud data platforms (Azure, AWS, or GCP) and data lake/warehouse architectures.
• Strong understanding of data governance principles, data lineage, and security best practices.
• Experience managing and optimising enterprise BI/reporting environments.
• Hands on experience of ETL processes and associated tooling.
• Experience with BI custom visuals, embedding dashboards and optimising for mobile.

Soft Skills

• Exceptional attention to detail and commitment to data accuracy.
• Strong time management skills; ability to prioritise and manage tasks across multiple stakeholders.
• Excellent written and verbal communication skills, with a professional and collaborative approach.
• Self-motivated, curious, and passionate about learning and innovation.
• Strong problem-solving skills and ability to work independently with minimal supervision.

Desirable

• Experience with data architecture and strategy development.
• Knowledge of scripting languages for automation (Python, R, Powershell, Bash or similar).
• Previous involvement in change management or large-scale systems implementation projects.
• Understanding of machine learning workflows and advanced analytics use cases.
• Experience of working in a Data Operations environment

Development & Growth

We actively encourage ongoing professional development. You will be supported through:

• Access to internal and external training resources.
• Opportunities to lead or contribute to strategic initiatives.
• A culture that values innovation, knowledge-sharing, and continuous improvement.