Overview:
An IT Software / FinTech company based in Rosebank, Gauteng is seeking to employ a BI Developer to join their team.
Duties & responsibilities
- Translate business needs to technical specifications
- Design, build and deploy BI solutions (e.g. data warehousing models)
- Evaluate and improve existing BI systems
- Collaborate with teams to integrate systems
- Develop and execute database queries and conduct analyses
- Create visualizations and reports for requested projects
- Develop and update technical documentation
- Client Data Support
- Maintain and support data analytics platforms
- Conduct unit testing and troubleshooting
Technical Competencies & Experience:
- Familiarity with BI Technologies:
- Power BI
- Desktop & Online
- DAX
- Microsoft SQL
- T-SQL
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- SQL Server Analysis Services (SSAS)
- Microsoft BI Stack
- Storage Blob
- Azure Synapse
- Azure Analysis Service
- Azure SQL
- Azure Data Factory
- Integration Runtime
- Understanding of ERP, CRM, and other business applications/business processes
- Snowflake / Hadoop / Azure Data Bricks (Highly beneficial – but not a must-have)
Work Experience:
- 5+ years’ experience in a Business Intelligence / Data Warehouse design & development role
- Background in data warehouse design (e.g. dimensional modeling) and data mining
- In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework
- Must be able to gather own requirements from stakeholders, design, and implement solutions based on given requirements in an existing project
Qualifications:
- BTech OR Bachelor’s degree, preferably in IT, Informatics Computer Science, or similar
- Microsoft Certified Solutions Associate in:
- Business Intelligence Development
- Business Intelligence Reporting
- Microsoft Certified Solutions Expert in
- Data Management & Analytics
- Microsoft Certified Azure Data Engineer