Data and Power BI Engineer

About

We are seeking a skilled and motivated Data and Power BI Engineer to join our team. This is a dual-role position combining data infrastructure administration with end-to-end Power BI development. The successful candidate will be responsible for the design, development and maintenance of Microsoft SQL databases, the development of Power BI solutions from requirements gathering through to frontend delivery and providing client-facing support and guidance.

The ideal candidate is technically proficient, detail-oriented and possesses strong interpersonal skills to effectively engage with both internal stakeholders and external clients. This role is well-suited to a self-starter who thrives in a collaborative environment and is passionate about transforming data into actionable business insights.

Duties & Responsibilities

Database Administration & SQL Development

• Design, implement and maintain Microsoft SQL Server databases in accordance with business requirements and best practices.
• Write complex SQL queries, stored procedures, views and functions to support reporting and data processing needs.
• Perform database performance tuning, indexing and query optimisation.
• Ensure data integrity, security and availability across all database environments.
• Develop and maintain data models and schemas to support Business Intelligence workloads.
• Manage database backups, recovery procedures and disaster recovery planning.

Power BI Development (Backend)

• Develop and maintain robust data models within Power BI using Power Query (M) and DAX.
• Build and manage data pipelines and transformations to prepare data for reporting.
• Connect Power BI to a variety of data sources including SQL Server, APIs and flat files.
• Optimise report performance through best-practice data modelling and calculation techniques.
• Implement Row Level Security (RLS) and manage Power BI workspace permissions.

Power BI Scoping & Requirements

• Engage with business stakeholders and clients to gather and document reporting requirements.
• Translate business needs into technical specifications and scoping documents.
• Provide effort estimates and timelines for Power BI development projects.
• Facilitate workshops and requirement sessions with non-technical stakeholders.

Power BI Frontend Design & Development

• Design and develop visually compelling, user-friendly Power BI dashboards and reports.
• Apply consistent branding, layout best practices and UX principles to all report deliverables.
• Create interactive reports with drill-through, bookmarks, tooltips and dynamic filtering.
• Publish and maintain reports in the Power BI Service and manage scheduled refreshes.

API Development & Integration

• Integrate external and internal data sources via REST APIs into Power BI and SQL environments.
• Develop and maintain API connectors for automated data ingestion.
• Understand and apply API authentication methods including OAuth, API keys and Bearer tokens.
• Collaborate with development teams to design and consume APIs for data exchange.

Web & HTTP Development

• Apply basic HTTP/HTTPS concepts to support API integrations and web-based data connections.
• Write lightweight scripts (e.g. Python, JavaScript, or PowerShell) to automate data workflows.
• Troubleshoot HTTP request/response issues relating to data pipeline connectivity.

Process & Task Automation

• Design and implement automated workflows to reduce manual data processing and repetitive tasks.
• Utilise tools such as Microsoft Power Automate, Python scripts, or PowerShell to automate data pipelines and business processes.
• Schedule and monitor automated SQL jobs, data refreshes and ETL processes.
• Identify opportunities within existing workflows to introduce automation and improve operational efficiency.
• Document automated processes and ensure appropriate error handling and alerting is in place.

Client Engagement & Stakeholder Management

• Serve as a primary technical point of contact for clients regarding data and reporting deliverables.
• Present reports, dashboards and technical solutions to non-technical audiences confidently.
• Manage client expectations, provide regular updates and ensure satisfaction with deliverables.
• Build and maintain positive working relationships with internal and external stakeholders.

Desired Experience & Qualification

Technical Skills

• MS SQL Server: Proficiency in database design, T-SQL, stored procedures and performance tuning
• Power BI Backend: Data modelling, DAX, Power Query (M language), RLS, Power BI Service
• Power BI Frontend: Dashboard design, UX best practices, interactive visuals, report publishing
• Power BI Scoping: Requirements gathering, scoping documentation, stakeholder workshops
• API Integration: REST API consumption and development, JSON/XML, OAuth, API tooling (e.g. Postman)
• HTTP / Web Basics: HTTP methods, status codes, request/response handling, scripting
• Process & Task Automation: Power Automate, PowerShell, Python scripting, SQL Agent jobs, ETL pipeline scheduling
• Data Modelling: Star schema, dimensional modelling, normalisation and denormalisation

Soft Skills & Behavioural Competencies

• Client Facing: Professional communication, stakeholder engagement, presentation skills
• Problem Solving: Analytical thinking, ability to work with ambiguous requirements
• Attention to Detail: Accuracy in data work, documentation and report design
• Collaboration: Works effectively in cross-functional teams
• Self-Management: Ability to manage multiple priorities and meet deadlines independently

Minimum Requirements

• National Diploma or Bachelor's Degree in Computer Science, Information Technology, Data Science, or a related field.
• 3–5 years of hands-on experience in a Power BI development role.
• 3+ years of experience with Microsoft SQL Server database design and T-SQL development.
• Demonstrable experience with API integration and consumption.
• A portfolio of Power BI dashboards and reports (to be presented during the interview process).

Advantageous

• Microsoft Certified: Data Analyst Associate (PL-300) or equivalent Power BI certification.
• Microsoft Certified: Azure Data Fundamentals (DP-900) or Azure Data Engineer Associate.
• Experience with Azure services (Azure Data Factory, Azure Synapse, Azure SQL).
• Exposure to Python or PowerShell for data automation and scripting.
• Experience in an Agile/Scrum development environment.
• Knowledge of Power BI Premium, Dataflows and Deployment Pipelines

Package & Remuneration

Market Related