Junior BI Developer

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.

• 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 (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.

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

• 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.

• 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.