Lead Data Engineering

Mphasis

$100K — $130K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of experience in Data Modeling and Data Analysis
  • Expertise in ER and Dimensional Modeling techniques
  • Experience creating conceptual, logical, and physical data models
  • Proficiency in data modeling tools, particularly Erwin
  • Strong command of advanced SQL and various database architectures such as Netezza, SQL Server, and DB2 UDB

Responsibilities

  • Gather requirements from subject matter experts (SMEs)
  • Translate business needs into scalable data models
  • Develop and implement data strategies and models
  • Enforce best practices in data modeling standards
  • Create comprehensive mapping documents for data transformation
  • Utilize data modeling software for effective model management

Benefits

  • Adherence to data security protocols
  • Engagement with various stakeholders
  • Opportunity for long-term project involvement
  • Focus on data accuracy and consistency
Full Job Description
Role description

Job Description

Job Summary -

A Senior Data Modeler designs and implements data models, ensuring data accuracy, consistency, and efficient storage and retrieval. They work with various stakeholders to understand business needs and translate them into technical data structures. Senior Data Modelers also focus on maintaining data models, optimizing data flows, and adhering to data standards and security protocols.

Key Responsibilities:
  • Work with SME to gather requirements.
  • Analyze, understand, and translate business needs into long-term solution data models.
  • Implementing data strategies and developing logical and physical data models.
  • Enforce data modeling standards and best practices.
  • Create detailed mapping documents covering source to target mapping, transformation logic and communicate data models and their specifications.
  • Use data modeling tools and software's for model creation and management.

Years of experience needed -

Minimum of 8+ years of experience in Data Modelling and Data Analysis.

Technical Skills:
    • Hands on experience in various data models techniques such as ER Modeling and Dimensional Modeling.
    • At-least few projects worked as data modeler and specially designed conceptual/logical/physical data models.
    • Hands on experience in translating business requirements into well-defined data models in data modeling tools.
    • Hand on experience in various data modeling tools , especially in Erwin.
    • Expertise and hands on experience in various databases and architecture computer systems, including advance SQL .Especially Netezza, SQL SERVER,DB2 UDB.

Location: Canada

Similar Jobs

More Jobs at Mphasis

  • Contractor-05
    $90K — $120K *
    Columbus, OH 43230 (Franklin County)
    Information Technology
    In-Person
  • Lead Data Engineering
    $100K — $130K *
    Toronto, ON M3C 0E3
    Information Technology
    In-Person
  • Delivery Project Lead- Ingenium
    $90K — $120K *
    Toronto, ON M3C 0E3
    Finance & Insurance
    In-Person
  • Delivery Project Lead
    $120K — $150K *
    San Francisco, CA 94112 (San Francisco County)
    Information Technology
    In-Person
  • MLOps Engineer
    $120K — $150K *
    New York, NY 10025 (New York County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Lead Data Engineering jobs: