BI Developer (6m contract)

Job Description

The Customer Lifecycle Management (CLM) team at StarHub is dedicated to understanding, enhancing, and optimizing the customer journey. From acquisition to retention, the CLM team employs data-driven strategies to provide unparalleled customer experiences. Through a combination of data science, business intelligence, customer insights, NPS, and digital analytics, the CLM team ensures that StarHub's offerings are aligned with customer needs, leading to increased loyalty, satisfaction, and growth.

The BI Developer will join the CLM team on a 6-month contract to lead the migration of business intelligence assets and reporting infrastructure following the data platform migration from Netezza (IBM PureData) to Snowflake. This role is critical for ensuring business continuity of analytics and reporting capabilities, rebuilding dashboards, reports, and data visualizations to leverage the new Snowflake environment. The BI Developer will work closely with Data Science, Business Analytics, and Digital Analytics teams to ensure migrated reports maintain accuracy, performance, and usability standards required for ongoing business decision-making.

KEY RESPONSIBILITIES

Dashboard Migration: Migrate existing dashboards, reports, and visualizations from legacy Netezza-connected BI tools to Snowflake-connected environments, ensuring functional parity and data accuracy throughout the migration process.

Data Source Reconfiguration: Reconfigure and optimize data connections, queries, and extracts to work with Snowflake's architecture, leveraging cloud-native features for improved dashboard performance and refresh times.

Report Optimization: Redesign and optimize existing reports and dashboards for the Snowflake environment, improving query efficiency, load times, and user experience while maintaining compatibility with business requirements.

Validation & Testing: Develop and execute comprehensive validation frameworks to verify data accuracy, calculation consistency, and visual integrity between legacy and migrated dashboards.

Documentation & Training: Create detailed migration documentation, updated data dictionaries for BI assets, and conduct knowledge transfer sessions with end-users on any changes to reports or dashboards.

Stakeholder Collaboration: Partner with Data Engineering, Data Science, Business Analytics, and Digital Analytics teams to coordinate migration activities, prioritize critical reports, and minimize disruption to ongoing business operations.

Qualifications

Education Level: Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field. Master's degree in a relevant field is preferred.

Required Experience and Knowledge:

3-5 years of experience in business intelligence development or a related field

Strong knowledge of data visualization principles, dashboard design, and reporting best practices

Experience with BI migration projects, particularly transitioning from legacy on-premise data sources to cloud platforms

Hands-on experience connecting BI tools to legacy data warehouse systems (e.g., Netezza, Teradata, Oracle)

Experience with cloud-based data platforms, specifically Snowflake and AWS

Advanced proficiency in SQL for complex queries, performance optimization, and data validation

Knowledge of data governance principles and data privacy regulations

Job-Specific Technical Skills:

Expert proficiency in Tableau (Desktop, Server, Prep) with experience in workbook migration and optimization

Strong experience with Power BI (Desktop, Service, Dataflows) including DAX and Power Query

Experience with Snowflake-specific features relevant to BI (caching, clustering, result set optimization)

Familiarity with data modeling concepts including star schemas, snowflake schemas, and dimensional modeling

Proficiency in Python or R for data analysis, automation, and custom visualizations

Experience with extract scheduling, data refresh optimization, and incremental loading strategies

Familiarity with version control systems (e.g., Git) for BI asset management

Understanding of row-level security, data masking, and access control in BI environments

Behavioural Skills:

Strong problem-solving and analytical skills with attention to visual detail

Excellent communication abilities to collaborate with technical teams and business stakeholders

Proactive approach to identifying reporting issues and optimizing dashboard performance

Ability to manage multiple dashboard migrations and priorities effectively

Detail-oriented with a focus on data accuracy and visual consistency

Adaptability to work with evolving BI technologies and changing business requirements

Strong teamwork skills and ability to work in a collaborative environment