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.”

See College of Charleston Employment Site | Senior Data Analyst for full job duties.

Data Management:

• 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

Data Integration and ETL/ELT:

• 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.
• In collaboration with institutional data owners, develop and manage 3rd party (non-ERP) ETL/ELT processes to extract, transform, and load data from multiple sources to support report and dashboard creation. This is inclusive of ensuring the identification and inclusion of necessary cost plans/payors and assessments of AI implications (e.g., security, costs, etc.).
• 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.
• Ensure legacy Ellucian Operational Data Store remains stable, operational, and supported.

Data Analysis & Reporting; Support and Training; Business Intelligence (BI) Strategy and Project Management; Collaboration and Communication; Continuous Improvement....
...continued at College of Charleston Employment Site | Senior Data Analyst.