ISL 27R - Data Integration Specialist

Position: Data Integration Specialist
Classification: IS 27
Salary: $83,071.72 to $94,752.42
Status: Full time, Permanent
Location: Vancouver, Coast and Mountains region (Hybrid)
Comox Valley, BC (Remote)
Cranbrook, BC (Remote)
Kamloops, BC (Remote)
Kelowna, BC (Remote)
Nanaimo, BC (Remote)
Penticton, BC (Remote)
Prince George, BC (Remote)
Terrace, BC (Remote)
Victoria, BC (Remote)
Work Option: Hybrid or Remote
Flexible work options are available, subject to an approved telework agreement; Hybrid work is available for employees residing within the Vancouver, Coast and Mountains (VCM) region and enables employees to telework from their home up to 3 days a week with in office days on Wednesdays and Thursdays. Remote work is available for employees residing outside of the VCM region in one of the approved remote locations in BC listed above. Employees working remotely will have the opportunity to visit the Destination BC office once a quarter.
Closing Date: December 5, 2025 at 4:00pm
Position #: 00141826
Competition #: DBC 2025-28

If you are interested and you meet the selection criteria, please respond to this link with your CV prior to December 5, 2025 at 4:00pm.

You must be a Canadian citizen or permanent resident to apply for this full-time, permanent opportunity.

The initial salary for this position will start at the beginning of the listed salary range with the opportunity to advance up the pay grid in annual increments. An eligibility list may be established.

At Destination BC, we are passionate about showcasing the transformative power of British Columbia’s travel experiences with the world. As a Provincially funded Crown corporation, we support BC’s tourism industry through global marketing, destination development, industry learning, community programs, and visitor services. Recognized globally for our authentic brand, award-winning marketing, and innovative destination management, we work collaboratively to strengthen BC’s tourism industry.

We offer exciting and meaningful work in a supportive, inclusive environment that values learning and professional growth. This position is eligible for hybrid and remote work under our flexible work policy, creating optimal conditions for both employees and the organization. For employees residing within the Vancouver, Coast, and Mountains (VCM) region, hybrid work is applicable. Hybrid employees work in the office on Wednesdays and Thursdays with the flexibility to work from home on other days. For those living outside the VCM region in one of our approved remote locations across BC, remote work is applicable, with opportunities to visit Destination BC’s Vancouver office once per quarter.

Destination BC is committed to diversity, equity, and inclusion and welcomes applications from all qualified candidates. If you require accommodations during the hiring process, please contact dbccareers@destinationbc.ca. We are also committed to providing workplace accommodations for employees with disabilities, ensuring you have the support needed to perform your best work both during the hiring process and throughout your employment with us.

The Indigenous Applicant Advisory Service is available to Canadian Indigenous (First Nations [status or non-status], Métis, or Inuit) applicants. Indigenous applicants originating from the land now known as Canada, seeking work or already employed in the BC Public Service. Indigenous applicants can contact this service for personalized guidance on the BC Public Service hiring process including job applications and interviews.

Learn more about our programs and services at www.DestinationBC.ca.

PURPOSE OF POSITION

Reporting to the Manager of Digital Analytics, the Data Scientist plays a critical role in driving the organization's data strategy and ensuring the integrity of sector data resources. The primary purpose of this position is to provide expert data analysis, data design, data modeling, and data quality services. The Data Scientist will develop data architecture, standards, and policies, ensuring data integrity and promoting the management of information as a valuable, sustainable sector asset.

In this technical role, the Data Scientist will lead medium to large-scale projects, creating end to end support from data ingestion to professional analyses on tourism economic indicators and marketing web analytics. By implementing components of Destination BC’s Data & Analytics Strategy, the Data Scientist will leverage a strong and strategic understanding of technology and performance data. Through these efforts, the Data Scientist supports cross-functional teams in making data-driven decisions, ultimately contributing to the organization's growth and competitive advantage.

SPECIFIC ACCOUNTABILITIES

• Plans, designs, the development and implementation of data, software, concepts, specifications, and business requirements impacting multiple databases.
• Researches, develops, and maintains Destination BC’s data model and data architectures with third party vendors.
• Leads and delivers logical data modelling and business modelling strategies, standards, policies, tools, and procedures.
• Provides expert conceptual, logical and warehouse data model validation and consulting services to the Destination BC for all systems development projects.
• Provides consulting expertise to Destination BC’s management and staff on Destination BC’s and government use of data structures and data management principles to improve the use of information as a vital business resource, including data governance and data management best practices.
• Engineers the Data Architecture function to meet evolving business needs and technology changes and automation; plans, develops, implements, and enhances Destination BC’s data administration, data modelling, spatial data, and data warehouse standards, and metadata repository. This includes the acquisition of Raw Data, transfer from and to different storages, and data cleansing (ETL Process).
• Provides leadership on major cross organization and broader tourism industry data administration projects.
• Evaluates business processes using data modelling and makes recommendations for change.
• Promotes management of shared data resources by internal and external application users.
• Collaborates in the evaluation, selection, development, modification, implementation, documentation and maintenance of data administration tools and applications.
• Prepares and/or negotiates contracts, monitors performance, and authorizes payment.
• Oversees Destination BC’s approach to modelling complex business problems, conducting large scale experimentation, discovering business insights, and identifying opportunities through the use of statistical, algorithmic, mining and visualization techniques, including automated, reproducible and scalable data workflows. Example projects include Market Mix Modelling and SearchLift Analysis.
• Leads in business partner consultations for defining program policies or priorities, identifying business partner preferences and reconciling conflicts.
• Manages data science projects, including defining scope, objectives, data requirements and methodologies and works with business partners to achieve project objectives, including influencing strategic and operational decisions.
• Leads the development and promotion working relationships with internal and external partners, and government agencies to achieve program or project objectives.
• Oversees data science ethics frameworks and best practices based on standards from across government, industry, and academia.
• Provides technical supervision to the Marketing Data Analyst and/or Research Analyst, pertaining to scientific approach, evaluation, and assessment processes.
• Other duties as required.

JOB REQUIREMENTS

• Degree in data analytics, computer science and/or related field and 3 years of related experience or an equivalent combination of education and experience.
• Demonstrated ability to understand and convey complex results to technical and non-technical audiences.
• Experience in information resource management, corporate data design, relational and/or object data modelling, process modelling, data analysis, data warehousing and/or business area analysis techniques, data management principles, structured analysis and design, and documentation of business requirements.
• Minimum 3 years’ experience with at least one of these tools: Alteryx, Snowflake, Databricks, SAS-EG, Knime, AWS, Matillion, and / or AZURE.
• Experience with Agile development methodologies, including delivering incremental logical and/or physical data model releases.
• Experience with Report design and development using BI tools, including query optimization and database view development; developing reports and data visualizations via such tools as Microsoft Power BI, Tableau, or DOMO.
• Experience at leveraging structured and unstructured data sources to conduct quantitative analysis.
• Experience determining appropriate use of various problem structuring methods and statistical methods for sampling, distribution assessment, bias, and error.
• Experience working with third party vendors and ensuring technical objectives are met.
• Knowledge of relational database systems, Structured Query Language, relational data modelling and data management principles, ETL Processes, structured analysis and design, and documentation of business requirements.
• Knowledge of computer hardware and software, including applications and programming. 3 years or more Industry level experience required for at least two of the following programming languages: Python, SQL, R, JS, and must include SQL.
• Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
• Ability to interpret and implement advanced mathematics, scientific rules, and methods to solve complex problems.
• Ability to identify complex problems and review related information to develop and evaluate options and implement solutions.
• Ability to identify measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
• Ability to travel within British Columbia, as required
• Preference may be given to those with experience deploying physical data models to a cloud hosted solution.
• Preference may be given to those with experience working the geo-spatial data with Spatial Libraries and API
• Preference may be given to candidates with hands-on experience in developing python scripts for REST API connections with understanding of Back-end technologies (MySQL)

COMPETENCIES

• Analytical Thinking is the ability to comprehend a situation by breaking it down into its components and identifying key or underlying complex issues. It implies the ability to systematically organize and compare the various aspects of a problem or situation and determine cause-and-effect relationships ("if...then…") to resolve problems in a sound, decisive manner. Checks to ensure the validity or accuracy of all information.
• Business Acumen is the ability to understand the business implications of decisions and the ability to strive to improve organizational performance. It requires an awareness of business issues, processes and outcomes as they impact the client's and the organization's business needs.
• Commitment to Continuous Learning involves a commitment to think about the ongoing and evolving needs of the organization and to learn how new and different solutions can be utilized to ensure success and move the organization forward.
• Conceptual Thinking is the ability to identify patterns or connections between situations that are not obviously related, and to identify key or underlying issues in complex situations. It includes using creative, conceptual or inductive reasoning or thought processes that are not necessarily categorized by linear thinking.
• Planning, Organizing and Coordinating involves proactively planning, establishing priorities and allocating resources. It is expressed by developing and implementing increasingly complex plans. It also involves monitoring and adjusting work to accomplish goals and deliver to the organization's mandate.
• Integrity refers to actions that are consistent with what one says are important. People with integrity "walk the talk" by communicating intentions, ideas and feelings openly and directly, welcoming openness and honesty even in difficult negotiations, and acting on values when it is not easy to do so.

Indigenous relations behavioural competencies

• Self-discovery and Awareness means understanding one's thoughts, feelings, values, and background and how they impact the success of the interaction and relationship, or how they may influence one's work. It is recognizing one's own biases by tracing them to their origins, through reflection and by noticing one's own behaviour—and then intentionally seeking a way forward that positively impacts the interaction and relationship. It means maintaining new ways of thinking and acting when situations become difficult or uncertain, or in times of urgency.

HOW TO APPLY & APPLICATION REQUIREMENTS:

To be considered for this position, your application must clearly demonstrate how you meet the education and experience as outlined in the job requirements section above. Applicants selected to move forward in the hiring process may be assessed on the knowledge, skills, abilities and competencies as outlined in the above Job Description. A Criminal Record Check (CRC) will be required.

A resume is required as part of your application. Ensure your resume includes your educational accomplishments, employment history including start and end dates (month and year) of your employment, and any relevant information that relates to the job to which you are applying.

As part of the application process, you will be prompted to complete an online questionnaire to demonstrate how you meet the job requirements. Responses to this questionnaire will be used to shortlist applicants against the job requirements.

Please allot approximately 30 minutes to complete the application.

Only applications submitted using the online application portal will be accepted.