Business Intelligence Database Developer
Designs, builds, and maintains the Workers Compensation Board of Manitoba's enterprise data warehouse and BI foundation — leading ETL, OLAP cube, and semantic model development, performance tuning, and reporting, primarily on the Microsoft SQL Server stack (SSIS, SSAS, SSRS, Power BI). On-site role in Winnipeg.
- Compensation
- Not disclosed
- Location
- Winnipeg, Canada
- Work setup
- Remote
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- Not specified
- Category
- Software engineering
- Posted
Skills
Must have
- Four-year Bachelor's Degree in Computer Science from a recognized post-secondary institution
- Five years' experience working as a Database Analyst, preferably building and designing data warehouses
- Expertise in relational and multidimensional database schemas, designing and building OLAP cubes, writing queries and designing reports
- Experience installing and configuring a database management system (DBMS), preferably Microsoft SQL Server
- Experience developing SharePoint dashboards and scorecards, Excel Services, PerformancePoint Services, Chart Web Parts, KPI status indicators and Business Connectivity Services (BCS)
- Experience using SQL Server Integration Services (SSIS) to implement complex normalization and transformation logic for data warehouse loads
- Experience using SQL Server Analysis Services functionality
- Experience using SQL Server Reporting Services (SSRS) to create interactive, tabular, graphical, or free-form reports
- Experience developing SQL data warehouse with metadata-driven mapping
- Advanced experience and knowledge of MS SQL, DAX/MDX programming
- Knowledge of Microsoft BI Semantic Model tools (PowerPivot, PowerView, PowerQuery), MS Azure and Power BI, plus operating systems, networking software and data security
- Strong analytical skills for troubleshooting a data warehouse server and carrying out data warehouse design
- Excellent communication and interpersonal skills
Nice to have
- Microsoft Certified Solution Associate (MCSA), MCSE for Business Intelligence, or MCDBA certification
- Ability to develop/configure BI Web Parts using SharePoint Services
- Proficiency in both official languages (English & French)
Full description
Business Intelligence Database Developer
Position ID:
J0926-0721
Competition No.:
26-70
Job Title:
Business Intelligence Database Developer
About the Workers Compensation Board of Manitoba
The Workers Compensation Board of Manitoba (WCB) serves workers and employers through a no-fault insurance system integral to the Manitoba economy. With approximately 600 employees, the WCB is dedicated to ensuring and supporting safe and healthy workplaces.
We put workers and employers at the centre of everything we do, providing services for injury prevention, compensation and facilitating return to health and work. Through SAFE Work Manitoba, a division of the WCB, we collaborate with our partners to build a strong culture of workplace safety and health by preventing injuries and illnesses before they occur.
If you're passionate about making a meaningful difference in people's lives, we invite you to join our dedicated team and contribute to a safer Manitoba.
Why work for us?
If you’re looking to make a real difference in your community, grow your career and work in a supportive, inclusive environment, the WCB is the place for you. We offer:
- competitive wages
- compressed work week and flexible start times
- work from home program
- health and wellness spending accounts
- paid mental health and wellness days
- staff appreciation and recognition events
- respectful, diverse and inclusive workplace culture
The Business Intelligence, Database Analyst (BI DBA) is responsible for transforming WCB operational data into information that is stored and managed utilizing WCB data warehouses. The incumbent maintains the foundation technology and data for all advanced analysis and research for WCB to improve programs, develop new methods and gain understanding of the changing work conditions in Manitoba.
Job Duties:
- Leads the data warehouse solution design, development and implementation including Enterprise Data Warehouse (EDW) BI Semantic Models, Extract/Transform/Load (ETL), and OLAP development.
- Contributes to standards and frameworks for data modelling, data integration/ETL and reporting and ensure these are being consistently used in the design and development of all relevant solutions.
- Ensures new business intelligence applications integrate and comply with the business intelligence architecture.
- Keeps abreast of the latest trends in business intelligence technologies and practice, technologies on application integration, process management and service-orientated application development.