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.