Permanent
Junior BI Developer
Procera Group
Unknown, Unknown
unknown
About this role
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.