Senior Data Analyst

Responsibilities Data Management (20%)

• 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, including cost plans, payors, and AI implications.
• 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 stability, operational support, and legacy status for the Ellucian Operational Data Store.

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

• Provide training and support to end‑users on effectively using and interpreting business intelligence reports, ensuring they can leverage insights for decision‑making.
• Develop and maintain data and business process documentation in written and visual forms to ensure continuity and accurate representation of current processes.
• Triage existing data problems and collaborate with business unit analysts and institutional data stewards to resolve performance and data errors within required deadlines.
• Conduct thorough testing and validation of reports to ensure accuracy and reliability, regularly reviewing and updating reports to reflect changes in business needs, data sources, or methodologies.

• Contribute to institutional data literacy goals that empower campus stakeholders to understand, interpret, and effectively use data in decision‑making.
• Provide research‑backed recommendations for developing a data strategy and a BI strategic roadmap.
• Research emerging BI and data analysis technologies, industry trends, and new analytical methods to enhance campus‑wide data insights and support strategic, data‑informed decision‑making.
• Evaluate, implement, and optimize business intelligence tools and functionalities, including advanced features of existing platforms, to support institutional priorities and align with the College’s strategic plan.
• Manage projects involving BI and serve on project teams for all BI‑related projects.

• Participate in institutional data‑related committees and groups.
• Work collaboratively with BI teammates, IT Business Consultants, and cross‑functional stakeholders across institutional…