![Workers Compensation Board of Manitoba](https://media.trabajo.org/img/noimg.jpg)
Business Intelligence Database Analyst
4 days ago
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?
-
Business Intelligence Database Analyst
4 days ago
Winnipeg, Canada Worker's Compensation Board of Manitoba Full timeThe 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...
-
Business Intelligence Database Analyst
4 days ago
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...
-
Business Intelligence Analyst
3 weeks ago
Winnipeg, Canada World Trade Centre Winnipeg Full timeJob 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 timePress 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 timePress 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...
-
Business Intelligence Data Analyst
3 days ago
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,...
-
Business Intelligence Data Analyst
2 weeks ago
Winnipeg, Manitoba, Canada Compugen Inc Full timeJob 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...
-
Business Intelligence Analyst
4 days ago
Winnipeg, Canada Broadstreet Properties LTD Full timeThe 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...
-
Business Intelligence Analyst
2 weeks ago
Winnipeg, Manitoba, Canada Broadstreet Properties LTD Full timeThe 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...
-
Business Intelligence Analyst
2 weeks ago
Winnipeg, Manitoba, Canada CAA Club Group Full timeAbout 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...
-
Supervisor, Business Intelligence
2 weeks ago
Winnipeg, Manitoba, Canada WCB Manitoba Full timeJob 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...
-
Intelligence Technician
3 weeks ago
Winnipeg, Canada City of Winnipeg Full timeUnder 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 timeJohnston 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,...
-
Crime and Intelligence Analyst
3 weeks ago
Winnipeg, Canada City of Winnipeg Full timeUnder 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...
-
Crime and Intelligence Analyst
3 weeks ago
Winnipeg, Canada City of Winnipeg Full timeUnder 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...
-
Crime and Intelligence Analyst
2 weeks ago
Winnipeg, Manitoba, Canada City of Winnipeg Full timeUnder 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...
-
Data & Intelligence Analyst
4 weeks ago
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...
-
Intelligence Analyst
1 week ago
Winnipeg, Canada Canada Life Assurance Company Full timeIntelligence 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...