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.
Apply for Junior BI Developer
Submit your application for this position at Procera Holdings Proprietary Limited
Ready to Apply?
Submit your application for this position