Business Intelligence Database Analyst

5 months 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 Worker's Compensation Board of Manitoba Full time

    The Business Intelligence, Analyst (BI Analyst) is responsible for conducting research and analysing large data sets utilizing the WCB data warehouse. The incumbent supports operational areas to develop specific requirements and research approaches to meet stated and unstated business needs and reports on findings. Additionally, through ongoing analysis and...


  • Winnipeg, Canada WCB Manitoba Full time

    **Job Summary**: The Business Intelligence, Analyst (BI Analyst) is responsible for conducting research and analysing large data sets utilizing the WCB data warehouse. The incumbent supports operational areas to develop specific requirements and research approaches to meet stated and unstated business needs and reports on findings. Additionally, through...


  • Winnipeg, Canada Workers Compensation Board of Manitoba WCB Manitoba Full time

    **Job Summary**: The Business Intelligence, Analyst (BI Analyst) is responsible for conducting research and analysing large data sets utilizing the WCB data warehouse. The incumbent supports operational areas to develop specific requirements and research approaches to meet stated and unstated business needs and reports on findings. Additionally, through...


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

  • Database Analyst

    5 months 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, Manitoba, Canada beBee Professionals Full time

    About the Role:We are looking for a talented Data Visualization Specialist to join our team at beBee Professionals in Winnipeg. The ideal candidate will have a strong background in data visualization and business intelligence, with experience in designing and developing interactive dashboards and visualizations. The successful candidate will be responsible...


  • Winnipeg, Manitoba, Canada Emergent BioSolutions Full time

    At Emergent BioSolutions, you will embark on a journey of growth and innovation as a Data Analyst, Business Intelligence Specialist. With our competitive salary of $110,000 per annum, you will excel in an environment characterized by respect, innovation, and opportunities for professional development.Job OverviewThis role is designed to provide data-driven...


  • Winnipeg, Manitoba, Canada beBee Professionals Full time

    beBee Professionals is seeking a Business Intelligence Analyst - Real Estate to join our team in Winnipeg. The successful candidate will be responsible for analyzing and interpreting data related to the real estate market, developing strategies to maximize profits, and providing insights to the team. The ideal candidate will have a Bachelor's degree in...


  • Winnipeg, Manitoba, Canada Manitoba Hydro Full time

    Job Title: Business Intelligence Data AnalystDevelop and maintain reports, dashboards, and other analytical tools to support business decision-making, with an emphasis on automation, using data and reporting tools like Power BI, Power Automate, and other Microsoft tools.Analyze data to identify trends, patterns, and provide insights to divisional...


  • Winnipeg, Canada Manitoba Hydro Full time

    **BUSINESS PERFORMANCE SYSTEMS ANALYST** **WINNIPEG, MB** Manitoba Hydro is consistently recognized as one of Manitoba's Top Employers! **_ Great Benefits_** - Competitive salary and benefits package. - Defined-benefit pension plan. - Nine-day work cycle which normally results in every other Monday off, providing for a balanced approach to work, family...

  • Data Analyst

    5 months ago


    Winnipeg, Canada Richardson International Full time

    At Richardson International, being truly invested is at the heart of everything we do. For 160 years, Richardson has been dedicated to Canadian agriculture. Recognized as a global leader in agriculture and food processing, Richardson is one of Canada’s Best Managed Companies. Headquartered in Winnipeg, Richardson has more than 3,000 employees across...


  • Winnipeg, Manitoba, Canada HEERA TRANSPORT LTD Full time

    Business Intelligence DeveloperAs a Business Intelligence Developer at {company}, you will be responsible for designing and implementing data visualizations and reports to support business decision-making. Your goal will be to create intuitive and user-friendly dashboards that provide actionable insights for stakeholders.Key Responsibilities:Develop data...


  • Winnipeg, Manitoba, Canada Chinese Universal Enterprise Full time

    Business Intelligence Developer Contribute to business success with data-driven insightsAs a Business Intelligence Developer, you will play a crucial role in helping our company make informed decisions by creating interactive dashboards and reports. Your mission will be to analyze complex data sets, identify trends, and present findings in a clear and...


  • Winnipeg, Manitoba, Canada MasterBrand Cabinets] Full time

    Job SummaryWe are seeking a highly skilled Senior Business Intelligence Specialist to join our team at MasterBrand Cabinets.Key ResponsibilitiesAnalyze and interpret complex business data to inform strategic decisions.Develop and maintain advanced business intelligence tools and dashboards.Collaborate with cross-functional teams to identify business needs...


  • Winnipeg, Canada Manitoba Hydro Full time

    **BUSINESS PERFORMANCE SYSTEMS ANALYST** **WINNIPEG, MB** Manitoba Hydro is consistently recognized as one of Manitoba's Top Employers! **_ Great Benefits_** - Competitive salary and benefits package. - Defined-benefit pension plan. - Nine-day work cycle which normally results in every other Monday off, providing for a balanced approach to work, family...


  • Winnipeg, Manitoba, Canada Wellington-Altus Full time

    Job Title: Business Systems AnalystJob Summary: We are seeking a highly skilled Business Systems Analyst to join our team at Wellington-Altus Private Wealth. As a Business Systems Analyst, you will play a key role in analyzing, validating, and defining business/system requirements, technology processes, and operational processes to meet the business needs...