Junior BI Developer

Procera; KwaZulu-Natal; On-site; ZAR 240,000 - 360,000; Full time

Job summary

Procera is seeking a Junior BI Developer to assist in developing new BI offerings, monitor existing products and support client queries. You will gather specifications, collect data, and participate in data warehouse design, ETL development and data modeling.

In this role you will create dynamic dashboards and reports with Power BI and Excel, analyze data within MSSQL data warehouses, and collaborate with IT and stakeholders to drive data-driven decisions.

Qualifications

• Relevant IT degree or diploma required.
• Strong MSSQL querying/manipulation skills.
• Experience with ETL tools such as SSIS or Azure Data Factory.
• Familiarity with Python scripting.
• Experience with Power BI and Excel for reporting.
• Hands-on experience creating semantic data models.

Responsibilities

• Develop and maintain ETL pipelines to extract, transform, and load data.
• Create and optimize data models and data warehouse.
• Write complex SQL queries against MSSQL data warehouse.
• Create dynamic dashboards/reports using Power BI and Excel.
• Monitor BI performance and optimize for speed and efficiency.
• Collaborate with IT and stakeholders on data needs.

Skills

Analytical mindset

Problem-solving

Data modeling

Data visualization

Learning mindset

Education

Relevant IT Degree / Diploma

Tools

MSSQL

SSIS

Azure Data Factory

Python

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.
• Collaborative and adaptable to dynamic team environments.