Data Analyst

Data Analyst

Posting Number: 0001063;

Reports to:

Chief Information Officer;
Department:
Institutional Research;
Classification:
Exempt;
Full or Part-time:
Full Time.

This position contributes to data collection and analysis; theproductionof reports, dashboards, visualizations, and publications; and the management and fulfillment of data requestsvia the ticketing system. The role requires strong SQL skills for writing complex queries, optimizing performance, and interpreting data models across enterprise databases, including proficiency with Oracle database concepts and schema design. Power BI and SQL Server Reporting Services (SSRS) are required for building and deliveringenterprise reports and dashboards.

The position supportsinstitutional and enrollment management goals by implementing,automating, and maintaining reporting systems and data pipelines,improving processes, and delivering accurate, timely insights to stakeholders.

• Manage data collection, analysis, and report development including development of datasets, dashboards, and publicationsusing Power BI/SSRS.
• Manage customer requests for information,triage and fulfill via the IR service portal; documentrequirements, sources, and definitions.
• Responsible for enterprise reporting development using Power BI and SSRS; designs,develops, and maintains datasets, paginated reports, dashboards,and data models aligned to institutional standards.
• Work with institutional stakeholders to gather, understand, and definebusiness requirements.
• Apply appropriate statistical techniques;ensure reproducibility of methods. to provide reports to, andanswer questions from stakeholders.
• Identifies and resolvesproduction and/or applications development problems related to reporting data flows, queries, and scheduled report delivery.
• Uses data and system analysis to identify opportunities to improve and automate business processes and collaborate with internal stakeholders in developing recommendations on these process improvements.
• Writes, optimizes, and maintains complex SQL queries and stored procedures across Oracle and SQL Server;implements and monitors reporting data pipelines; createsvalidation checks and audit trails.
• Maintains current and accurate knowledge of data storage and management best practices.
• Designs and maintains reporting semantic layers/data models that meet requirements efficiently and reliably.
• Track project performance, specifically to analyze successful completion of short and long-term goals.
• Updates and maintains the institutional reporting calendar; sequences and trackscross-department deliverables; ensures on-time publication and compliance submissions
• Coordinates access provisioning for reporting content and data sources in collaboration with IT/IR;manages security roles for reports and data models consistent withFERPA and institutional policy.
• Develops and enforces reportingstyle guides and visualization standards; reviews and validatesenterprise reports prior to release for accuracy, accessibility,and consistency.
• Ability to manage and manipulate data with accuracy and precision.
• Ensures reporting and analytics projects are completed on time and within estimated effort.
• Assist withad hoc data collection, data analysis, and report development.
• Develops and maintains documentation and standards.
• Maintain internal data project manuals.
• Develop and maintain technical documentation for internal use and end-user documentation for training purposes
• WCAG aligned report and dashboard design;color-blind-safe palate; alt-text and narrative summaries
• Maintain collaborative partnership with stakeholders to gatherrequirements for projects and openly communicate progress
• Collaborate with internal IT, ERP, and IR team to share best practices and user knowledge to allow redundancy for troubleshooting and other technical needs
• Cross-training on Power BI, SSRS, and SQL fundamentals for data consumers.
• Other duties as assigned.

• Bachelor's degree required; preferred fields include dataanalytics, statistics, information systems, computer science, orrelated.
• Two or more years of experience in data analysis and institutional reporting required.
• Advanced SQL for complex querywriting, optimization, and data modeling across Oracle and SQLServer/T-SQL
• Proficiency with PowerBI and SQL Servier Reporting Services (SRSS) for building enterprise dashboards and paginatedreports
• Strong understanding of relational database concepts and reporting data models
• Ability to design and maintain reportingdatasets, implement data quality checks, and document lineagedefinitions
• FERPA compliant handling of confidential data;role-based access and report/data-level security practices
• Pythonfor data wrangling /automation is preferred
• SQL Server Integration Services (SSIS) or other ETL tools are preferred
• Experience with accreditation/compliance reporting (E.g., IPEDS, Perkins, HLC) andcampus survey analytics is preferred
• Strong critical thinking and analytical problem-solving skills
• Excellent written and…