Job Description
Position Title:
Data Management and BI Specialist
Classification:
IS27
Department:
Application Management Services
Job Code:
90000665
Work Unit:
Data Engineering and Analytics Team
Job Title:
Information Systems Officer N27 -w40
Manager Title:
Director, Application Services (non-HIBC)
Last Updated:
May 15, 2026
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.
SUPERVISORY RESPONSIBILITIES
Number of Reports
Direct (directly supervises assigned staff)
0
Indirect reports (supervises through subordinate supervisors)
0
PROJECT/TEAM LEAD OR TRAINING RESPONSIBILITY
Role
Y/N
Supervises students or volunteers
Y
Provides formal training to other staff
Y
Leads project teams
Y
Assigns, monitors, and examines work of staff
Y
FINANCIAL RESPONSIBILITY
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):
- Power BI (report development, DAX, data modeling, Power Query);
- Data Factory or similar ETL tools;
- SQL Server and T-SQL; and
- 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.
- Experience using agentic coding harnesses to deliver technical or non-technical work products.
- Understanding of AI/ML concepts and data requirements.
- 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:
- Chart and visualization selection principles;
- Dashboard design and layout optimization; and
- Interactive visualization techniques.
- Familiarity with version control systems (e.g., Git).
- Strong understanding of agentic coding and context management techniques
- 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.
PREFERERD 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
-
LEADERSHIP ATTRIBUTES AND BEHAVIOURS
All Advanced Solutions leaders display the following attributes and behaviors:
Always accountable
Will to win
Passion for customers
Highly capable and innovative
People and team developer
SALARY PACKAGE
- Employment Type: Full time, Casual, 11 Month Term
- Union/Non-Union: Union-BCGEU
- Salary Grid Level: Level 27, Schedule 2
- Annual Salary: $111,370.90-$127,197.57 (Based on a 40 hour work week)
- Office Location: Victoria, BC - Hybrid
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, a DXC Technology Company is a wholly owned subsidiary of DXC Technology. We are a unionized service delivery channel that delivers world-class business process and information technology services, collaborating with industry-leading partners to provide the best possible solutions for our customers. We combine our deep pool of experienced staff with cutting edge technology to deliver results. We have met the challenges of innovation many times and have a clear and confident vision for leading clients on their digital transformation journeys.
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
Embrace and Champion Change: We enthusiastically participate, collaborate, innovate, and welcome change.
Encourage and Take Initiative: We are an engaged and progressive workforce promoting personal and professional growth
Personify Integrity: We are reputable and productive which builds the foundation of our success
Flexible Work Arrangements
- Schedules to fit your lifestyle
- Flexibility in Location (Role Specific)
- Hybrid work environments may be available to ensure that you feel supported
Diversity, Inclusion & Workplace Information
At Advanced Solutions, we care about our people and provide a workplace culture that supports a healthy work-life balance. Our workplace model supports both remote and hybrid work, offering employees the options to better align with their lifestyle and productivity. Whether working in Canada or collaborating in person at our Vancouver Island Technology Park office in beautiful Victoria, BC, we’re committed to fostering a culture that values balance, inclusivity, and wellbeing.
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 .
Submitting your Application
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.
