This job offer is no longer available
Senior Data Analyst
COLLEGE CORNER
- Charleston, South Carolina, United States
- Charleston, South Carolina, United States
About
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.” 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. Data Integration and ETL / ELT (20%)
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. Data Analysis & Reporting (15%)
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. Support and Training (15%)
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. Business Intelligence (BI) Strategy and Project Management (15%)
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 serve on project teams for all BI‑related projects. Collaboration and Communication (15%)
Participate in institutional data‑related committees and groups. Work collaboratively with BI teammates, IT Business Consultants, and cross‑functional stakeholders to gather requirements, understand reporting objectives, and support technical needs. Communicate complex data concepts to non‑technical stakeholders in a clear and concise manner. Continuous Improvement (10%)
Stay up‑to‑date with industry trends and best practices in data analysis, data warehousing, and data lakes. Identify opportunities for process improvements and implement innovative data solutions. Engage in continuous professional development by pursuing relevant training, certifications, and learning opportunities. Essential or Marginal
Percent of Time: 10% Qualifications
Bachelor’s degree in Data Science, Computer Science, Information Technology, Statistics, Mathematics, or a related field and five years of applicable experience in data analysis and warehousing. Master’s degree is preferred; equivalent combination of experience and/or education is encouraged. Required Knowledge, Skills and Abilities
General
Exceptional attention to detail, organizational skills, and ability to manage multiple tasks independently. Proven research, analytical, and problem‑solving skills. Talent for identifying and executing enhancements to improve data and business process efficiency. Proficiency with MS Office/Office 365.
Technical
Proven ability to integrate and configure AI tools (Copilot, OpenAI, Gemini) to enhance productivity. Experience with data mining, extraction, documentation, analysis, and reporting. Reporting tools: Cognos, Insights, Argos; dashboarding or visual analytics: Tableau, Power BI. Programming and statistical languages: SQL, Python, R, SAS, SPSS. Understanding of data modeling, ETL / ELT processes, data integration techniques, and Data Lake Management. Familiarity with data governance, security, and privacy best practices.
Communications
Excellent written and verbal communication skills, able to convey complex technical information to non‑technical stakeholders. Ability to form successful working relationships with senior leadership, faculty, staff, students, and external authorities. Ability to provide status reports and other technical reports concisely.
Preferred Skills
Proficiency in data modeling, ETL / ELT processes, and/or data integration techniques. Experience with ETL / ELT tools such as Matillion. Experience with cloud‑based data platforms: Snowflake, Azure, or comparable architectures. Experience with data visualization tools: Power BI, Tableau. SQL and at least one programming language: Python or R. Experience with modern cloud‑based data warehousing and data lake solutions. Knowledge of FERPA regulations and other data security and privacy laws. Experience with machine learning, predictive modeling, and statistical analysis. Experience with big data technologies such as Hadoop, Spark. Understanding of Higher Education data needs and systems such as Ellucian Banner ERP, ODS, Oracle, Salesforce, IPEDS, US News, National Student Clearinghouse. Benefits
Employee Tuition Assistance Program (ETAP). Special Instructions for Applicants
Complete the application to include all current and previous work history and education. Resumes will not be accepted or reviewed to determine if an applicant meets the qualifications for the position. Salary is commensurate with education/experience and exceeds minimum requirements. Offers of employment are contingent upon a successful background check. Required Documents
Resume Cover Letter / Letter of Application Optional Documents
Curriculum Vitae Other Document Other Document 2 Other Document 3 Form DD 214 EEO Statement
The College of Charleston is an equal opportunity employer and does not discriminate against any individual or group on the basis of sex, gender (including gender identity and/or expression), pregnancy, race, religion, color, national origin, age, disability, military or veteran status, sexual orientation, genetic information, and other classifications protected by applicable federal, state, and local laws. For more information, please visit eop.cofc.edu.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.