Senior Data Analyst

Position Overview

The Senior Data Analyst supports the College’s data stewards by ensuring the accuracy, governance, and accessibility of institutional data within both legacy on prem and modern, cloud-based data ecosystem.

This role plays a key part in the College’s enterprise data lake initiative, leveraging platforms such as Snowflake, Azure, and Microsoft Purview to enable trusted, scalable, and secure data use across departments.

The Senior Data Analyst partners with stakeholders to deliver data-driven insights, develop automated data pipelines, and promote consistent definitions and governance practices. This role contributes to advancing a culture of data-informed decision-making and supports the College’s transition to a unified “single source of truth.”

• Collaborate with IT, Institutional Research, and campus stakeholders to design and build automated data pipelines supporting the enterprise data lake architecture.
• Develop and maintain ETL / ELT processes to ingest, transform, and integrate data from multiple systems into the data lake.
• Support implementation and ongoing optimization of the College’s cloud-based data warehouse and data lake environment.
• Manage the lifecycle of institutional data to ensure integrity, accuracy, consistency, and availability across the platform.
• Support and maintain Ellucian Banner ODS integrations and related data flows.
• Implement and enforce data governance practices, including metadata management, data quality standards, and data lineage tracking.
• Partner with stakeholders to ensure secure and compliant use of data, including adherence to FERPA and institutional policies.
• Evaluate and integrate emerging technologies, including AI tools, ensuring proper governance, security controls, and cost awareness.
• Establish and maintain data tracking, validation, and quality assurance processes to ensure reliability of analytical outputs.

• Collaborate with IT colleagues and other university stakeholders to ensure seamless data integration from various sources into the College’s enterprise data lake platform for analysis and reporting.
• Develop and manage third‑party ETL / ELT processes to extract, transform, and load data from multiple sources to support report and dashboard creation.
• Monitor and troubleshoot ETL / ELT processes to ensure data quality and reliability.
• Ensure data pipelines align with institutional data governance standards, including metadata, classification, and lineage requirements.
• Maintain legacy Ellucian Operational Data Store stability.

• Conduct comprehensive data analysis to identify trends, patterns, and anomalies in data to provide actionable insights that support strategic planning and operational efficiency.
• Develop and maintain dashboards, reports, and visualizations to communicate findings to stakeholders.
• Provide actionable recommendations based on data analysis to drive business improvements.
• Create reports and contribute to process development to enhance harmonization and quality control between the College’s multiple data systems.

• Provide training and support to end‑users on how to effectively use and interpret business intelligence reports.
• Develop and maintain data and business process documentation in written and visual forms to ensure continuity and accuracy.
• Triage existing data problems and collaborate with business units, data analysts and stewards to resolve performance and data errors timely.
• Conduct thorough testing and validation of reports to ensure accuracy and reliability, and review updates to reflect changing business needs.

• Contribute to institutional data literacy goals that empower campus stakeholders to understand, interpret, and use data in decision‑making.
• Provide research‑backed recommendations for data strategy and BI roadmap.
• Research emerging BI and data analysis technologies and trends to enhance campus‑wide data insights.
• Evaluate, implement, and optimize BI tools and functionalities, including advanced features of existing platforms.
• Manage BI projects and…