Cape Town - Western Cape - South Africa
Snr BI Engineers wanted! Join a dynamic team as a BI Engineer and utilize your expertise in Microsoft BI stack (MS SQL Server, SSIS, SSAS, SSRS, and Power BI) to implement cutting-edge business intelligence solutions. Your responsibilities will include developing reports, dashboards, and ETL processes, collaborating with Business Analysts to meet customer needs, and driving improvement in key business metrics. If you have a passion for data analysis, a strong understanding of T-SQL, and experience with database management and troubleshooting, we want to hear from you. Come be a part of an innovative environment, where you can make a real impact and grow your skills.
Areas: Cape Town, East London and Durban
Type: Hybrid
Salary range: R60 000 - R80 000 per month ctc
Responsibilities:
- Implement BI solutions using Microsoft BI stack (MS SQL Server, SSIS, SSAS, SSRS, and Power BI).
- Develop stored procedures, dashboards, reports, and ETL processes.
- Collaborate with Business Analysts to understand customer needs and provide support on report offerings.
- Collect, analyze, and share data to drive improvement in key business metrics and customer experience.
- Design and build reporting tools for streamlined business processes.
- Assist in data conversions, imports, and exports between internal and external systems.
- Document new and existing solutions and implementations.
- Troubleshoot BI tools, systems, and software, ensuring data quality standards are met.
- Track performance and production issues and may assist in performance tuning.
- Perform quality checks on work before stakeholder approval.
- Maintain the Metadata Repository as needed.
- Degree or diploma in IT or related technical discipline.
- Minimum 3+ years of proven experience in Microsoft BI Stack (SSIS, SSAS, SSRS, SQL).
- Experience in end-user report development and data staging (ETL) components.
- Proficient in creating efficient T-SQL objects and processes, including query optimization and debugging.
- Familiarity with database management systems, online analytical processing, and ETL frameworks.
- Strong communication skills and ability to collaborate with various departmental team members.
- Knowledge of the Kimball data warehouse lifecycle.
- Relevant Microsoft SQL certifications.
- Knowledge of the Kimball data warehouse lifecycle.
- Relevant Microsoft SQL certifications.