Description:
Reporting to the Manager, Digital Analytics, the Senior Data Architect will provide expert data analysis, data design, data modelling and data quality services to the sector. Develops data architecture, data standards and data policies to ensure integrity for the sector data resource, and to provide leadership in managing information as a valuable, sustainable sector asset. In addition, the position provides the full scope of Data Scientist expertise.
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; 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.
- Develops position papers and technical recommendations to identify where Destination BC can benefit from data management technology or methodology improvement.
- 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 stakeholder consultations for defining program policies or priorities, identifying stakeholder 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.
- Experience leading project teams
- 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, 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.
- Preference may be given to those with experience deploying physical data models to a cloud hosted solution.
- 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) and Front-end skills (AJAX, React).
- Preference may be given to those with experience using business intelligence technologies such as Power BI, Power BI Report Server, Power BI Service, Tableau or Tableau Server.
- Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modelling, leadership technique, production methods, and coordination of people and resources.
- Knowledge of relational database systems, Structured Query Language, relational data modeling 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 all of the following programming languages: Python, SQL, R, JS
- 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 lead teams and deal effectively with staff and management at all levels and to work calmly and effectively under pressure.
- Ability to lead or actively participate in meetings with professional staff and management to present and explain complex technical information to those with little systems-related knowledge, and/or deliver executive-level presentations.
- Ability to interpret and implement advanced mathematics, scientific rules, and methods to solve complex problems.
- Ability to identify complex problems and reviewing 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
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.