{bc}
Apply
linkedin

Senior Business Analytics & Insights

Coast Mountain Bus Company
Vancouver, CAN
Full Time
Senior
Hybrid
1 weeks ago
Data GovernanceData WarehouseBusiness IntelligenceSQL ServerSSISSSAS
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

Data GovernanceData WarehouseBusiness Intelligence
Smart Apply

Full Job Posting

Primary Purpose

  • Provides technical expertise to the development of a data governance framework for CMBC, including leading stakeholder engagement, developing, and monitoring progress of long term roadmap, establishing requisite business processes, and ensuring the Data Warehouse, Business Intelligence and Analytic
  • Provides technical leadership and supervision on the design, development, and quality assurance of monthly dashboard reports to the Executive Management Team (EMT), to ensure timely and accurate delivery.
  • Supports the Manager, Business Analytics & Insights with leading the annual Corporate Business Planning and Reporting process through stakeholder engagement with leaders from across the organization, ensuring alignment to Corporate and Enterprise level strategic plans.

Key Accountabilities

  • Provides technical leadership on planning and implementation of DW/BI&A solutions. Designs, implements, and maintains customized data warehouse, business intelligence and analytics (DW/BI&A) technical solutions.
  • Designs, implements, and maintains the Corporate Business Plan BI reporting solution, data collection process and KPI integration to ensure alignment of planned annual works to strategic long range workplans and Enterprise goals.
  • Provides technical expertise in the development and sustainment of a data governance framework for CMBC, including standardized documentation.
  • Stays abreast of new techniques, technologies, and industry trends, and participates in relevant industry events related to Data Governance.
  • Manages and develops projects of moderate to high impact, risk, and complexity. Designs and develops project scope, schedules, and work plans.
  • Provides technical support to the maintenance of custom Extract Transform Load (ETL) solution, as well as continual assessment of metadata reporting to ensure data integrity and quality assurance.
  • Consults and collaborates with business and technology stakeholders on data management and data architecture strategies, governance, practices, and policies.
  • Supports the Executive Management Team by providing KPIs to report on monthly performance; leads requirements gathering, target setting, report design and delivery and documentation.
  • Prepares quarterly reports for the CMBC Board of Directors and TransLink Statutory Reporting requirements.
  • Provides support to the Manager in the development and maintenance of the Team’s Strategic Plan Roadmap, planning and decisions making.
  • Participates in the development and implementation of a continuous improvement strategy by offering Business Process advisory services to other departments.
  • Acts as a key liaison with International Benchmarking Groups to conduct detailed surveys and analysis.

Education & Experience

  • Completion of a university degree in Computer Science, Information Systems, Data Analytics, or other relevant business related fields plus seven (7) years of progressive experience in performance reporting functions in a multifaceted organization.

Other Requirements

  • Advanced knowledge of concepts, principles, practices and techniques pertaining to all aspects of performance measures, benchmarking, balanced scorecards and dashboards.
  • Excellent knowledge of Microsoft Data Warehouse and BI technologies, both Cloud and on prem (SQL Server, SSIS, SSAS, SSRS, Power BI Desktop, PowerBI Report Builder, PowerBI Service, Tableau etc.).
  • Strong knowledge of Microsoft PowerPlatform solutions including PowerApps, PowerAutomate and Power Platform Admin Centre.
  • Strong knowledge and understanding of the relevant concepts of data mining and data warehousing.
  • Demonstrated ability to communicate the complexities of technical programs (e.g. Kimball methodology, modern data warehousing).
  • Advanced experience of data modeling and business process design software, such as Visio.
  • Advanced knowledge of coaching and mentoring teams on Data Warehouse & Business Intelligence Architect concepts and methodology.
  • Advanced analytical and problem solving skills to handle conflict resolution, facilitating discussion and alternatives of different approaches.
  • Solid leadership skills with ability to manage and influence direct or indirect reporting staff, and to provide specialized guidance and expertise to all levels of the organization.
  • Excellent planning, organization, and time management skills with strong ability to organize competing priorities.
  • Experience maintaining ETL process using software such as SSIS.
  • Prior experience in design, deployment, or sustainment of Data Governance Program.

Work Schedule

  • 37.5 hours per week.
  • Hybrid work designation: offers flexibility of working both on site and remotely within B.C.

Rate of Pay

  • Salary range from CAD 84,480 CAD 126,720 per annum.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today