Junior BI Developer: ETL, SQL & Power BI

Procera

South Africa

On-site

ZAR 300,000 - 420,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

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.