Required Skills
Commitment to data accuracy, confidentiality, security, and responsible data use
Proficiency in SQL and database management systems
Programming skills for data processing and automation, preferably C# and R
Strong analytical and problem-solving skills
Excellent communication skills to work effectively with cross-functional teams and end-users and clearly explain technical topics to non-technical users
Ability to adapt to evolving technologies and trends in data engineering and reporting
Preferred Skills
Understanding of data governance and data security principles
Experience presenting to a large group and leadership
Familiarity with reporting and visualization tools
Job-Related Activities
Data Engineering
Gather and connect University data from diverse sources, such as databases, APIs, and flat files
Clean, transform, and preprocess data to ensure accuracy and consistency
Create and maintain database objects, queries, views, stored procedures, and other data solutions that support institutional reporting and analytics
Identify opportunities to automate manual data collection, transformation, validation, and reporting processes
Collaborate with IT Services and functional system owners on integrations, system changes, and data-related projects
Data Quality and Governance
Implement data quality checks and validation processes
Identify data discrepancies and inconsistencies across systems and work with appropriate data owners to resolve them
Contribute to the development and maintenance of institutional data definitions, data dictionaries, reporting standards, and documentation
Monitor data processes and troubleshoot issues affecting data availability, accuracy, and reliability
Audit reporting outputs to ensure accuracy, consistency, and alignment with institutional definitions
Institutional Reporting and Analytics
Develop, maintain, and improve recurring institutional reports and reporting processes
Collaborate with end-users to define and translate reporting requirements into effective technical and analytical solutions
Develop dashboards, visualizations, and self-service reporting tools that allow campus users to access and understand institutional data
Support reporting related to enrollment, student success, academics, faculty and staff, finance, operations, and other institutional priorities
Assist with federal, state, accreditation, regulatory, and other external reporting requirements as assigned
Documentation and Knowledge Sharing
Document data sources, business rules, calculations, processes, and reporting methodologies
Promote responsible and appropriate use of institutional data
Work collaboratively to understand data needs and develop solutions
Translate technical data concepts into clear, understandable language for non-technical audiences
Provide training and support related to reporting tools, dashboards, data definitions, and self-service reporting
Collaborate with team members and end-users to share knowledge and best practices
Technical Expertise
Remain up-to-date with emerging technologies and best practices in data engineering and reporting
Continuously enhance skills in SQL, data modeling, and reporting tools
Education, Specialized and/or Technical Knowledge Requirements
Bachelor’s degree in Computer Science, Data Analytics, or related field
Experience in database management, data analysis, or data visualization
Physical Job Requirements
Tools and Equipment Used
Personal computer, copier, phone and other typical office equipment
Travel
Minimal – less than 5% of the time
Physical & Mental Demands
Ability to work at a computer terminal for extended periods of time
Digital dexterity and hand/eye coordination in operation of all assigned equipment
Ability to speak to and hear employees/students via phone or in person
Body motor skills sufficient to enable incumbent to move around all areas of the campus
Capable of lifting equipment up to 30 pounds
Ability to analyze data and other reports and make recommendations
Mental requirements include: compare, decide, direct, problem solve, analyze, instruct, interpret