Description

We are looking for an experienced Business Intelligence Data Modeler to join our team and play a key role in the implementation of an Enterprise Analytics Platform (EAP). This platform includes a data lake designed to support multiple universities and campuses. In this role, you will collaborate closely with analysts, developers, and stakeholders to design and develop data models that integrate various source systems into cohesive reporting and visualization solutions.

Company Culture and Environment

The work environment emphasizes collaboration and teamwork, as you will be working closely with analysts, developers, and stakeholders. A focus on high-quality data and effective communication is paramount in this role, creating a culture that values both technical expertise and the ability to convey complex information to diverse audiences.

Career Growth and Development Opportunities

This position offers a significant opportunity for professional development within a high-impact analytics initiative that supports multiple universities and campuses. Engaging in this role can provide exposure to various data technologies and methodologies, facilitating career advancement in data analytics and business intelligence.

Detailed Benefits and Perks

While specific benefits are not outlined in the job description, a role of this nature typically includes competitive compensation, health and wellness benefits, and opportunities for continuous learning and professional development.

Compensation and Benefits

• Competitive salary based on experience
• Health, dental, and vision insurance
• Opportunities for professional development and continuous learning

Why you should apply for this position today

This is a fantastic opportunity to contribute to a high-impact analytics initiative that supports multiple universities and campuses. If you are passionate about data modeling and enterprise analytics, we would love to hear from you!

Skills

• Strong understanding of database structures, data warehousing concepts, and data lakes
• Expertise in data modeling principles and best practices, focusing on relational and dimensional modeling
• Hands-on experience with AWS Redshift and data modeling tools (ER Studio preferred)
• Familiarity with cloud-based architecture and AWS environments
• Understanding of the software development lifecycle (SDLC)
• Knowledge of metadata management and object-oriented/domain-driven design
• Strong communication skills and ability to convey technical concepts to non-technical users
• Excellent analytical and problem-solving skills

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models to support enterprise analytics
• Integrate multiple data sources—including Oracle/PeopleSoft HR, Finance, and Workday—into a structured and coherent data catalog
• Work with analysts to understand business requirements and translate them into effective data models
• Conduct gap analyses and cost/benefit/risk assessments to optimize data model designs
• Ensure all data models adhere to design and security best practices
• Perform data profiling and analysis to maintain high data quality
• Collaborate with cross-functional teams to integrate metadata into tools like Collibra and Tableau
• Provide walkthroughs and support to EAP consumers and stakeholders

Qualifications

• At least 3 years of experience in a relevant role (e.g., Data Architect, Data Scientist, Data Analyst, Data Engineer, or Business Intelligence Analyst)
• Experience gathering and analyzing data, reports, and business requirements
• Strong communication skills, with the ability to work in a team environment

Education Requirements

• Bachelor’s degree in a relevant field such as Computer Science, Data Science, or Information Systems

Education Requirements Credential Category

• Bachelor’s degree

Experience Requirements

• At least 3 years of experience in data modeling or a related role
• Experience working with higher education data and reporting is preferred
• Background in migrating legacy applications and data systems to modern platforms is a plus

Why work in Madison, WI

Madison, WI, is known for its vibrant community and diverse cultural offerings, making it an attractive place to live and work. With a strong focus on education and innovation, Madison offers numerous opportunities for professional development. The city’s beautiful parks, lakes, and lively downtown area provide a balanced lifestyle that fosters both personal and professional growth.