Business Intelligence Database Analyst

4 months 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 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

**Competencies**:
**Essential**:
Analysis/Problem Assessment
Planning, Organizing and Follow-up
Teamwork/Collaboration
Quality Orientation/Attention to Detail
Technical/Professional Knowledge

**Very Important**:
Interpersonal Communication
Initiative

**Important**:
Impact

**Additional Information**:
You may be asked to demonstrate your ability through competency based interviewing and/or testing.
- MVA Applicable

  • Business Intelligence Database Analyst

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

  • Business Intelligence Database Analyst

    4 months ago

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

  • Business Intelligence Analyst

    2 months ago

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

  • Business Intelligence Analyst

    2 months ago

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

  • Business Intelligence Analyst

    2 months ago

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

  • Business Intelligence Analyst

    4 months ago

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

  • Intelligence Technician

    5 months ago

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

  • Business Intelligence ETL Analyst

    4 weeks ago

    Winnipeg, Manitoba, Canada Bass Pro Shops Full time

    Position: ETL Developer at Bass Pro ShopsOverview:As an ETL Developer at Bass Pro Shops, you will work under the guidance of the E-commerce & Data Analytics Manager. Your primary responsibility will be to design and implement programming scripts that facilitate the extraction, transformation, cleansing, and loading of data into data warehouse frameworks for...

  • Business Intelligence ETL Analyst

    2 months ago

    Winnipeg, Manitoba, Canada Bass Pro Shops Full time

    Position: ETL Developer at Bass Pro ShopsOverview:As an ETL Developer at Bass Pro Shops, you will work under the guidance of the E-commerce & Data Analytics Manager. Your primary responsibility will be to design and implement programming scripts that facilitate the extraction, transformation, cleansing, and loading of data into data warehouse frameworks for...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Winnipeg, Manitoba, Canada TEEMA Full time

    Job Title: Senior Data AnalystJob Summary:The Senior Data Analyst will play a key role in planning and executing Business User Acceptance Testing, acting as a technical liaison between business units and the data migration team. This position requires expertise in data migration, cleansing, and integration, as well as experience with databases, primarily...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Winnipeg, Manitoba, Canada TEEMA Full time

    Job Title: Senior Data AnalystJob Summary:The Senior Data Analyst will play a key role in planning and executing Business User Acceptance Testing, acting as a technical liaison between business units and the data migration team. This position requires expertise in data migration, cleansing, and integration, as well as experience with databases, primarily...

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

  • Crime and Intelligence Analyst

    5 months ago

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

  • Business Intelligence Analyst

    2 weeks ago

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

  • Business Intelligence Analyst

    2 weeks ago

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

  • Business Intelligence Analyst and Data Scientist

    4 weeks ago

    Winnipeg, Manitoba, Canada New Flyer Full time

    Job Title: BI Analyst and Data ScienceJoin our team at New Flyer, North America's leading heavy-duty transit bus manufacturer, as a key member of our Smart Bus Technology team. We're seeking a highly skilled Business Intelligence Analyst and Data Scientist to support the execution of all NFI Connect data science and project management, software applications...

  • Business Intelligence Analyst and Data Scientist

    4 weeks ago

    Winnipeg, Manitoba, Canada New Flyer Full time

    Job Title: BI Analyst and Data ScienceJoin our team at New Flyer, North America's leading heavy-duty transit bus manufacturer, as a key member of our Smart Bus Technology team. We're seeking a highly skilled Business Intelligence Analyst and Data Scientist to support the execution of all NFI Connect data science and project management, software applications...

  • Data Modeling and Reporting Professional

    2 months ago

    Winnipeg, Manitoba, Canada S.i. Systems Full time

    Job OverviewS.i. Systems is seeking an experienced Business Intelligence Developer to join our team. As an Intermediate Business Intelligence Developer, you will be responsible for creating reports using Informatica or SAP BusinessObjects, and dashboards using Power BI.Key ResponsibilitiesDesign and develop complex data models to support business...

  • Data Modeling and Reporting Professional

    2 months ago

    Winnipeg, Manitoba, Canada S.i. Systems Full time

    Job OverviewS.i. Systems is seeking an experienced Business Intelligence Developer to join our team. As an Intermediate Business Intelligence Developer, you will be responsible for creating reports using Informatica or SAP BusinessObjects, and dashboards using Power BI.Key ResponsibilitiesDesign and develop complex data models to support business...

  • Intermediate Business Intelligence Specialist

    2 months ago

    Winnipeg, Manitoba, Canada S.i. Systems Full time

    Job OverviewS.i. Systems is seeking an experienced Business Intelligence Developer to join our team. As an Intermediate Business Intelligence Developer, you will be responsible for creating reports using Informatica or SAP BusinessObjects, and dashboards using Power BI.Key ResponsibilitiesDesign and develop complex data models to support business...