Current jobs related to Business Intelligence Database Analyst - Winnipeg - Workers Compensation Board of Manitoba WCB Manitoba
-
Business Intelligence Data Analyst
3 days ago
Winnipeg, Canada Compugen Inc Full time**Job Title** - Business Intelligence Data Analyst - Contract **Vacancy No** - VN477 **Work Location** - Winnipeg, MB **Job Details** **About Compugen** - Compugen 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 to help...
-
Business Intelligence Analyst
1 week ago
Winnipeg, Canada Broadstreet Properties Ltd Full timeThe Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross‑functional business intelligence initiatives including data integration, reporting, automation, and ad‑hoc analytics. The analyst will play a critical role in designing and developing customized data models and...
-
Business Intelligence Analyst
1 week ago
Winnipeg, Canada Broadstreet Properties Full timeThe Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross-functional business intelligence initiatives including data integration, reporting, automation, and ad-hoc analytics. The analyst will play a critical role in designing and developing customized data models and...
-
Business Intelligence Analyst
3 weeks ago
Winnipeg, Canada Broadstreet Properties Ltd Full timeThe Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross‑functional business intelligence initiatives including data integration, reporting, automation, and ad‑hoc analytics. The analyst will play a critical role in designing and developing customized data models and...
-
Business Intelligence Analyst
2 weeks ago
Winnipeg, Canada Broadstreet Properties Full timeThe Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross‑functional business intelligence initiatives including data integration, reporting, automation, and ad‑hoc analytics. The analyst will play a critical role in designing and developing customized data models and...
-
Business Intelligence Analyst
6 days ago
Winnipeg, Canada Broadstreet Properties Full timeThe Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross-functional business intelligence initiatives including data integration, reporting, automation, and ad-hoc analytics. The analyst will play a critical role in designing and developing customized data models and...
-
Business Intelligence Analyst
1 week ago
Winnipeg, Canada Broadstreet Properties Ltd Full timeThe Business Intelligence - Business Analyst is a key member of a centralized BI team supporting business operations. This role supports cross‑functional business intelligence initiatives including data integration, reporting, automation, and ad‑hoc analytics. The analyst will play a critical role in designing and developing customized data models and...
-
Business Intelligence Analyst
7 days ago
Winnipeg, 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...
-
Business Intelligence Analyst
1 week ago
Winnipeg, Canada PRICELINE CAREERS Full timeThis role is eligible for our hybrid work model: 2 days in-office Business Intelligence Analyst At Priceline we are a data-driven organization, which makes our Analytics teams the brains of our operation. On the cutting edge of customer and business analytics, we make sure all our decisions and innovations are based on the latest insights. Why this job’s a...
-
Business Intelligence Analyst
6 days ago
Winnipeg, Canada PRICELINE CAREERS Full timeThis role is eligible for our hybrid work model: 2 days in-office Business Intelligence Analyst At Priceline we are a data-driven organization, which makes our Analytics teams the brains of our operation. On the cutting edge of customer and business analytics, we make sure all our decisions and innovations are based on the latest insights. Why this job’s a...
Business Intelligence Database Analyst
3 weeks ago
**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 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
**Additional Information**:
1-year Term Position
Ability to communicate proficiently in both official languages (English & French) is an asset.
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.
**About WCB**:
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.
