DEPARTMENT OVERVIEW

The Advanced Solutions Data Engineering and Analytics team supports the data warehousing, reporting and analytics services provided by the Advanced Solutions Application Services practice. The team is multidisciplinary and delivers solutions to multiple clients in several technology stacks. The broad goal of this department’s work is to help clients build and maintain modern data architectures to maximally leverage their data assets in an increasingly data-driven world. Key functions include:

•    Design development, and maintenance of data pipelines. 

•    Design, development, maintenance, and operations of data warehousing and business intelligence systems. 

•    Delivery of business intelligence and analytics services; and 

•    Delivery of consulting services for data architecture, data engineering, data management and business intelligence.

DESCRIPTION

Reporting to the Team Lead of Data Engineering and Analytics, the Data Management and BI Specialist plays a key role in designing, implementing, and maintaining data solutions for both internal and external clients in the Microsoft Fabric data platform. This position combines hands-on technical work with client consultation to deliver effective data management processes and business intelligence solutions. 

This role requires versatility across the data stack, with responsibilities split between data engineering (40%), business intelligence (30%), and stakeholder consultation and solution design (30%). The successful candidate will spend time building and maintaining data pipelines and structures while also creating impactful visualizations and reports. Typical tasks include developing Power BI dashboards, optimizing data models, building and testing data pipelines, and consulting with stakeholders on data architecture decisions.

ACCOUNTABILITIES/DELIVERABLES

•    Design, implement, and orchestrate data pipelines using Microsoft Data Factory and Data Engineering tools to support both operational and analytical needs.

•    Design, implement and optimize analytical databases in T-SQL using Fabric MSSQL databases and Synapse Data Warehouses.

•    Design, implement and optimize Lakehouse’s using Synapse Data Engineering and notebooks.

•    Develop and maintain Power BI reports and dashboards, ensuring they meet business requirements and follow best practices.

•    Develop Power Query transformations in Power BI and Data Factory.

•    Collaborate with stakeholders, including external clients, and internal leadership to understand business requirements and translate them into technical solutions.

•    Design and implement data quality processes and governance standards to ensure accuracy of data and robustness of systems processes.

•    Perform systems, end-to-end data validation and unit testing of data engineering systems.

•    Support the preparation of data structures suitable for future AI/ML initiatives.

•    Document technical processes and maintain solution documentation.

•    Provide guidance to business users on self-service BI tools and data access.

•    Provides architectural guidance to clients on the design and structure of fabric artefacts to ensure performance, stability, and cost-effectiveness.

•    Provides technical advice and recommendations to develop action plans for streamlining data processes, enhancing reporting accuracy, and ensuring compliance with contractual and operational standards.

* Prepares and analyzes data and reports that are used to drive contractual performance metrics, billing, and corporate financial metrics.

SELECTION CRITERIA

Education and Experience

•    Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience). 

•    3-5 years of experience in data engineering and business intelligence.

•    Strong proficiency with Microsoft Fabric components (or similar/predecessor tools): 

o    Power BI (report development, DAX, data modeling, Power Query);

o    Data Factory or similar ETL tools;

o    SQL Server and T-SQL; and

o    Spark notebooks.

•    Experience with data warehouse and data Lakehouse design and construction.

•    Experience with data modeling and dimensional design.

•    Experience building robust ETL processes and data pipelines.

•    Experience with Python or similar programming languages is an asset.

•    Understanding of AI/ML concepts and data requirements is an asset.

•    Knowledge of data governance frameworks is an asset.

•    Experience working in an Agile environment is an asset.

•    Industry certifications (e.g., Microsoft Data Engineer, Power BI) an asset.

Knowledge, Skills, and Abilities

•    Understanding of data governance and quality principles.

•    Knowledge of best practices for data pipeline development.

•    Strong understanding of data visualization best practices, including:

o     Chart and visualization selection principles;

o     Dashboard design and layout optimization; and

o     Interactive visualization techniques.

•    Familiarity with version control systems (e.g., Git).

•    Demonstrated problem-solving and analytical skills.

•    Excellent communication skills with ability to explain technical concepts to non-technical audiences.

•    Strong collaboration and teamwork abilities.

•    Self-motivated with a desire to learn and grow professionally.

•    Effectively communicate technical concepts to diverse stakeholder group.

•    Build and maintain productive relationships with clients and team members.

•    Demonstrate professionalism and technical credibility in client interactions. 

•    Display a high level of effort and commitment to meeting deadlines.

•    Show mature judgement, tact and sound decision making.

•    Work in a professional and confidential manner.

•    Operate effectively and demonstrate trustworthiness and responsible behaviour.

•    Demonstrate eagerness to learn and assume responsibility and display a "can do" approach to work.

•    Show persistence and seek alternatives and solutions when obstacles arise.

•    Work in a resourceful manner to accomplish reasonable and expected work goals.

•    Accept direction and feedback from team members or manager and follow through appropriately.

Preferred Qualifications:

•    Experience with cloud-based data platforms (e.g., Azure Cloud Services, Azure Synapse Analytics).

•    Familiarity with cloud data architecture patterns and best practices.

•    Understanding of cloud-based security and governance principles.

REQUIRED COMPETENCIES

•    Customer Focus

•    Integrity and Trust

•    Ethics and Values

•    Motivating Others

•    Drive for Results    

•    Building Effective Teams

•    Priority Setting

•    Decision Quality

•    Business Acumen

•    Organizing

Why Choose Us? 

Where will a career with Advanced Solutions take you? To the leading edge of information technology, working with industry partners from around the world. At Advanced Solutions you will work with outstanding people in a challenging and dynamic environment. We strive to provide you with the tools, the training, and the opportunity to take charge of your future and take advantage of change to maximize client service and work within a centre of excellence.

The Opportunity: 

Advanced Solutions is looking for community-minded, energetic, progressive individual to join its Application Services department. Advanced Solutions’ Application Services department is responsible for planning, developing, and maintaining the business systems for our various BC public sector clients. Many systems are considered mission critical government applications; used by over 1M users in multiple locations around the province and the general public accessing government information.

Who you are: 

•    Display a high level of effort, commitment, and mature judgment 

•    Maintain a professional and confidential manner at all times 

•    Trustworthy and responsible behavior 

•    Eagerness to learn and a willingness to accept feedback and direction 

•    Customer Focus

•    Adhere to Advanced Solutions Core Values 

o    Exemplify Professionalism: We uphold a respectful and respected workforce.

o    Embrace and Champion Change: We enthusiastically participate, collaborate, innovate, and welcome change.

o    Encourage and Take Initiative: We are an engaged and progressive workforce promoting personal and professional growth

o    Personify Integrity: We are reputable and productive which builds the foundation of our success

Application Requirements 

Must Have 

•    Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience). 

•    3-5 years of experience in data engineering and business intelligence.

•    Strong proficiency with Microsoft Fabric components (or similar/predecessor tools): 

o    Power BI (report development, DAX, data modeling, Power Query);

o    Data Factory or similar ETL tools;

o    SQL Server and T-SQL; and

o    Spark notebooks.

•    Experience with data warehouse and data Lakehouse design and construction.

•    Experience with data modeling and dimensional design.

•    Experience building robust ETL processes and data pipelines.

Learn more about application requirements and review the full job description here.

We take care of our people (what we offer): 

Salary Package 

•    Employment Type: Full time, regular 

•    Union/Non-Union: Union-BCGEU 

•    Salary Grid Level: Level 27, Schedule 2

•    Annual Salary: $91,855.54 - $104,908.92 (Based on a 35 hour work week) 

•    Annual Salary: $104,977.76 - $119,895.91 (Based on a 40 hour work week) 

•    Office Location: Victoria, BC - Hybrid

Benefit Package 

•    15 Vacation days, with entitlement increases with service

•    Flexible work arrangements 

•    Modified work weeks are a part of our collective agreement

•    Maternity, Parental and Pre-Adoption Leave with option for top up 

•    Employee Assisted Program including paid counselling services for you and your family 

•    Paid sick leave for when life happens 

•    Extended health and dental 

•    Public Service Pension plan, matched by Advanced Solutions 

•    Excellent Rewards and Recognition Program

Flexible Work Arrangements

•    Schedules to fit your lifestyle 

•    Flexibility in location 

•    Hybrid work environments to ensure that you feel supported

Diversity, Inclusion & Workplace Information 

We promote a diverse, equitable work environment and welcome employment applications from individuals of all backgrounds. Our employees enjoy competitive and comprehensive extended and group benefits and participate in a very progressive defined benefit plan through the BC Public Service Pension Plan. 

We care about our people and are leaning into a workplace culture that supports a healthy work-life balance. Advanced Solutions is proud to be pivoting to become a remote and/or hybrid workplace. Employee’s will have the option to work from anywhere within Canada, or from our Vancouver Island Technology Park Office in beautiful Victoria, BC, or a combination that suits their needs. To learn more about the Victoria Office, please visit the VITP Information Site.

How to Apply: 

Positions are open to all applicants eligible to work in Canada. Please ensure your application clearly identifies how you meet each of the stated qualifications, with particular emphasis on the education, training, and experience requirements. This information will be utilized in screening your application and determining whether you will be considered for the next stage of the recruitment process.

In your application/cover letter please indicate how you heard about ESIT Advanced Solutions (i.e., name of job boards, career fairs, word of mouth). Qualified candidates are invited to forward their cover letter and resume, noting the position title and where they saw the position advertised, to Competition@dxcas.com. This competition will remain open until filled.

An eligibility list may be created. Lesser qualified applicants may be under-implemented or appointed at a lower level.