Junior BI Developer

Procera; South Africa; On-site; ZAR 300,000 - 420,000; Full time

Job summary

Procera in South Africa is seeking a Junior BI Developer to assist in building new BI offerings, monitor products and support client queries. You will gather specifications, collect data and contribute to data warehouse design, ETL development and performance tuning.

The role requires a proactive mindset, attention to detail and ability to work under pressure to deliver tasks. You will create semantic data models and dashboards using Power BI and Excel, with MSSQL as the core data platform.

Qualifications

• Relevant IT degree or diploma required.
• Strong MSSQL proficiency for querying and manipulation.
• Strong analytical and problem-solving skills with a strategic mindset.
• Experience with ETL tools such as SSIS / Azure Data Factory.
• Familiarity with scripting languages (e.g., Python).
• Hands-on experience creating semantic data models.
• Experience in Power BI and Excel for data visualization and reporting.
• Familiarity with contact center metrics and operations is a plus.

Responsibilities

• Develop and maintain ETL pipelines to extract, transform, and load data from various sources.
• Ensure data integrity, consistency and security throughout the ETL process.
• Perform detailed data analysis while developing ETL pipelines to identify data quality issues, inconsistencies, and transformation requirements, ensuring accurate and reliable data processing.
• Create, optimize, and maintain data models and data warehouse.
• Ensure high data quality through testing, validation, and debugging of data flows and reports.
• Implement and manage security and user access controls in BI platform.
• Monitor performance of BI solutions and optimize for speed and efficiency.
• Identify areas for improvement in existing BI solutions.
• Write complex SQL queries to retrieve and analyze data.
• Work with our MSSQL-based data warehouse to process, analyze, and maintain data integrity.
• Create dynamic dashboards and reports using Power BI and Excel to visualize performance metrics and trends.
• Stay updated on emerging tools and technologies in analytics.
• Evaluate the suitability of new technologies for current and future BI needs.
• Recommend innovations to enhance performance, scalability, usability, or cost-efficiency of BI systems.
• Partner with IT teams, and other stakeholders to address data needs.
• Provide insights and support for business decisions and cross-departmental projects.

Skills

MSSQL

Analytical thinking

Problem solving

Python

Semantic data models

Power BI

Excel

Education

Relevant IT Degree / Diploma

Tools

SSIS

Azure Data Factory

Power BI

Excel

Job description

Job Overview:

We are seeking a keen and motivated Junior BI Developer to assist in the development of new BI offerings, monitoring existing products and supporting client queries.

This role requires a proactive personality, analytical mind-set, attention to detail, and excellent time management and communication skills. This role will entail working under pressure to deliver tasks. The candidate will be responsible: specification gathering, data collection and data warehouse database design, ETL development, data model creation and performance optimization.

Key Responsibilities:

ETL Development:

• Develop and maintain ETL pipelines to extract, transform, and load data from various sources.
• Ensure data integrity, consistency and security throughout the ETL process.

Analyze Data During Pipeline Creation

• Perform detailed data analysis while developing ETL pipelines to identify data quality issues, inconsistencies, and transformation requirements, ensuring accurate and reliable data processing.

Data Modeling and Database Design:

• Create, optimize, and maintain data models and data warehouse.
• Ensure high data quality through testing, validation, and debugging of data flows and reports.
• Implement and manage security and user access controls in BI platform

Performance Optimization:

• Monitor performance of BI solutions and optimize for speed and efficiency.
• Identify areas for improvement in existing BI solutions.

Data Management & Reporting:

• Write complex SQL queries to retrieve and analyze data
• Work with our MSSQL-based data warehouse to process, analyze, and maintain data integrity.
• Create dynamic dashboards and reports using Power BI and Excel to visualize performance metrics and trends.

Technology Exploration:

• Stay updated on emerging tools and technologies in analytics.
• Evaluate the suitability of new technologies (e.g., ETL tools, cloud services, visualization platforms) for current and future BI needs.
• Recommend innovations to enhance performance, scalability, usability, or cost-efficiency of BI systems.

Cross-Functional Collaboration:

• Partner with IT teams, and other stakeholders to address data needs.
• Provide insights and support for business decisions and cross-departmental projects.

Qualifications:

• Relevant IT Degree / Diploma
• Strong proficiency in MSSQL for data querying and manipulation.
• Strong analytical and problem-solving skills with a strategic mindset.
• Experience with ETL tools such as SSIS / Azure data factory.
• Familiarity with scripting languages (e.g. Python).
• Hands-on experience with creation of semantic data models.
• Experience in Power BI and Excel for data visualization and reporting.
• Familiarity with contact center metrics and operations is a plus.

Key Attributes:

• Proactive and innovative thinker.
• Detail-oriented with excellent organizational skills.
• Strong ability to connect data insights with strategic decision-making.
• Passionate about leveraging data to drive meaningful business changes.
• Eager to explore and implement cutting-edge technologies.
• Results-driven with a focus on continuous improvement.