Senior Data Analyst
Job Purpose:
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.”
Minimum Requirements:
A bachelor’s degree in Data Science, Computer Science, Information Technology, Statistics, Math, or a related field and five years of applicable experience in data analysis and warehousing is required. Relevant experience may be substituted for the Bachelor’s degree on a year-for-year basis. A Master’s degree is preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.
Required Knowledge, Skills and Abilities:
Required Skills:
- General
- Exceptional attention to detail, organizational skills, and the ability to manage multiple tasks simultaneously and independently. Must be able to prioritize, plan, and accomplish duties in a timely manner.
- Proven research, analytical, and problem-solving skills.
- Talent for identifying and executing enhancements to improve the efficiency of data and business processes.
- Proficiency with MS Office/Office 365.
- Technical
- Proven ability to integrate and configure AI tools (e.g., Copilot, OpenAI, Gemini) to enhance productivity, with sound judgment in evaluating security, cost, and operational implications.
- Experience with:
- Data mining, including techniques of data extraction, documentation, analysis, and reporting.
- Reporting tools such as Cognos/Insights/Argos.
- Dashboarding or visual analytics such as Tableau and Power BI.
- Programming and statistical languages such as SQL, Python, R, SAS, and SPSS.
- Understanding of:
- Data modeling, ETL/ELT processes, and/or data integration techniques.
- Data Lake Management.
- Familiarity with data governance, security, and privacy best practices.
- Communications
- Excellent written and verbal communication skills with the ability to communicate complex technical information to non-technical stakeholders.
- Must be able to form successful working relationships with senior leadership, faculty, staff, students, and external authorities and organizations, as appropriate.
- Ability to provide status reports and other technical reports in a clear and concise manner.
Preferred Skills:
- Proficiency in data modeling, ETL/ELT processes, and/or data integration techniques.
- Working knowledge and practitioner of methods and techniques of data extraction, documentation, analysis, and reporting.
- Experience with:
- Data integration and transformation using ETL/ELT tools (e.g., Matillion or similar)
- Cloud-based data platforms (e.g., Snowflake, Azure, or comparable architectures)
- Data visualization tools (e.g., Power BI, Tableau, or similar)
-
SQL and at least one programming language (e.g., Python or R)
- Modern Cloud-based data warehousing and data lake solutions
- Specific tools that are applicable to our current systems – Cognos, Insights, and/or Tableau
- Cloud costing models
- Knowledge and understanding of/adherence to:
-
FERPA regulations and other data security and privacy laws.
- Data analysis techniques like machine learning, predictive modeling, and statistical analysis.
- Big data technologies such as Hadoop, Spark, or similar.
- The data needs of Higher Education and relevant systems, such as Ellucian’s Banner ERP and ODS, and their Oracle relational database infrastructure.
- Repositories such as Salesforce, IPEDS, US News, and National Student Clearinghouse (NSC).
Salary: *$79,600 - $100,000
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.
|