Data Modeler or Senior Data Modeler

University of Dayton • Dayton, OH

3d • Onsite

About The Position

The Data Modeler plays a critical role in the development and implementation of a data management strategy that supports the organization's strategic goals and operational needs. This individual will be responsible for ensuring data integrity, creating physical data models, and optimizing data storage and retrieval processes. In addition to the responsibilities of the Data Modeler position, the Senior Data Modeler role takes on greater responsibilities for shaping data management. This includes working with cross-functional teams to gather business requirements and translate them into efficient and scalable data architectures; designing conceptual and logical data models; and informing, defining, and documenting data governance standards.

Requirements

• High school diploma or equivalent.
• At least two years professional experience in a data management related field.
• At least two years experience writing SQL.
• Relational and dimensional data modeling, database design, and performance tuning skills.
• Demonstrated communication skills and the ability to work collaboratively in a dynamic environment.
• Ability to work well under pressure and meet deadlines.
• At least five years professional experience in a data management related field (for Senior Data Modeler).
• At least five years experience writing SQL (for Senior Data Modeler).
• Understanding of source and target data structures, ETL processes, and products (for Senior Data Modeler).
• Experience with systems analysis functions with emphasis on translating business needs into technical solutions (for Senior Data Modeler).

Nice To Haves

• An understanding of data governance principles and standards, e.g. Educause's HERM.
• Working knowledge of data warehousing design principles.
• Experience working with data in the Higher Education industry.
• Experience working with Ellucian Banner, Salesforce, and/or Canvas data.
• Experience working with a CI/CD environment and tools, particularly Git.
• Ability to work with users at all levels of the organization.

Responsibilities

• Ensuring data integrity
• Creating physical data models
• Optimizing data storage and retrieval processes
• Working with cross-functional teams to gather business requirements and translate them into efficient and scalable data architectures
• Designing conceptual and logical data models
• Informing, defining, and documenting data governance standards

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: High school or GED