Employer: Procera Group 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.