Business Intelligence Developer at Woodlands Dairy

About the Role 

• The Business Intelligence Developer will be responsible for the end-to-end BI solution, including data extraction, storage, modelling, and analytics delivery. The role involves working with SSIS, SQL Server, SSAS, Qlik Sense, Power BI, and NPrinting to deliver reliable, accurate, and insightful business intelligence solutions to stakeholders across the organisation. 

Key Responsibilities 

• Design, develop, and maintain SSIS ETL pipelines from multiple data sources into SQL Server 
• Design, develop, and optimise SQL Server databases for reporting and analytics 
• Build and maintain SSAS Tabular models, including KPIs and security roles 
• Develop and support Qlik Sense applications and dashboards for business users 
• Develop and support Power BI datasets, reports, and dashboards 
• Design, manage, and schedule NPrinting reports, including templates and distribution 
• Collaborate with business stakeholders to gather requirements and deliver BI solutions 
• Monitor and support production BI environments, resolving issues proactively 
• Ensure data accuracy, integrity, security, and documentation standards are maintained 

Minimum Requirements 

• Diploma or Degree in Information Technology, Computer Science, Data Management, Statistics, or a related field 
• Minimum five (5) years’ hands‑on experience in a Business Intelligence Developer or similar BI role 
• Proven experience with SSIS, SQL Server, SSAS, Qlik Sense, Power BI, and NPrinting 
• Strong understanding of data visualisation principles and best practices 
• Solid knowledge of ETL processes and data integration tools 

Technical Skills 

• Advanced T‑SQL and SQL Server performance tuning 
• SSIS ETL development and scheduling 
• SSAS semantic modelling and tabular design 
• Qlik Sense scripting, data modelling, and visualisation 
• Power BI dataset modelling, DAX, and report development 
• NPrinting report design, scheduling, and distribution 
• Strong understanding of data warehousing and dimensional modelling 

Behavioural Competencies 

• Strong analytical and problem‑solving skills 
• High attention to detail and commitment to data accuracy 
• Ability to communicate technical concepts to non‑technical business users 
• Ability to work independently and collaboratively within a team environment