Data Modeler

Posting Details

Posting Details

Position Number: 122399
Title: IT Senior Engineer
Functional Title: Data Modeler
Category Status: 33-Exempt Regular
Applicant Search Category: Staff
University Authorized FTE: 1
Unit: DIT-EE-University Decision Support
Campus/College Information:

Founded in 1856, University of Maryland, College Park is the flagship institution in the University System of Maryland. Our 1,250-acre College Park campus is just minutes away from Washington, D.C., and the nexus of the nation’s legislative, executive, and judicial centers of power. This unique proximity to business and technology leaders, federal departments and agencies, and a myriad of research entities, embassies, think tanks, cultural centers, and non-profit organizations is simply unparalleled. Synergistic opportunities for our faculty and students abound and are virtually limitless in the nation’s capital and surrounding areas. The University is committed to attracting and retaining outstanding and diverse faculty and staff that will enhance our stature of preeminence in our three missions of teaching, scholarship, and full engagement in our community, the state of Maryland, and in the world.

Position Summary/Purpose of Position:

The Data Modeler will report directly to Data Architect, University Decision Support (UDS) within the Division of Information Technology (DIT). This is an opportunity to join a newly formed unit (UDS) and contribute to a strategic initiative to improve data-driven decision-making on campus. The Data Modeler will be responsible for requirements gathering and data modeling (conceptual, logical and physical) to support the creation of a new Enterprise Data Warehouse (EDW) and data platform. This includes conducting user interviews, facilitating data modeling sessions, writing business and technical requirements, maintaining data models in ERWin, creating DDL and DML scripts as needed and documentation. The Data Modeler will collaborate with the DSS team on a day-to-day basis and receive technical guidance from the Data Warehouse Architect.

The position requires a thorough knowledge of dimensional data modeling, process modeling, data warehousing and data management principles, processes and best practices. The position also requires a solid understanding of Master Data Management principles. Prior successful data warehouse implementations are a must. Clear communication, demonstrated organizational skills, the ability to collaborate with non-technical stakeholders, create clear and concise technical documentation, and make critical decisions are requirements to be successful in this position.

Minimum Qualifications:

Bachelor’s degree from an accredited college or university in computer science, information systems or a related IT discipline

3-5 years of experience in a role primarily responsible for developing and implementing dimensional data models

At least 3 years of hands-on SQL development experience

Experience using a data modeling tool similar to ERWin or ER Studio

Extensive experience conducting user interviews and guiding customers in developing decision driven business requirements

Experience facilitating data modeling sessions and design walkthroughs with development team members and business users.

Experience using data modeling techniques to analyze business requirements, translate them to data requirements and develop logical and physical data models using a data modeling tool

Strong understanding of Master Data Management

Experience building dimensional models and a strong understanding of dimensional modeling best practices

Experience developing and maintaining large scale, enterprise data warehouse data models

Experience developing source to target mappings and technical documentation

Ability to communicate clearly, in written or spoken word, with customers and team members.

Experience working with at least 2 common database platforms ( i.e Oracle, SQL Server, Teradata, etc)


Experience performing data profiling activities

Experience working with data virtualization tools

Experience with Amazon Redshift or other cloud-based data warehouse technologies

Self-motivated, energetic, detail oriented and a team player

Experience modeling higher education data is a plus.

Additional Certifications:
Additional Information:
Posting Date: 02/27/2018
Closing Date:
Open Until Filled Yes
Best Consideration Date 03/13/2018
Physical Demands


Diversity Statement:

The University of Maryland, College Park, an equal opportunity/affirmative action employer, complies with all applicable federal and state laws and regulations regarding nondiscrimination and affirmative action; all qualified applicants will receive consideration for employment. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, religion, sex, national origin, physical or mental disability, protected veteran status, age, gender identity or expression, sexual orientation, creed, marital status, political affiliation, personal appearance, or on the basis of rights secured by the First Amendment, in all aspects of employment, educational programs and activities, and admissions.

Applicant Documents

Required Documents
  1. Resume
  2. Cover Letter
  3. List of References (no emails sent from system)
Optional Documents

Posting Specific Questions

Required fields are indicated with an asterisk (*).

  1. * How many years of SQL experience?

    (Open Ended Question)

  2. * How did you hear about this position?
    • UMD Job Site
    • Personal Referral
    • Washington Post
    • Baltimore Sun
    • Local Publication
    • Chronicle of Higher Education
    • Inside Higher Education
    • INDEED
    • HERC
    • Hispanic Outlook
    • Diverse Jobs
    • HigherEdJobs
    • Professional Journal
    • Listserv
    • Other
    • SimplyHired
    • CareerBliss
    • Job Fairs
    • Monster.Com
    • Craigs List
  3. * How many years of experience do you have building and implementing dimensional models?

    (Open Ended Question)