Talent.com

Sql dba Offres d'emploi - Victoria, BC

Créer une alerte emploi pour cette recherche

Sql dba • victoria bc

Dernière mise à jour : il y a 1 jour

Senior Data Modeler to support our client's enterprise data and analytics initiatives.

S.i. SystemsVictoria, CA
IndépendantIndépendant

The successful candidate will be responsible for designing, developing, and optimizing scalable data models to support business intelligence, reporting, analytics, and operational data requirements... Voir plus

Intermediate Oracle PL/ SQL Consultant

S.i. SystemsVictoria, CA
IndépendantIndépendant

Our client is hiring an Intermediate Oracle PL/ SQL Consultant.Remote, must work PST time zone.This position requires the candidate eligible for.Have to be in Canada for the last 5 years).Software ... Voir plus

Oracle Cloud Application Developer (10+ years) to enhance and integrate Oracle Fusion Cloud ERP

S.i. SystemsVictoria, CA
IndépendantIndépendant

Our consumer business client is seeking a.Oracle Cloud Application Developer (10+ years) to enhance and integrate Oracle Fusion Cloud ERP applications using Oracle Integration Cloud, SQL, and PL/SQ... Voir plus

Platform Engineer

BCIVictoria, BC

BCI is working with an external recruitment firm.Please do not submit your application directly to BCI.Applications submitted through this site will not be reviewed.To explore this opportunity, ple... Voir plus

Associé aux ventes principal/associée aux ventes principale – commerce de détail

PSB IMPEX LTD dba SIDNEY CHEVRONVictoria, BC, Canada
PermanentPermanent

Heures de travail: 30 à 40 heures par semaine.Education: Diplôme d'études secondaires ou l'équivalent.Expérience: 1 an à moins de 2 ans.Assigner les tâches au personnel de vente.Autoriser les paiem... Voir plus

Customer Engineer, Data & Analytics #120

Premier CloudVictoria, British Columbia, Canada, V8T 5C3
110 000,00 $CA – 150 000,00 $CA par an110 000,00 $CA – 150 000,00 $CA par an
Quick Apply

Premier Cloud is a Google Cloud Premier Partner dedicated to helping organizations modernize, collaborate, and scale through the power of cloud technology.Founded in 2001, we deliver cloud consulti... Voir plus

Senior Database Administrator

WorldlineVictoria, British Columbia, Canada
124 000,00 $CA – 140 000,00 $CA par an124 000,00 $CA – 140 000,00 $CA par an
PermanentPermanent

Total Earnings Pay Range: $124,000 - $140,000.We are the innovators at the heart of the payments technology industry, shaping how the world pays and gets paid.The solutions our people build today p... Voir plus

Maintenance Technician - Afternoon/Evening Shift

Schneider ElectricVictoria, CA
29,00 $CA –35,00 $CA par heure29,00 $CA –35,00 $CA par heure
Temps pleinTemps plein

Duties and Responsibilities A Maintenance Technician at Schneider Electric provides hands-on support to ensure the continuous operation, reliability, and performance of manufacturing test eq... Voir plus

Window, Gutter Cleaning & Pressure Washing Technician

Rajmen Enterprises dba Victoria Window CleaningVictoria, British Columbia, Canada
21,00 $CA –32,00 $CA par heure21,00 $CA –32,00 $CA par heure
Temps pleinTemps plein
Quick Apply

F/T year-round with extended benefit for Window, Gutter Cleaning & Pressure Washing.Safety equipment & cleaning supplies provided.Use of company vehicle (during work hours with valid Class 5 driver... Voir plus

Senior Data Modeler to support our client's enterprise data and analytics initiatives.

Senior Data Modeler to support our client's enterprise data and analytics initiatives.

S.i. SystemsVictoria, CA
Il y a 5 jours
Type de contrat
  • Indépendant
Description de poste

Position Overview

We are seeking a Senior Data Modeler to support our clients enterprise data and analytics initiatives. The successful candidate will be responsible for designing, developing, and optimizing scalable data models to support business intelligence, reporting, analytics, and operational data requirements.

This role requires strong expertise in dimensional modeling, Data Vault 1.0/2.0, medallion architecture, and Snowflake. The ideal candidate will work closely with data architects, data engineers, and business stakeholders to develop high-quality data models that support modern cloud-based data platforms.

Duration - 1 year

Work Mode - Remote

Start - ASAP

Key Responsibilities

  • Design and develop conceptual, logical, and physical data models to support enterprise analytics, reporting, and operational requirements.
  • Apply advanced data modeling methodologies, including dimensional modeling, Data Vault 1.0 and 2.0, and medallion architecture (bronze, silver, and gold layers).
  • Develop star schemas, snowflake schemas, fact tables, and dimension tables to support analytical workloads.
  • Design Data Vault structures, including hubs, links, and satellites, following Data Vault 2.0 best practices.
  • Collaborate with data architects, data engineers, business analysts, and stakeholders to gather requirements and translate business needs into scalable data models.
  • Create and maintain comprehensive data modeling documentation, including entity-relationship diagrams (ERDs), data dictionaries, metadata definitions, and source-to-target mapping specifications.
  • Design and optimize data models within Snowflake, considering query performance, scalability, maintainability, and cost efficiency.
  • Partner with data engineering teams to ensure accurate implementation of data models across cloud-based data pipelines.
  • Review, validate, and enhance existing data models to align with evolving business and technical requirements.
  • Support data quality, governance, and consistency across enterprise data environments.

Required Skills and Experience

  • Extensive hands-on experience in enterprise data modeling, including conceptual, logical, and physical data model design.
  • Strong expertise in dimensional modeling, including star schemas, snowflake schemas, fact tables, and dimension design.
  • Proven experience designing and implementing Data Vault 1.0 and 2.0 models, including hubs, links, satellites, and associated modeling principles.
  • Solid understanding of medallion architecture, including bronze, silver, and gold data layers within modern cloud data platforms.
  • Strong hands-on experience with Snowflake, including:
  • Micro-partitioning and data organization.
  • Clustering keys and query optimization.
  • VARIANT data types and semi-structured data modeling.
  • Performance optimization and scalable data design.
  • Advanced SQL skills, including working with complex queries and structured and semi-structured datasets.
  • Experience translating complex business requirements into efficient, scalable, and maintainable data models.
  • Strong understanding of data warehouse architecture, data integration, and modern data engineering practices.
  • Excellent analytical, problem-solving, communication, and stakeholder collaboration skills.

Nice to Have

  • Experience with data modeling and documentation tools such as ERwin, dbt, or Lucidchart.
  • Understanding of data governance, metadata management, master data management (MDM), and data quality principles.
  • Experience working with cloud-based data platforms, particularly Snowflake on Microsoft Azure.
  • Knowledge of Snowflake performance tuning, workload optimization, and cost management.
  • Previous experience supporting enterprise-scale data transformation, modernization, or analytics initiatives.
  • Experience working in the airline, transportation, or other large enterprise environments is an asset.

Ideal Candidate Profile

The ideal candidate is a hands-on Data Modeler with strong technical expertise in Snowflake, dimensional modeling, and Data Vault 2.0. They should be comfortable working in complex enterprise data environments, collaborating with cross-functional teams, and designing scalable data structures that support both current and future business requirements.