Senior BI Engineer- CPT

Xcede Group; Cape Town; Presencial; ZAR 700.000 - 1.100.000; Jornada completa

Descripción de la vacante

Xcede Group is seeking a Business Intelligence Engineer to design, develop, and maintain BI interfaces and data pipelines using the Microsoft BI stack including MS SQL Server, SSIS, SSAS, SSRS, and Power BI. You will ensure clean, accessible data for end users and KPI reporting.

The role focuses on building a bridge between data and business users lacking SQL skills, with emphasis on robust ETL, data modelling, and governance across projects.

Formación

• 5+ years of BI development experience in a professional environment.
• Hands-on with T-SQL, SSIS, Data Warehousing, SSAS and Power BI.
• 5+ years with Microsoft Analysis Services, OLAP cubes, and MDX.
• Strong SSRS development and SQL reporting experience.

Responsabilidades

• Design, develop, and maintain BI solutions using the Microsoft BI stack (SQL Server, SSIS, SSAS, SSRS, Power BI).
• Design, develop, and maintain ETL processes with SSIS.
• Oversee data warehouse design, maintenance, and re-architecture as needed.
• Lead complex, cross-functional BI projects and tool implementations.
• Collect, analyze, and share data to drive business KPIs and outcomes.
• Implement data structures with best practices in data modelling and governance.

Conocimientos

T-SQL

SSIS

Data Warehousing

SSAS

Power BI

MDX

SSRS

OLAP

Educación

Bachelor's or Diploma in CS/Software Eng or related

Herramientas

Microsoft SQL Server

SSIS

SSAS

SSRS

Descripción del empleo

Business Intelligence Engineer

We are on the search for a Business Intelligence Engineer that will be responsible for developing, deploying and maintaining BI interfaces. We want you to manage our clients' data retrieval and analysis within their company, by providing them with clean and comprehensible data to the end-user that can be efficiently used to create KPIs.

A successful incumbent will build a bridge between data and the people who need to query it, but who lack the SQL skills needed for sophisticated query construction.

Requirements:

• Relevant Diploma/Degree in Computer Science, Software Engineering, or similar field.
• At least 5-6 years of experience within a BI development environment.
• Hands-on experience with T-SQL, SSIS, Data Warehousing, SSAS and Power BI.
• 5+ years of experience in Microsoft Analysis Services - authorizing OLAP cubes and writing MDX.
• Extensive experience in SSRS Development, creating and fine-tuning SQL Reports.

What You'll Do:

• Responsible for the design, development, and maintenance of Business Intelligence (BI) solutions using Microsoft BI stack - MS SQL Server, SSIS, SSAS, SSRS and Power BI.
• Design, develop and maintain ETL processes using SSIS.
• Data warehouse design, maintenance and re-architecture as required.
• Works on highly complex and cross-functional BI solutions. Directs, organizes, and leads projects in the implementation and use of new BI software tools and systems.
• Collects, analyses, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.
• Responsible for implementing data structures using best practices in data modelling, processes, and technologies.
• Performs data conversions, imports and exports of data within and between internal and external software systems.
• Implements tools and frameworks for automating report generation, identification of data-quality issues, and data governance.