Senior Systems Analyst (Senior Data Analyst)
British Columbia Institute of Technology
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Benefits offered by this job
Job summary
BCIT is seeking a regular, full-time Senior Systems Analyst to lead and support enterprise-scale data platforms and Power BI analytics within Information Technology Services in Burnaby.
The role focuses on MS Fabric-based data architectures, data warehouse modernization, ETL development, and delivering timely insights to business users, combining strong SQL, data modeling, and BI skills.
Qualifications
- Two-year diploma or bachelor’s degree plus six years of relevant experience, with at least four years in a data-focused role.
- Effective oral and written communication skills.
- Proven IT knowledge and commitment to customer service.
- Strong analytical and problem-solving abilities.
- Ability to work in cross-departmental teams and adapt to changing priorities.
Responsibilities
- Perform data analysis using PL/SQL or T-SQL to identify trends, anomalies, and data quality issues.
- Collaborate with business stakeholders on data quality and gather business logic for remediation.
- Develop data conversion scripts and manage ETL pipelines for centralized enterprise data.
- Design, develop, and maintain enterprise data warehouse and modern data platform architectures in MS Fabric.
- Develop dashboards in Power BI and build DAX/Power Query scripts; collaborate with users to gather requirements.
Skills
Education
Tools
Job description
Position Title Senior Systems Analyst (Senior Data Analyst)
At BCIT , putting people at the core of everything we do is paramount. This idea is the foundation of BCIT’s People Vision , which describes the Institute’s goals and priorities in respect to our people. In a complex and uncertain world, it’s vital our people feel valued, supported and connected. BCIT champions a culture of innovation and global progress through people’s imagination and creativity. With a competitive compensation package, great work-life balance, and career advancement opportunities, see why we’ve earned the title of one of BC’s Top Employers for over ten years running.
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.
- 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.
- Contribute to the planning, design, development, and deployment of new dashboards in Power BI.
- Build scripts using DAX and Power Query for Power BI.
- 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.
- 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.
- 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.
- 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.
- 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
- 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, !
BCIT is committed to equity, diversity, and inclusion and to promoting opportunities in hiring individuals who have been historically underrepresented in our workforce, BCIT , and the larger community. We strongly encourage Indigenous Peoples, women, racialized persons, persons with disabilities and those who identify as 2S/LGBTQIA+ to apply. While all qualified candidates are encouraged to apply, Canadian citizens and permanent residents will be given priority.
Accessibility is an integral part of BCIT’s commitment to equity and inclusion. If you require an accommodation for any part of the application or hiring process, For additional information, please visit our frequently asked questions (FAQs) page and learn more about how we hire.
The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of xwməθkwəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səl̓ilwətaɁɬ (Tsleil-Waututh).
Salary Range Salary Range: $84,685 - $112,200 per annum.
Salary prorated based on percentage and term of appointment. Salary based on education, experience and placement criteria as outlined in the Collective Agreement.
Posting Category Information Systems / Technology
Campus Location Burnaby campus
Bargaining Unit BCIT Faculty and Staff Association (FSA)
- * What is the highest level of education attained? Successful candidates will be required to submit official transcript(s) from the granting institution for verification.
- GED
- High School Diploma
- Certificate
- Diploma
- Associates Degree
- Bachelors Degree
- Masters Degree
- PHD
- * How many years of experience do you have in this type of position?
- 0-1
- 1-2
- 3-5
- 6-9
- 10+
- * Where a successful applicant places within the salary range is dependent on education, experience, and placement criteria as outlined in the Collective Agreement. Are you satisfied with being placed on this range?
- Yes
- No
- * All positions at BCIT require on campus presence at the applicable campus location(s). This means the successful candidate must be able to and willing to relocate to the Lower Mainland. Please select from the following that best describes your situation:
- I currently reside in the Lower Mainland
- I do not currently reside in the Lower Mainland, however I am willing and able to relocate if found to be the successful candidate
- I do not currently reside in the Lower Mainland and I am unwilling to relocate
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
