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.
- Maintains and continually improves practices that achieve high quality of Business Intelligence assets and improve confidence in data, processes, and development disciplines.
- Ensures compliance of WCB business intelligence database standards and guidelines by developing and maintaining documentation pertinent to standards, methodology, and operational procedures.
- Participates in the acquisition, implementation and installation of acquired hardware and/or software for data warehousing applications.
- Manages the data warehouse performance and tuning.
- Ensures the business intelligence applications and databases are pro-actively maintained and available for Business and Project teams to use.
- Works closely with Information Technology to ensure the platforms supporting the business intelligence applications are in optimal condition.
- Works closely with Information Technology to administer BI Portals, including developer and user security & access.
- Installs, configures, maintains and upgrades database management systems.
- Coordinates any changes to the configuration of the business intelligence applications.
- Performs other related duties as assigned.
Qualifications:
- Four (4) year Bachelor's Degree in Computer Science from a recognized post-secondary institution
- Five (5) years' experience working as a Database Analyst preferably building and designing Data Warehouses
- Expertise in relational and multidimensional database schemas, designing and building OLAP (online analytical processing) 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 indicator and Business Connectivity Services (BCS)
- Experience using SQL Service Integration Services (SSIS) to implement complex normalization and transformation logic to load data into a data warehouse from disparate data sources
- Experience using SQL Server Analysis Services functionality
- Experience using SQL Reporting Services (SSRS) to create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources
- Experience developing SQL data warehouse with metadata-driven mapping to support customer analysis capabilities
- Advanced experience and knowledge of MS SQL, DAX/MDX programming
- Knowledge of Microsoft BI Semantic Model vision and tools such as PowerPivot, PowerView & PowerQuery; MS Azure and Power BI and operating systems, networking software, and data security in general
- Strong analytical skills and experience are required for the tasks of troubleshooting a data warehouse server and carrying out data warehouse design
- Excellent communication and interpersonal skills
- Microsoft Certified Solution Associate (MCSA), Microsoft Certified Solution Expert for Business Intelligence (MCSE BI) or Microsoft Certified Database Administrator (MCDBA) considered an asset
- Ability to develop/configure BI Web Parts using SharePoint Services considered an asset
- Ability to communicate proficiently in both official languages (English & French) is an asset
Additional Information
- Ability to communicate proficiently in both official languages (English & French) is an asset.
- A satisfactory criminal record check and verification of education will be required for the successful candidate.
- The WCB is committed to building a skilled, diverse workforce with equitable representation of Indigenous persons, visible minorities, persons with disabilities, women, 2SLGBTQ+ persons and members of other equity-seeking groups. Applicants are encouraged to indicate in their covering letter or resumé if they are a member of these groups.
- The WCB recognizes that individuals may face barriers that hinder their full and equal participation in the workplace, and is committed to providing reasonable accommodation to all employees and candidates who are or may be disabled by one or more barriers in the workplace. Accommodations are available on request for candidates taking part in all aspects of the selection process.
- The Workers Compensation Board promotes safety and health in Manitoba workplaces and aims to help prevent and reduce the occurrence of workplace injuries and disease. Working with its partners, the WCB promotes safe and healthy workplaces, facilitates recovery and return to work, provides compassionate and supportive compensation services for workers and employers, and ensures responsible financial stewardship.
- WCBdoes encompasses what it means to work at the WCB. The WCB is proud to have employee benefits and programs that support financial and personal security, foster health and well-being, encourage involvement and support growth as an individual and member of the WCB community. The four categories of WCBdoes include: Security, Wellness, Engagement and Growth.