Senior Data Analyst

What we offer

Compensation: USD 79,600 to 143,300 per year. Location: Onsite in Charleston County, South Carolina. The Senior Data Analyst role focuses on data management, ETL/ELT, data integration, analysis and reporting, BI strategy, collaboration, and continuous improvement to support data governance, security, and actionable insights across the organization.

Responsibilities

• Partner with IT, Institutional Research, and campus stakeholders to design and build automated data pipelines that feed the enterprise data lake architecture
• Develop and maintain ETL/ELT processes to ingest, transform, and consolidate data from multiple systems into the data lake
• Support the deployment and ongoing optimization of the college's cloud-based data warehouse and data lake environment
• Oversee the data lifecycle to maintain 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, compliant data usage, including FERPA adherence and institutional policies
• Evaluate and integrate emerging technologies, including AI tools, with governance, security controls, and cost awareness
• Establish and maintain data tracking, validation, and quality assurance processes to ensure reliable analytical outputs
• Collaborate with IT colleagues and other stakeholders to ensure seamless data integration from diverse sources into the enterprise data lake for analysis and reporting
• Together with institutional data owners, develop and manage third-party ETL/ELT processes to extract, transform, and load data from multiple sources to support reports and dashboards, including identifying cost plans/payors and evaluating AI implications
• Monitor and troubleshoot ETL/ELT processes to maintain data quality and reliability
• Ensure data pipelines align with governance standards, including metadata, data classification, and lineage
• Maintain the stability, operation, and support of the legacy Ellucian Operational Data Store
• Conduct data analysis to identify trends, patterns, and anomalies and provide actionable insights for strategic planning
• Develop and maintain dashboards, reports, and visualizations to communicate findings to stakeholders
• Offer data-driven recommendations to drive improvements across processes and initiatives
• Create reports and contribute to processes for harmonizing and improving quality across the college’s data systems
• Provide training and support to end-users on BI reports to help them interpret insights for decision making
• Develop and maintain data and process documentation to preserve historical data and ensure continuity
• Ensure documentation reflects current processes and is accessible to non-experts; collect feedback for clarity
• Triage data problems and work with departmental analysts and data stewards to resolve issues by deadlines
• Test and validate reports for accuracy and reliability; update reports as business needs or data sources change
• Contribute to institutional data literacy goals to empower campus stakeholders to use data in decision making
• Provide research-backed recommendations for shaping the data strategy and BI roadmap
• Research emerging BI and data analysis technologies, industry trends, and methods to enhance campus-wide insights
• Evaluate, implement, and optimize BI tools and features to support institutional priorities and strategic plans
• Manage BI projects and participate in cross-functional BI initiatives
• Collaborate with BI teammates, IT Business Consultants, and stakeholders across divisions to gather requirements and support reporting objectives
• Communicate complex data concepts to non-technical audiences clearly and concisely
• 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
• Pursue ongoing professional development and share knowledge to strengthen team capabilities

Qualifications

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

Technologies

• Ellucian Banner ODS
• AI tools
• Unstructured data tools

Preferred qualifications

A Master’s degree is preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.

Additional information

Additional notes from the role include a forward-thinking mindset and the technical acumen to responsibly harness evolving platforms and tools, including AI. Strong self-initiative, work ethic, and ongoing professional development are expected for a senior level role. 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 or reviewed to determine qualifications. Salary is commensurate with education and experience beyond the minimum. Offers of employment are contingent upon a successful background check. All applications must be submitted online at https://jobs.cofc.edu.