Data and Reporting Engineer

University Overview Thomas More provides a Catholic education that goes beyond academics, nurturing intellectual, personal, and spiritual growth. Guided by four core values known as the Characteristics of a Saint: Hospitality, Humility, Service, and Stewardship, we strive to foster a welcoming community that recognizes the dignity of every person, approaches learning and relationships with openness and humility, serves others with compassion and purpose, and faithfully stewards the gifts, opportunities, and responsibilities entrusted to us. These values shape our culture, inform our decisions, and inspire our commitment to educating individuals who lead lives of purpose, integrity, and service. Our mission, rooted in the Catholic Intellectual Tradition, is to educate with purpose - helping students reach their potential while serving the greater good. Position Summary The Data and Reporting Engineer manages data from various sources, ensuring data quality and integrity, to create meaningful reports for stakeholders. This position plays a key role in strengthening the University’s data and reporting environment enabling a culture of data literacy and data-informed decision-making. This is a highly technical and collaborative role. 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