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.
