Senior BI Developer

Job Description

Senior BI Developer
On behalf of our client, Procom is currently seeking a Senior BI Developer.

Senior BI Developer Job Details

• Migrate Cognos reports/cubes on Microsoft platform (SSAS/SSRS/Power BI as applicable)
• Work with BCSHS programs users on new/additional reporting requirements and create new cubes/reports/dashboards for BCSHS using Microsoft tools.
• Convert business requirements into technical specifications and decide timeline to accomplish.
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights. Assist in identifying key performance indicators (KPIs) with clear objectives and consistently monitor those
• Advise and implement latest Microsoft platform features as applicable.
• Work with PHSA team on data modelling that includes Data warehouse development with Microsoft SSMS and SSIS.
• Set up BCSHS reporting platform in line with PHSA’s.
• Assist in infrastructure related work (e.g. data migration and cloud migration) to ensure stability and integrity of BCSHS platform which is connected to PHSA platform.
• Backfill the team’s reporting resources as needed to enable them to address BCSHS requirement and design based on their PHSA experience.
• Manage the administration of user access and infrastructure if needed.
• Work with users and team members at all levels for understanding business requirements
• Train technical and Business users in delivered solutions.
• Design, develop, maintain, and optimize Power BI, SSRS, and SSAS solutions, including dashboards, reports, semantic models, security models, and performance optimization.
• Develop and maintain SQL Server databases, complex SQL queries, stored procedures, views, and functions to support business intelligence and reporting requirements.
• Implement data validation, reconciliation, and data quality processes to ensure the accuracy, consistency, and integrity of reporting solutions.
• Create and maintain technical documentation for BI solutions, data models, ETL processes, reporting assets, and system architecture, and provide production support and troubleshooting as required.

1. Deliverables expected AND dates on which deliverables are due

• Phase 1 BCSHS reports, dashboards and cubes – Nov 30, 2026.
• Next phases of report migration and new development are TBD after Phase 1 delivery. Expected completion of all phases is October 30, 2027. Timeline is subjected to change without prior notice. SOW will be amended/extended as applicable.

 Senior BI Developer Mandatory Skills

Experience in Power BI, SSAS, SSRS, SSIS, SQL using data/row level security
Comprehensive knowledge of data design, data modeling, data management, and data visualization
• Advanced SQL skills
• In depth experience of  Power BI and DAX
• Practical experience with tabular or multi-dimensional cubes (ex: SSAS, Cognos TM1 etc)
• Practical experience with ETL tools (ex: SSIS, Informatica etc)
• Practical experience with BI reporting tools (Ex: SSRS, Cognos Report Studio, Tableau etc)
• Experience with other BI tools e.g. Cognos, Tableau etc.
• Ability to interact with business as well as technical teams
• Experience with Business analysis, project planning
• Strong communication and client management skills
• Ability to learn and respond quickly to the fast-changing business environment
• Stay updated with advancements and best practices in design and development
• Ability to multitask and excellent interpersonal skills
• Ability to prioritize and manage competing priorities
• Document process, models, designs, and solutions and able to explain, represent, and discuss with the team
• Apply learned lessons into future solution considerations
• Analytical mindset with a problem-solving approach
• Ability to work in an agile, dynamic environment with a focus on continuous improvement along with frequent iterations of product build and touch base with users and team
• Self-motivated and eager to learn
• A team player and able to lead and initiate
• Willing to go above and beyond as needed to make the project successful
• Self-starter as well as team player
       • Experience with data quality, reconciliation, security models, and performance optimization



Senior BI Developer Assignment Length
12 months

 Senior BI Developer Start Date
ASAP

Senior BI Developer Assignment Location
PST working hours