Senior Systems Analyst (Senior Data Analyst)

British Columbia Institute of Technology

• $84K — $112K *
Education, Government & Non-Profit
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Two-year diploma or bachelor's degree in a relevant field, with 6+ years of experience in data analysis.
  • Expertise in Oracle PL/SQL or T-SQL for large database querying and analysis.
  • Proven skills in developing data solutions using MS Fabric and Power BI.
  • Strong commitment to customer service, data governance, and ethical data practices.
  • Ability to collaborate with stakeholders and manage multiple priorities effectively.

Responsibilities

  • Conduct data analysis to identify trends and quality issues using PL/SQL or T-SQL.
  • Collaborate with stakeholders to address data quality, gathering insights for remediation.
  • Design and maintain enterprise data architectures, focusing on scalability and efficiency.
  • Develop and implement ETL pipelines for data ingestion into central repositories.
  • Create and launch new dashboards in Power BI, utilizing DAX and Power Query.
  • Document data flows and business logic with AI tools for transparency and sustainability.
  • Work alongside teams to gather requirements and ensure alignment with business objectives.

Benefits

  • Minimum of twenty-five days of vacation per year.
  • Employer-paid extended health and dental coverage.
  • Defined benefit pension plan with employer contributions.
  • Flexible hybrid work options available.
  • Professional development funds and access to free courses at BCIT.
  • Employee wellness programs and complimentary fitness centre membership.
Full Job Description
Position Details

Position Information

Position Title
Senior Systems Analyst (Senior Data Analyst)

Position Summary

BCIT's Information Technology Services department is seeking a regular, full-time (1.0 FTE) Senior Systems Analyst to participate in the ERP modernization initiatives. This position plays a key role as an experienced senior data analyst to design, develop, and support enterprise-scale data platforms and solutions.

The Senior Systems Analyst will be responsible for Microsoft Fabric, enterprise database, enterprise data warehouse, data factory, ETL pipelines, data conversion and migration initiatives, and providing business users with accurate, timely, and actionable insights through Power BI.

Duties & Responsibilities

DUTIES AND RESPONSIBILITIES:

Development and Analysis:

  • Perform data analysis using PL/SQL or T-SQL to identify trends, anomalies, and data quality issues.
  • Collaborate with business stakeholders on data quality issues and gather business logic for remediation.
  • Participate in data modelling, develop complex PL/SQL or T-SQL scripts and stored procedures that will be used in Data Conversion.
  • Design, develop, and maintain enterprise data warehouse and modern data platform architectures in MS Fabric.
  • Develop scalable data ingestion and ETL pipelines to load data into centralized enterprise database and data warehouse.


Dashboard and Reporting:
  • Contribute to the planning, design, development, and deployment of new dashboards in Power BI.
  • Build scripts using DAX and Power Query for Power BI.


Documentation & Collaboration:
  • Collaborate with business users and functional analysts to gather requirements.
  • Use AI tools like Cursor or Claude to document data flows, transformations, and business rules to support transparency and sustainability.


Qualifications

QUALIFICATIONS:

  • Minimum two-year diploma in Computer Systems, Data Management, or a related discipline, or a bachelor's degree in computer science, information systems, statistics, business, or related field; plus a minimum of six (6) years of current, practical experience, of which at least four (4) years must be in a similar role or a closely related data-focused role.
  • An equivalent combination of education, training, and experience may be considered.
  • Effective oral and written communication skills.
  • Must have demonstrated specific current IT knowledge.
  • Proven commitment to providing and maintaining the highest level of customer service.
  • Proven analytical and problem-solving skills.
  • Strong organizational skills with the ability to manage changing priorities and meet deadlines.
  • Ability to work effectively as part of a team and with cross-departmental groups.
  • Ability to learn quickly and apply new knowledge and techniques.
  • Commitment to ongoing professional development.
  • High level of professionalism and ethical responsibility, particularly in the handling of institutional data.


Qualifications Specifics:
  • Proficiency Oracle PL/SQL or T-SQL, and stored procedures for querying, data manipulation, and analysis in large, complex databases environment.
  • Experience in MS Fabric platform including data factory, and One Lake.
  • Proficiency with DAX, Power Query and Microsoft Power BI.
  • Solid understanding of data governance principles, data quality, and data lifecycle management
  • Experience in enterprise or corporate data modeling with strong understanding of dimensional modelling, analytical data structures and reporting requirements
  • Experience with data analysis, profiling, and validation techniques
  • Experience designing and creating SSIS and executing ETL/ELT processes to support enterprise reporting and analytics platforms.
  • Familiarity with data integration tools, orchestration platforms, or pipelines used in enterprise environments.
  • Experience working in agile or hybrid delivery environments.


Nice-to-Have Qualifications:
  • Hands-on experience working with a post-secondary ERP, preferably Ellucian Banner ERP, including understanding of core data structures and functional modules.
  • Experience with Ellucian Ethos and Ethos Data Models.
  • Experience supporting Banner SaaS implementations or migrations.
  • Experience working with post-secondary institutional data standards and regulatory reporting.
  • Experience with data governance or metadata management tools.
  • Familiarity with JIRA or similar work management tools.
  • Experience with other analytics tools like Tableau, Ellucian Insights, and Argos.


Additional Information

Benefits - Why you'd love working with us

  • Competitive pay
  • Minimum of twenty-five days of vacation (or more, depending on your position)
  • Competitive employer-paid extended health and dental plan - take a look at our benefit plans!
  • Defined benefit pension plan with employer contributions
  • Flexible hybrid work arrangements available
  • Professional Development funds and resources
  • Access to most BCIT Flexible Learning courses free of charge
  • Wellness and Employee Assistance programs
  • Complimentary membership with free access to the Fitness Centre, Gymnasium, and more
  • Eligibility requirements apply, benefits may vary depending on the employee group the position belongs to and whether the position offered is temporary or part-time. For more information on our generous benefits, click here!


Salary Range
Salary Range: $84,685 - $112,200 per annum.

Additional Salary Information

Salary prorated based on percentage and term of appointment. Salary based on education, experience and placement criteria as outlined in the Collective Agreement.

Position Details

Posting Category
Information Systems / Technology

Department 2
Cloud Tech & Infrastructure Serv

Campus Location
Burnaby campus

Bargaining Unit
BCIT Faculty and Staff Association (FSA)

Job Status
Regular

Full-Time/Part-Time
Full-Time

Number of Vacancies
1

Anticipated Start Date
11/02/2026

Anticipated End Date

Competition Information

Competition Number
26FSA107

Competition Open Date
09/05/2026

Competition Close Date
10/03/2026

Open Until Filled?
No

Quicklink for Posting
https://careers.bcit.ca/postings/10663

Similar Jobs

More Jobs at British Columbia Institute of Technology

More Education, Government & Non-Profit Jobs

Find similar Senior Systems Analyst (Senior Data Analyst) jobs: