Business Intelligence Developer

Watershed Consulting; Johannesburg; Hybrid; ZAR 600,000 - 900,000; Full time

Job summary

Watershed Consulting is seeking an experienced BI Developer to design, build and maintain data solutions enabling timely business insights. You will work across the full solution lifecycle to ingest, transform, model and present data using Microsoft Fabric, Power BI, PySpark and relational databases.

You will collaborate with stakeholders, BI and data teams to deliver scalable, governed analytics solutions while applying DevOps practices and data governance principles.

Qualifications

• 4-6 years of professional BI, analytics or data development experience.
• Proven hands-on experience with Power BI and T-SQL in production solutions.
• Practical experience with Microsoft Fabric and PySpark/Spark SQL.
• Experience managing or supporting relational databases and troubleshooting data issues.
• Experience across the full solution lifecycle: requirements, design, development, testing, deployment, documentation and support.

Responsibilities

• Design, build and maintain data solutions across the full lifecycle.
• Ingest, transform, model and present data using Fabric, PySpark and SQL.
• Develop and optimise Power BI reports, semantic models, and implement Row-Level Security.
• Ensure data governance, security and documentation for analytics assets.
• Collaborate with stakeholders and BI/data teams to deliver scalable solutions.

Skills

Microsoft Fabric

Power BI

PySpark

Spark SQL

T‑S‑QL

Data Modeling

Education

Bachelor's degree in Computer Science or related

Tools

Azure Data Factory

Dataflow Gen2

Notebooks

Lakehouse

OneLake

Azure DevOps

SSRS

Azure Data Lake Storage

Job description

Job Title: Business Intelligence Developer

Description

We are seeking an experienced Business Intelligence Developer to design, build and maintain data solutions that enable accurate, timely and secure business insights. The successful candidate will work across the full solution lifecycle to ingest, transform, model and present data using Microsoft Fabric, Power BI, PySpark and relational database technologies. You will collaborate with business stakeholders, BI and data teams, and technical partners to deliver scalable, governed and well-documented analytics solutions.

Responsibilities

• Design, develop and maintain Microsoft Fabric solutions including Data Factory pipelines, Dataflow Gen2, notebooks, Lakehouse and Warehouse assets, and OneLake deployment practices.
• Implement scalable data preparation, transformation and validation using PySpark and Spark SQL.
• Develop and optimise advanced T-SQL queries, stored procedures and views; troubleshoot query and performance issues.
• Author Power BI reports and semantic models using Power Query, dimensional modelling and DAX; implement row-level security and report performance optimisation.
• Apply database management fundamentals: relational design, security, indexing, monitoring, backup and recovery concepts.
• Design and operate data warehousing solutions (star schemas, slowly changing dimensions, medallion architecture) and ETL/ELT patterns with orchestration, incremental loading, error handling, audit logging and reconciliation.
• Follow DevOps and source control practices for versioning, peer review, release management and controlled deployments.
• Support data governance practices including data quality, metadata, lineage, access control and protection of sensitive information.
• Engage with stakeholders to translate business requirements into sustainable technical solutions and provide documentation and production support as required.

Qualifications

• Four to six years of professional experience in business intelligence, analytics or data development.
• Proven hands-on experience developing production solutions with Power BI and T-SQL.
• Practical experience with Microsoft Fabric and PySpark or Spark SQL for data ingestion and transformation workloads.
• Experience managing or supporting relational databases and troubleshooting data, query and performance issues.
• Experience across the full solution lifecycle: requirements, design, development, testing, deployment, documentation and support.
• Bachelor’s degree or diploma in Computer Science, Information Systems, Data Science, Engineering or a relevant field, or equivalent demonstrable BI development experience.

Skills

• Microsoft Fabric
• Azure Data Factory
• Dataflow Gen2
• Notebooks
• Lakehouse
• OneLake
• PySpark
• Spark SQL
• T‑S‑QL
• Power BI
• Power Query
• Dimensional modelling
• DAX
• Semantic models
• Row-level security
• Report performance optimization
• Relational database design
• Database security
• Indexing
• Database monitoring
• Backup and recovery
• Data warehousing
• Star schema
• Slowly changing dimensions
• Medallion architecture
• ETL
• ELT
• Orchestration
• Incremental loading
• Error handling
• Audit logging
• Data reconciliation
• DevOps
• Source control
• Data governance
• Data quality
• Metadata management
• Data lineage
• Access control
• Data protection
• SQL
• Analytical thinking
• Stakeholder engagement
• Technical communication
• Agile methodologies
• Problem solving
• Attention to detail
• Independent work
• Collaboration
• Azure DevOps
• Azure Data Lake Storage
• SSRS
• Python
• MRI Property Management System
• Fraxion Spend Management

Working conditions

Hybrid working arrangement with flexibility. Busy delivery or support periods may require extended hours to meet deadlines, complete releases or restore critical services.

Internal and External Liaison

Internal: business stakeholders, BI and data teams, business analysts, application support, infrastructure, information security, finance and project teams. External: technology vendors, implementation partners, consultants and service providers as required.

Decision-Making and Problem-Solving

Make day-to-day technical decisions within approved architecture, security, governance and delivery standards. Investigate ambiguous data and system issues across pipelines, databases, models and reports to identify root causes and implement sustainable corrective actions, escalating material risks or design decisions as appropriate.

. Skillset Required: Microsoft Fabric, Azure Data Factory, Dataflow Gen2, Notebooks, Lakehouse, OneLake, PySpark, Spark SQL, T‑S‑QL, Power BI, Power Query, Dimensional modelling, DAX, Semantic models, Row-level security, Report performance optimization, Relational database design, Database security, Indexing, Database monitoring, Backup and recovery, Data warehousing, Star schema, Slowly changing dimensions, Medallion architecture, ETL, ELT, Orchestration, Incremental loading, Error handling, Audit logging, Data reconciliation, DevOps, Source control, Data governance, Data quality, Metadata management, Data lineage, Access control, Data protection, SQL, Analytical thinking, Stakeholder engagement, Technical communication, Agile methodologies, Problem solving, Attention to detail, Independent work, Collaboration, Azure DevOps, Azure Data Lake Storage, SSRS, Python, MRI Property Management System, Fraxion Spend Management