Center for Public Partnerships & Research · 5 hours ago
Data Modeler
United States
Full-time
Remote
Mid Level
$71K/yr - $85K/yr
3+ years expCenter for Public Partnerships & Research is part of the University of Kansas, focusing on data strategy and informed decision making. The Data Modeler is responsible for designing and maintaining data systems, supporting analytics, and collaborating with cross-functional teams to enhance data governance and self-service analytics.
Higher Education
No H1B
Responsibilities
Design, develop, and maintain scalable ETL/ELT pipelines integrating data from diverse internal and external sources
Develop and optimize SQL-based processes to support data loading, transformation, and validation tasks
Maintain and enhance KU’s Data Warehouse and Data Lake environments to support analytics, dashboards, and operational reports
Support AI/ML model integration pipelines and prepare data for model training, scoring, and inferencing
Collaborate with BI Analysts, Data Scientists, and business stakeholders to translate requirements into performant data engineering solutions
Maintain and document data workflows, source-to-target mappings, and architecture diagrams in accordance with data governance policies
Ensure metadata capture and compliance with KU’s data catalog and dictionary
Provide production support for ETL/ELT jobs, data pipelines, and cloud-based infrastructure
Troubleshoot issues related to data ingestion, transformation, and availability
Monitor job performance and system health, coordinating with IT operations as needed
Participate in upgrade cycles for ETL tools, cloud platforms, and database systems
Execute data validation strategies for all data pipelines and models
Implement audit controls, data quality checks, and reconciliation procedures
Collaborate with QA teams and business users for UAT and production validation
Participate in campus-wide data initiatives, pilot projects, and tool evaluations
Contribute to continuous improvement and innovation in KU’s data engineering practices
Qualification
Required
Bachelor's degree in computer science, Information Technology, Engineering, Mathematics, Statistics or a related field
Three (3) years of demonstrated experience using Python for scripting, automation, and data manipulation across academic, professional, or project-based environments
Two (2) years of hands-on experience with at least one major cloud platform, such as AWS, Azure, or Google Cloud Platform
Exposure to integrating AI/ML workflows or components into data pipelines, through coursework, projects, or professional experience
Working knowledge of SQL and relational database systems (e.g., Oracle, PostgreSQL, MySQL) as evidenced by application materials
Excellent communication, documentation, and collaboration skills as evidenced by application materials
Preferred
Exposure to CI/CD practices and version control systems such as Git as evidenced by application materials
Experience working with APIs, including data ingestion from RESTful services as evidenced by application materials
Company
Center for Public Partnerships & Research
At CPPR, we tackle complex issues challenging our communities by building and partnering with many dedicated public agency professionals, non-profit service providers, and family members living and working in communities.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Meghan Cizek
Assistant Director, Center for Public Partnerships and Research
Sara Gardner
Assistant Director, Center for Public Partnerships & Research
Company data provided by crunchbase