Mastech Digital
Overview
Title:
Principal Data Modeler
Location:
Westlake, Texas
Employment type:
Full-time
Qualifications
MUST HAVE:
Dimensional Modeling experience is the MOST important! Data Modeling, Analysis, some DE, SAP Power Designer, OLTP, SQL.
Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level
Dimensional Modeling with experience in crafting conformed dimensions that can be used across Business Units.
Data Modeling Tool such as Power Designer, Oracle Designer or Erwin
Experience working with Data Engineering and Data Analytics teams
Understanding of principles and standard methodologies around Data Architecture
Ability to write SQL to query data (ideally ANSI SQL)
Solid grasp of Database technologies, techniques, and trends
Experience with Snowflake is a plus
Experience with data governance and metadata management tools and standard methodologies is a plus
Excellent written and oral communication skills
Ability to explain Data structures to a non-technical audience
Results oriented with proven ability to work independently
Good interpersonal, negotiating, and influencing skills
Responsibilities / What You Will Do
Collaborate with Data Engineering and Data Analytics teams to design and implement data models that meet business requirements.
Develop conceptual, logical, and physical data models including dimensional models and conformed dimensions across Business Units.
Utilize data modeling tools (Power Designer, Oracle Designer, or Erwin) to create and maintain data models.
Contribute to data governance and metadata management practices.
Write and optimize SQL queries to support analytics and reporting needs.
Job Function
Information Technology
Quality Assurance
Finance
Industries
Financial Services
Software Development
Referrals increase your chances of interviewing at Mastech Digital by 2x
#J-18808-Ljbffr
Principal Data Modeler
Location:
Westlake, Texas
Employment type:
Full-time
Qualifications
MUST HAVE:
Dimensional Modeling experience is the MOST important! Data Modeling, Analysis, some DE, SAP Power Designer, OLTP, SQL.
Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level
Dimensional Modeling with experience in crafting conformed dimensions that can be used across Business Units.
Data Modeling Tool such as Power Designer, Oracle Designer or Erwin
Experience working with Data Engineering and Data Analytics teams
Understanding of principles and standard methodologies around Data Architecture
Ability to write SQL to query data (ideally ANSI SQL)
Solid grasp of Database technologies, techniques, and trends
Experience with Snowflake is a plus
Experience with data governance and metadata management tools and standard methodologies is a plus
Excellent written and oral communication skills
Ability to explain Data structures to a non-technical audience
Results oriented with proven ability to work independently
Good interpersonal, negotiating, and influencing skills
Responsibilities / What You Will Do
Collaborate with Data Engineering and Data Analytics teams to design and implement data models that meet business requirements.
Develop conceptual, logical, and physical data models including dimensional models and conformed dimensions across Business Units.
Utilize data modeling tools (Power Designer, Oracle Designer, or Erwin) to create and maintain data models.
Contribute to data governance and metadata management practices.
Write and optimize SQL queries to support analytics and reporting needs.
Job Function
Information Technology
Quality Assurance
Finance
Industries
Financial Services
Software Development
Referrals increase your chances of interviewing at Mastech Digital by 2x
#J-18808-Ljbffr