| Job Title: |
University Data Modeler |
| Salary/Grade: |
Salaried
|
| Hours Per Week: |
40
|
| Job Summary: |
We are looking for someone who loves all things data, loves a challenge and is looking for a dynamic and highly rewarding position at a nationally respected university. Is this you?
Our Ideal candidates, like you, will help Miami University to continue to take big steps forward with our data analytics environment that is unifying multiple successful data-driven business intelligence and data analysis efforts across campus. This is a chance to help guide Miami’s data-driven future. The University Data Modeler position is a highly technical position with responsibility to lead the development, validation, publishing, and maintenance of logical and physical data models. You’ll be an integral part of providing data-driven insights that inform significant University wide decisions.
The University Data Modeler will be expected to leverage their knowledge of data modeling best practices, cross industry data expertise and data modeling tool expertise. As a member of our team, reporting to the Director of the Business Intelligence Team, you will have great opportunities to grow technically and professionally in multiple data disciplines.
Miami University recognizes that technology enables us to find new ways of providing first-class service and workplace flexibility. This position is approved to work 100% remotely. We intend to hire someone who resides in Ohio, Indiana or Kentucky. Should a candidate currently reside outside of these states, relocation would be expected by date of hire. Remote work is a working arrangement that can be modified or revoked by Miami University at any time for any reason.
|
| Duties/Physical Demands: |
• Partner with clients to analyze and translate business needs into long-term solution data models.
• Evaluate existing data systems, translations and structures for optimization.
• Work with data modeling tools to design data structures that meet organizational needs using conceptual, logical, and physical data models.
• Partner with solution teams to create conceptual data models and data flows.
• Collaboratively update and optimize local and metadata models to align with university needs.
• Participate in creation, review and refinement of data definitions, assist as needed with maintaining holistic entries in a data dictionary.
• Provide focus on simplifying the data design landscape by looking for opportunities in data conformance, reusability and standardization.
As a member of the Miami team, you will be a part of our efforts to pursue the best solutions for the University and have great opportunities to grow technically and professionally through annual training.
|
| Minimum Qualifications: |
Bachelor's degree earned by date of hire and 2+ years of relevant work experience
OR
Associate's degree earned by date of hire and 4+ years of relevant work experience
OR
6+ years of relevant experience
This position is available to persons who are currently authorized to work in the United States on a full-time and indefinite basis. (Persons authorized to work on such a basis include US citizens, lawful permanent residents (“green card” holders), asylees, refugees, and temporary residents under IRCA.
|
| Desired Qualifications: |
Bachelor's degree in Computer Science, Information Technology, Business Analytics, or a related field earned by date of hire.
• 2 years of data modeling experience
• 1 year of Erwin Data Modeler experience or similar
• 1 year Cloud ERP experience (Workday or Oracle preferred)
We are looking for you to have knowledge and experience in:
• Partnering with clients and stakeholders to analyze and translate business needs into optimized data artifacts (flows, models, translations and data sources).
• Enterprise business intelligence and data analytics technologies, such as Workday Reporting, Workday Prism Analytics, Oracle OAS, MS Power BI, Tableau, and Oracle Data Integrator (ODI).
• Collaborating with solution teams to design data models, data flows, and metadata management
• Object oriented design and object relational mapping
• Unstructured data analysis, such as with data lakes, NoSQL databases, and Apache Hadoop.
• Relational database architectures at enterprise scale. Environments such as SQL Server, MySQL, Oracle, or Redshift.
• Analytical tools available in cloud infrastructure such as AWS, Azure, and GCP.
• Understanding the importance of following FERPA, HIPAA, diversity principles, data integrity, and other compliance program policies and how to apply them to data security practices.
• Understanding of Agile development (including Scrum or Kanban)
• Industry standard data models such as Kimball’s dimensional model
|
| Knowledge, Skills and Abilities |
See Minimum Qualifications.
|
| Special Instructions to Applicants: |
View Miami University’s Prospectus here.
Miami University recognizes that technology enables us to find new ways of providing first-class service and workplace flexibility. This position is approved to work 100% remotely. We intend to hire someone who resides in Ohio, Indiana or Kentucky. Should a candidate currently reside outside of these states, relocation would be expected by date of hire. Remote work is a working arrangement that can be modified or revoked by Miami University at any time for any reason.
|
| Diversity Statement: |
|
| EO/AA Statement/Clery Act: |
Miami University, an Equal Opportunity/Affirmative Action employer, encourages applications from minorities, women, protected veterans and individuals with disabilities. Miami University prohibits harassment, discrimination and retaliation on the basis of age (40 years or older), color, disability, gender identity or expression, genetic information, military status, national origin (ancestry), pregnancy, race, religion, sex/gender, status as a parent or foster parent, sexual orientation, or protected veteran status in its application and admission processes, educational programs and activities, facilities, programs or employment practices. Requests for reasonable accommodations for disabilities related to employment should be directed to ADAFacultyStaff@miamioh.edu or 513-529-3560.
As part of the University’s commitment to maintaining a healthy and safe living, learning, and working environment, we encourage you to read Miami University’s Annual Security & Fire Safety Report at: http://www.MiamiOH.edu/campus-safety/annual-report/index.html, which contains information about campus safety, crime statistics, and our drug and alcohol abuse and prevention program designed to prevent the unlawful possession, use, and distribution of drugs and alcohol on campus and at university events and activities. This report also contains information on programs and policies designed to prevent and address sexual violence, domestic violence, dating violence, and stalking. Each year, email notification of this website is made to all faculty, staff, and enrolled students. Written notification is also provided to prospective students and employees. Hard copies of the Annual Security & Fire Safety Report may be obtained from the Miami University Police Department at (513) 529-2223. |
| Labor Law Posters for Applicants: |
|
| Benefits Eligible: |
Yes
|
