Information Technology Spec 4 - Data Modeler

The Data Modeler, Metadata Specialist (ITS 4) provides advanced, enterprise-level expertise in data modeling and metadata management to support trusted reporting, analytics, and modern data architecture across Minnesota State Colleges and Universities. This position designs and maintains conceptual, logical, and physical data models; establishes and curates the business and technical metadata; and supports data lineage and standards that enable secure, reusable, and high-quality data products. The role partners with functional and technical stakeholders to ensure that data is understandable, well governed , and fit for self-service analytics, operational reporting, and AI-driven use cases.

• Five (5) years of professional experience in enterprise data modeling and metadata practices supporting analytics solutions, using tools such as SQL Developer Data Modeler , Microsoft Fabric ( OneLake ) , Azure Data Factory/Fabric Data Pipelines , Dataflows Gen2 , and/or comparable ETL/ELT and modeling tools (e.g., CData , GoldenGate , or similar). A Bachelor’s degree in a related field may substitute for one (1) year of experience.
• Advanced SQL proficiency ( e.g., T-SQL, PL/SQL ) with experience validating data structures and transformations to support reliable reporting and analytics.
• Experience developing and maintaining business and technical metadata , including definitions, stewardship, classifications, and lineage, using tools such as Microsoft Purview , Data Cookbook , and/or equivalent data catalog/governance platforms.
• Demonstrated ability to collaborate effectively on large, complex, cross-functional data initiatives, including work in distributed/federated environments.
• Demonstrated ability to deliver modeling/metadata work products with strong organization, documentation, and stakeholder communication , including clear status reporting.

Preferred Qualification

• Experience supporting enterprise or large-scale application systems.
• Experience giving formal presentations to business audiences.
• Experience assessing skill gaps, individual competency, and job performance to design, implement and evaluate training, documentation and coaching initiatives for software products.
• Experience working with systems and administrative procedures in a higher education environment.

4.74.7 out of 5 stars Saint Paul, MN Remote $37.72 - $62.21 an hour - Full-time, Pulled from the full job description

• 457(b)
• 403(b)
• Paid parental leave
• Parental leave
• Health insurance
• Dental insurance
• Flexible spending account, Work Shift (Hours / Days of work)

Monday - Friday, 8:00am - 4:30pm

Telework (Yes/No)

Yes

About

Minnesota State is committed to attracting, retaining, and developing talented employees who serve our 270,000 students each year throughout the state. We have a vibrant and diverse system of 33 colleges and universities with 14,567 dedicated faculty and staff focused on student success.

Benefits Information:

At Minnesota State, we take your well-being and work-life balance seriously. We offer a comprehensive benefits package that features low-cost medical and dental insurance with affordable deductibles, employer-paid life insurance, short- and long-term disability, and pre-tax healthcare and dependent care accounts with a roll-over option. To further support your holistic health, employees also have access to a confidential Employee Assistance Program (EAP) for mental health, legal, and financial counseling. Detailed plan details, rates, and coverage choices can be reviewed directly via the State Employee Group Insurance Program (SEGIP) website.

To support your life outside of work, our package includes 12 paid holidays, generous vacation and sick time, and six weeks of Paid Parental Leave. We also help you secure your financial future with a robust Pension Plan, 457(b) and 403(b) retirement accounts, and various investment options. Furthermore, we invest in your growth by providing dedicated professional development and tuition waivers for both you and your dependents. Please note that specific benefit eligibility and coverage levels may vary depending on the type of position, employee classification, and collective bargaining agreements.