Business Intelligence Database Analyst

4 days ago


Winnipeg, Canada Workers Compensation Board of Manitoba Full time

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.

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.

Manages the data warehouse performance and tuning.

Works closely with Information Technology to administer BI Portals, including developer and user security & access.

Installs, configures, maintains and upgrades database management systems.

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) for SQL 2008 or 2012, 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
- Are you interested in this job?



  • Winnipeg, Canada Worker's Compensation Board of Manitoba Full time

    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...


  • Winnipeg, Canada WCB Manitoba Full time

    **Job Summary**: 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...


  • Winnipeg, Canada World Trade Centre Winnipeg Full time

    Job Title**:Business Intelligence Analyst** **Salary**: Based on experience Full-time position **Summary of Role**: The Business Intelligence (BI) Analyst’s purpose is to support the WTC Winnipeg in maturing the organization’s use of data as it seeks to grow opportunities for Manitoba companies that are seeking to grow globally, producing measurement...

  • Intelligence Analyst

    8 hours ago


    Winnipeg, Canada POLITICAL INTELLIGENCE SL Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: The Intelligence Analyst – as part of a dynamic team responsible for the fraud detection activities for group insurance benefits – supports the Fraud Management Team by analyzing data for fraud risk, providing intelligence support to complex fraud...

  • Intelligence Analyst

    6 hours ago


    Winnipeg, Canada POLITICAL INTELLIGENCE SL Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: The Intelligence Analyst – as part of a dynamic team responsible for the fraud detection activities for group insurance benefits – supports the Fraud Management Team by analyzing data for fraud risk, providing intelligence support to complex fraud...


  • Winnipeg, Canada Compugen Inc Full time

    **Job Title** - Business Intelligence Data Analyst **Vacancy No** - VN6028 **Work Location** - Winnipeg, MB **Job Details** **Title: Business Intelligence Data Analyst** **Location: Winnipeg, MB** **About Compugen** Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire,...


  • Winnipeg, Manitoba, Canada Compugen Inc Full time

    Job Title Business Intelligence Data AnalystVacancy No VN6028Work Location Winnipeg, MBJob DetailsTitle: Business Intelligence Data AnalystLocation: Winnipeg, MBAbout CompugenCompugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire, integrate and operate technology. Our mission is...


  • Winnipeg, Canada Broadstreet Properties LTD Full time

    The Business Intelligence Analyst will be responsible for preparing and distributing financial and operational reporting to key stakeholders and provide analytical support on company performance as required. The role will support in the budgeting process and will be responsible for key deliverables to management while liaising with regional operations staff...


  • Winnipeg, Manitoba, Canada Broadstreet Properties LTD Full time

    The Business Intelligence Analyst will be responsible for preparing and distributing financial and operational reporting to key stakeholders and provide analytical support on company performance as required. The role will support in the budgeting process and will be responsible for key deliverables to management while liaising with regional operations staff...


  • Winnipeg, Manitoba, Canada CAA Club Group Full time

    About Us:As our Business Intelligence Analyst at CAA Club Group of companies, you will extract and analyze sales and operational data that show market trends, sales performance, operational and promotional performance for existing services, and assess new business opportunities. Our Business Intelligence team get to be the "hero" to our internal customers by...


  • Winnipeg, Manitoba, Canada WCB Manitoba Full time

    Job Summary:The Supervisor, Business Intelligence provides leadership, guidance, direction and support to a team of Business Intelligence Analysts. The incumbent provides oversight and direction to the BI analysts group to ensure the deliverables produced meet the quality and analytical standards of the department. The incumbent works with the different WCB...


  • Winnipeg, Canada City of Winnipeg Full time

    Under the general supervision of the Crime and Intelligence Analyst, the Intelligence Technician contributes in-depth knowledge to highly-sensitive portfolios within the Crime Analysis Unit (CAU), involving complex tasks with the highest consequences of error. The Intelligence Technician reviews, collates, and extracts meaning from data across multiple...


  • Winnipeg, Manitoba, Canada Johnston Group Full time

    Johnston Group provides employee benefit solutions to over 30,000 companies, ranging from one employee to thousands across various product lines, including Chambers of Commerce Group Insurance Plan, Canada's #1 employee benefits plan for small businesses. JG is a platinum member of _Canada's Best Managed Companies_ and was named one of _Manitoba's Top...

  • Business Intelligence

    2 weeks ago


    Winnipeg, Canada Eptura Full time

    **Job Title**: Business Intelligence (BI) Analyst **Location**: Atlanta. GA -or - Winnipeg, Canada **Who are we**: We’re Eptura — a global worktech company that provides software solutions for workplaces, people, and assets that enable everyone to reach their full potential. Our people are at the heart of everything we do, spanning 11 global offices...

  • Database Analyst

    2 weeks ago


    Winnipeg, Canada Radical Data Science Ltd Full time

    **Key Responsibilities**: - Administer, maintain, and support multiple databases across various platforms to ensure their performance, availability, and security. - Develop and optimize SQL databases in both Windows and Linux environments. - Design and implement data integration solutions to meet business requirements. - Collaborate with teams, partners,...


  • Winnipeg, Canada City of Winnipeg Full time

    Under the general direction of the Crime Analysis Supervisor, the Crime and Intelligence Analyst performs advanced functions in collecting, collating, analyzing and disseminating criminal intelligence data relevant to actual and anticipated criminal activity. The Crime and Intelligence Analyst supports police decision-making by providing highly detailed...


  • Winnipeg, Canada City of Winnipeg Full time

    Under the general direction of the Crime Analysis Supervisor, the Crime and Intelligence Analyst performs advanced functions in collecting, collating, analyzing and disseminating criminal intelligence data relevant to actual and anticipated criminal activity. The Crime and Intelligence Analyst supports police decision-making by providing highly detailed...


  • Winnipeg, Manitoba, Canada City of Winnipeg Full time

    Under the general direction of the Crime Analysis Supervisor, the Crime and Intelligence Analyst performs advanced functions in collecting, collating, analyzing and disseminating criminal intelligence data relevant to actual and anticipated criminal activity.The Crime and Intelligence Analyst supports police decision-making by providing highly detailed...


  • Winnipeg, Canada Downtown Community Safety Partnership Full time

    **JOB DESCRIPTION** **REPORTS & RESPONSIBLE TO**: The Data and Intelligence Analyst reports directly to the Director of Operations and Intelligence. ***: The Data and Intelligence Analyst will play an integral role on data management and analytics of the organization. Working closely with the Director of Operations and Intelligence, the incumbent will...


  • Winnipeg, Canada Canada Life Assurance Company Full time

    Intelligence Analyst **Description: - Permanent Full Time- **Accountabilities**: - Provide support to investigators, management and other stakeholders by understanding, preparing and analyzing data for regular and ad-hoc requests. - Manipulate and prepare large volumes of claims data and analyze this data to understand and identify trends, anomalies and...