Business Intelligence Database Analyst
5 months 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
5 months 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
5 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...
-
Business Intelligence Analyst
3 months ago
Winnipeg, Canada Worker's Compensation Board of Manitoba Full timeThe 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
3 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
3 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
5 months 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...
-
Intelligence Technician
6 months 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...
-
Crime and Intelligence Analyst
6 months 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...
-
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,...
-
Business Intelligence Analyst
1 month ago
Winnipeg, Manitoba, Canada beBee Professionals Full timeAbout 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 timeAt 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...
-
Business Intelligence Analyst
1 month ago
Winnipeg, Manitoba, Canada beBee Professionals Full timebeBee 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 Data Analyst
3 weeks ago
Winnipeg, Manitoba, Canada Manitoba Hydro Full timeJob 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...
-
Business Performance Analyst
6 months ago
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 timeAt 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...
-
Business Intelligence Developer
3 weeks ago
Winnipeg, Manitoba, Canada HEERA TRANSPORT LTD Full timeBusiness 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...
-
Business Intelligence Developer
3 weeks ago
Winnipeg, Manitoba, Canada Chinese Universal Enterprise Full timeBusiness 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...
-
Senior Business Intelligence Specialist
4 days ago
Winnipeg, Manitoba, Canada MasterBrand Cabinets] Full timeJob 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...
-
Business Performance Systems Analyst
6 months ago
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...
-
Business Systems Analyst
3 weeks ago
Winnipeg, Manitoba, Canada Wellington-Altus Full timeJob 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...