Senior Data Analyst

The State of South Carolina seeks a Senior Data Analyst to design and maintain automated data pipelines, ETL/ELT workflows, and governance practices that power the enterprise data lake and data warehouse. This on-site role in Charleston, SC, collaborates with IT, Institutional Research, and campus stakeholders to deliver reliable analytics, dashboards, and insights that inform decisions across the organization. The position offers a salary range of USD 79,600 to 143,300 annually and requires a bachelor’s degree in a data-related field with at least five years of relevant experience.

Responsibilities

• 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
• 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, including identifying necessary cost plans/payors and assessing AI implications (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
• Conduct comprehensive data analysis to identify trends, patterns, and anomalies 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 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 BI reports and interpreting insights for decision-making
• Develop and maintain data and business process documentation, ensuring accuracy and clear communication to non-experts; solicit feedback to improve interpretability
• Triage existing data problems and collaborate with departmental data analysts and institutional data stewards to resolve performance and data errors within deadlines
• Conduct thorough testing and validation of reports to ensure accuracy; regularly update reports to reflect changes in business needs or data sources
• Contribute to institutional data literacy goals that empower campus stakeholders to understand and apply data in decision-making
• Provide research-backed recommendations for a data strategy and BI strategic roadmap
• Research emerging BI and data analysis technologies, industry trends, and new methods to enhance campus-wide data insights
• Evaluate, implement, and optimize BI tools and functionalities to support institutional priorities and align with the College’s strategic plan
• Manage BI projects and participate on project teams for BI-related initiatives
• Participate in institutional data-related committees and groups
• Collaborate with BI teammates, IT Business Consultants, and cross-functional stakeholders to gather requirements, understand processes, and support technical needs
• Communicate complex data concepts to non-technical stakeholders clearly
• Stay current with industry trends and best practices in data analysis, warehousing, and data lakes
• Identify opportunities for process improvements and implement innovative data solutions
• Engage in continuous professional development and share knowledge to enhance team capabilities and institutional data practices

Requirements

• A bachelor’s degree in Data Science, Computer Science, Information Technology, Statistics, Math, or a related field is required
• Five years of applicable experience in data analysis and warehousing is required; relevant experience may be substituted for the degree on a year-for-year basis

Technologies

• Ellucian Banner ODS
• AI tools
• Enterprise data lake platform
• Cloud-based data warehouse

Supplemental Information

• Candidates should bring a forward-thinking mindset and the technical acumen to responsibly harness evolving platforms and toolsets, including AI implications
• Strong self-initiative, exemplary work ethic, and ongoing professional development are expected at a senior level
• Some occasional travel for professional development, conferences, and meetings may be required
• Please complete the online application to include all current and previous work history and education; a resume will not be accepted for qualification determination
• Salary is commensurate with education and experience beyond the minimum requirements
• Offers of employment are contingent upon a successful background check
• All applications must be submitted online at https://jobs.cofc.edu