Data Modeler with Azure and Data Vault 10+year

3 months ago

Toronto, Canada epsilonsolutions Full time

**Responsibilities**:

- **Data Modeling**:

- Design and develop data models using Data Vault methodologies to ensure robust, scalable, and flexible data architectures.
- Create and maintain conceptual, logical, and physical data models to support business requirements.
- Collaborate with stakeholders to understand data requirements and translate them into effective data models.
- Implement best practices for data modeling, including normalization, denormalization, and data integration.
- **Data Vault Implementation**:

- Utilize Data Vault techniques to build enterprise data lake and lake house and integrate disparate data sources.
- Design and implement Hubs, Links, and Satellites to ensure comprehensive data capture and historical tracking.
- Optimize data vault models for performance and scalability.
- **Cloud Azure**:

- Design and deploy data models on Azure Data Services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.
- Ensure data security, compliance, and best practices in Azure environments.
- **Collaboration and Communication**:

- Work closely with data engineers, data scientists, and business analysts to understand data needs and ensure data model alignment.
- Provide technical guidance and support on data modeling best practices and Data Vault principles.
- Document data models, data flows, and integration processes clearly and comprehensively.
- **Data Modelling tools Azure**:

- **D**ata analysis and modeling tools (e.g. Power Designer, ERWin, ER/Studio)

**Requirements**:

- Bachelor’s degree in Computer Science, Information Systems, or a related field (Master’s degree preferred).
- Proven experience in data modeling, with a strong focus on Data Vault techniques.
- Proficiency in Cloud Azure services, including Azure Data Lake, Azure SQL Database, and Azure Synapse Analytics.
- Understand/Knowledge with Databricks and its ecosystem.
- Strong understanding of data warehousing concepts, Data Lake house, ETL processes, and data integration techniques.
- Excellent analytical and problem-solving skills with attention to detail.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
- Relevant certifications in Azure and Databricks are a plus.

**Preferred Qualifications**:

- Experience with additional cloud platforms (e.g., AWS, Google Cloud) is a plus.
- Knowledge of data governance and data quality principles.
- Experience with BI tools such as Power BI, Tableau, or Looker.

Pay: $100,000.00-$125,000.00 per year

**Benefits**:

- Dental care
- Life insurance
- Paid time off

Schedule:

- Monday to Friday

Ability to commute/relocate:

- Toronto, ON: reliably commute or plan to relocate before starting work (required)

**Education**:

- Bachelor's Degree (preferred)

**Language**:

- English (preferred)

  • Erwin Data Modeler

    6 months ago

    Toronto, Canada Compest Solutions Inc Full time

    **Job title: Erwin Data Modeler** **Life Insurance Domain** **Location**:Toronto, ON (Hybrid )** **12.+Years of Experience Profile** Erwin Data Modeler 10+ years exp Erwin data modelling tool Life insurance domain exposure 1. Good communication skills **2.Erwin tool** 3.insurance domain exposure Minimum **10 years in data modelling** (conceptual,...

  • Data Modeler

    4 weeks ago

    Greater Toronto Area, Canada, Ontario Virtual Labs IT Consulting Full time

    Data ModelerHybrid 2 or 3 days on siteLocation: GTA • What are the “must-have” skills for this role? 1. 2. 3. Data Vault Modeling,Data Modeling Techquies & Tools, Enterprise Data Foundations, • Years of experience required for each skill? 6+ • What type of education is needed for this position? University Level As a Data Modeler, you will be...

  • Data Modeler

    6 months ago

    Toronto, Canada spruceinfotech Full time

    **Company Description** Spruce InfoTech is a leading information technology firm that provides varied services to help clients change manage and transform their businesses by means of high quality, innovative and cost effective solutions. We provide services to different companies from small scale level to even fortune 500 organizations and guide them in the...

  • Azure Data Engineer

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Procom Full time

    The role: In collaboration with the Business Intelligence (BI) Manager, the Data Engineer will undertake the responsibility of executing and managing Azure Data Factory Pipelines. This includes the design and implementation of the Data Lake, as well as the optimization of data refresh performance.The role encompasses ownership (both execution and management)...

  • IT Data Specialist

    6 months ago

    Toronto, Canada TD Bank Full time

    **TD Description** Stay current and competitive. Carve out a career for yourself. Grow with us. **Department Overview** **Building a World-Class Technology Team at TD** We can't afford to be boring. Neither can you. The scale and scope of what TD does may surprise you. The rapid pace of change makes it a business imperative for us to be smart and...

  • Data Vault with Data Modeler 9+year Experience

    6 months ago

    Toronto, Canada epsilonsolutions Full time

    **Title - DATA Modeler** **Job Type - Long Term Contract** **Job Location - Toronto, ON** **JD**: **Data Modeler with SQL and DATA Volte.** **Job Type**: Fixed term contract **Salary**: Up to $60.00 per hour Expected hours: 40 per week **Benefits**: - Dental care - Life insurance - Paid time off Schedule: - Monday to Friday **Education**: -...

  • Senior ETL

    2 hours ago

    Toronto, Canada S.i. Systems Full time

    Contract Length: TBD Must Haves: 1. University degree in applied sciences such as Computer Sciences, Systems Design, Engineering, Business or a combination of education, training, and experience deemed equivalent 2. 3-5 years of experience in cloud architecture and design principals of web services within the Azure Cloud and on Oracle physical/hosted...

  • Data Modeler

    3 days ago

    Toronto, Canada Botsford Associates Full time

    Data Modeler Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing)...

  • Data Modeler

    3 days ago

    Toronto, Canada Botsford Associates Full time

    Data Modeler Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing)...

  • Data Modeler

    2 days ago

    Toronto, Canada Botsford Associates Full time

    Data Modeler Overview: Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing)...

  • BSA / Azure Data Analyst - Azure Data Lake, Data Factory, DataBricks

    3 weeks ago

    Toronto, Canada Astra North Infoteck Inc. Full time

    Job DescriptionAzure Data Analyst  - Azure Data Lake, Data Factory, DataBricks Experience (Years):6-86-8 years of BSA experience in data analytics/data warehouse/data integration through agile environment.Strong communication, interpersonal, collaboration, and negotiation skills to work seamlessly in an agile cross-functional team, with clients, vendor(s)...

  • Associate Data Scientist

    2 weeks ago

    Old Toronto, Canada Data Privacy Full time

    p>TD, one of the world's leading global financial institutions, provides a dynamic environment with the AI2 Data Scientist Associate Program. This 1-year intensive program is designed for new graduates, featuring comprehensive training, mentorship, and real-world project opportunities within TD's various business lines.Perform data queries and prepare data...

  • Azure Data Engineer

    3 weeks ago

    Toronto, Canada VLink Inc Full time

    Role: Azure Data EngineerLocation: Toronto, ON (Hybrid - 3 days onsite)Job type: Long-term Contract/ Full-time opportunity Experience: 5+ years Job Description: We are looking for a highly skilled professional to design, build, and maintain scalable data solutions while ensuring data quality and driving data innovation. Requirements• Over 3 years of...

  • Data Modeler

    3 weeks ago

    Toronto, Canada Botsford Associates Full time

    Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing) systems,...

  • Azure Data Engineer

    3 weeks ago

    Toronto, Ontario, Ontario, Canada VLink Inc Full time

    Role: Azure Data EngineerLocation: Toronto, ON (Hybrid - 3 days onsite)Job type: Long-term Contract/ Full-time opportunity Experience: 5+ years Job Description: We are looking for a highly skilled professional to design, build, and maintain scalable data solutions while ensuring data quality and driving data innovation. Requirements• Over 3 years of...

  • Data Scientist

    6 months ago

    Toronto, Canada NIIT Technologies Full time

    Title - Data Scientist Location - Toronto, Canada Hybrid Role **Responsibilities**: - 3+ years relevant industry experience in deploying database engineering solutions - Bachelors or Masters in Software Engineering, Computer Science, Computer Engineering or relevant statistical discipline - Knowledge of distributed database systems - Work collaboratively...

  • Data Architect Modeler

    3 weeks ago

    Toronto, Ontario, Canada Foilcon Full time

    Data Architect ModelerFoilcon is seeking an experienced Data Architect Modeler to join our team. The ideal candidate will have a strong background in data modeling and warehouse design, with expertise in MS SQL Server Technology, Azure Databricks SQL Warehouse, and Azure Data Lake.Key Responsibilities:Review business requirements and develop conceptual,...

  • Data Architect Modeler

    1 month ago

    Toronto, Ontario, Canada Foilcon Full time

    Job DescriptionFoilcon is seeking a highly skilled Data Architect Modeler to join our team. As a key member of our data team, you will be responsible for designing and implementing data models that meet the needs of our business.Key Responsibilities:Design and implement data models that meet the needs of our businessDevelop and maintain data dictionaries and...

  • Data Modeler

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Botsford Associates Full time

    Overview:Our Clients Alternate Solutions Group, is seeking an experienced Data Modeler to work on dynamic projects transitioning from on-premise to Azure Cloud, with a key focus on supporting the Dynamic Currency Converter (DCC) application. This role involves designing data models optimized for real-time OLTP (Online Transaction Processing) systems,...

  • Azure Data Engineer Position

    3 weeks ago

    Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job Title: Senior Power BI EngineerAt Lyons Consulting Group, we are seeking a highly skilled Senior Power BI Engineer to join our team. The ideal candidate will have extensive experience in building complex data models, optimizing Power BI reports, and working with business teams to design cloud solutions.Key Responsibilities:Design and develop...