BI Analyst

LINKFIELDS INNOVATIONS (PTY) LTD; Johannesburg; On-site; ZAR 400,000 - 600,000; Full time

Job summary

LINKFIELDS INNOVATIONS (PTY) LTD is seeking a Business Intelligence Analyst to focus on designing and implementing ETL processes using SSIS in Johannesburg, South Africa. The role involves collaboration with cross-functional teams to optimize data solutions and deliver actionable insights.

The ideal candidate will hold a Bachelor's degree in Computer Science and have proven experience in SQL programming and creating ETL processes. Strong analytical skills and the ability to interpret complex datasets are essential for driving business growth.

Qualifications

• Bachelor's degree in Computer Science or Information Systems.
• Proven experience with ETL processes using SSIS.
• Strong proficiency in SQL programming and database management.

Responsibilities

• Design and develop ETL processes using SSIS.
• Collaborate with stakeholders to gather data requirements.
• Monitor and troubleshoot ETL jobs for reliability.

Skills

ETL processes using SSIS

SQL programming

Data modeling

Analytical skills

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Tableau

QlikView

Job description

Position Overview

As a Business Intelligence Analyst with a specialized focus on SSIS, you will play a crucial role in designing and implementing robust ETL processes to streamline data integration and support our advanced analytics initiatives. You will collaborate closely with cross-functional teams to gather business requirements, develop scalable data solutions, and deliver actionable insights that drive business growth and innovation.

Key Responsibilities

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into our data warehouse.
• Collaborate with business stakeholders to understand data requirements and translate them into technical specifications for ETL development.
• Optimize SQL queries, stored procedures, and views to support data integration and reporting needs.
• Monitor and troubleshoot ETL jobs to ensure the reliability and performance of data pipelines.
• Conduct data validation and reconciliation to ensure the accuracy and consistency of data across different systems.
• Document ETL processes, data mappings, and data lineage to ensure compliance and facilitate knowledge transfer.
• Stay updated on industry trends, best practices, and emerging technologies in business intelligence and data integration.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Proven experience in developing ETL processes using SQL Server Integration Services (SSIS) in a business intelligence or data warehousing environment.
• Strong proficiency in SQL programming and database management with a solid understanding of relational database concepts.
• Familiarity with data modeling principles and dimensional modeling techniques.
• Excellent analytical and problem-solving skills with the ability to interpret complex data sets and extract actionable insights.
• Effective communication and collaboration skills with the ability to work across functional teams.
• Self-motivated and detail-oriented with a passion for continuous learning and professional development.
• Experience with other business intelligence tools such as Power BI, Tableau, or QlikView is a plus.
• Relevant certifications in SQL Server or business intelligence technologies are desirable.