Senior Business Intelligence Engineer Jobs in South Carolina

Internal Title Senior Data Analyst

Position Type Classified

Faculty / Non-Faculty / Administration Non-Faculty

Pay Band TEC07

Department Enterprise Systems

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

Additional Comments Regarding Position

Candidates should bring a forward-thinking mindset and the technical acumen to responsibly harness evolving platforms and toolsets – e.g. AI’s growing impact in data and technology roles. Strong self-initiative, exemplary work ethic, and continued professional development are expected, commensurate with a senior-level role. Some occasional travel for professional development, conferences, and meetings may be required.

Special Instructions to Applicants

Please complete the application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position. Salary is commensurate with education/experience which exceeds the minimum requirements.

Offers of employment are contingent upon a successful background check.

All applications must be submitted online.

Salary - $79,600 - $100,000

Posting Date 06/15/2026

Closing Date 07/10/2026

Benefits

* Insurance: Health/Dental/Vision
* Life Insurance
* Paid Leave: Sick/Annual/Parental
* Retirement
* Long Term Disability
* Paid Holidays
* Free CARTA Bus Service
* Employee Tuition Assistance Program (ETAP)
* Employee Assistance Program (EAP)
* Full Benefits Package – Click Here

Open Until Filled No

Posting Number 2026092

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.

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:

- 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 the development of processes designed to enhance harmonization and quality control between the College’s multiple data systems.

Support and Training:

- Provide training and support to end-users on how to effectively use and interpret business intelligence reports, ensuring they can leverage the insights for decision-making.
- Develop and maintain data and business process documentation in written and visual forms to ensure continuity in the storage and archival of historical data files, as necessary. Ensures that documentation is maintained and accurately represents current processes. Effectively translates technical procedures to forms of documentation that are understandable to non-experts. Periodically solicits feedback from colleagues to ensure documentation is interpretable and implementable by others.
- Triage existing data problems and collaborate with business unit departmental data analysts and institutional data stewards to ensure that performance and data errors are resolved within the required deadlines.
- Conduct thorough testing and validation of reports to ensure accuracy and reliability. Regularly review and update reports to reflect changes to business needs, data sources, or methodologies.

Business Intelligence (BI) Strategy and Project Management:

- Contribute to institutional data literacy goals that empower campus stakeholders to understand, interpret, and effectively use data in their decision-making processes.
- Provide research-backed recommendations for consideration in the development of a data strategy and a BI strategic roadmap.
- Research emerging BI and data analysis technologies (e.g., unstructured data tools), industry trends, and new analytical methods to enhance campus-wide data insights and support strategic, data-informed decision-making.
- Evaluate, implement, and optimize business intelligence tools and functionalities—including advanced features of existing platforms—to support institutional priorities and align with the College’s strategic plan.
- Manage projects involving BI and serve on project teams for all BI-related projects.

Collaboration and Communication:

- Participate in institutional data-related committees and groups.
- Work collaboratively with BI teammates, IT Business Consultants, and cross-functional stakeholders across institutional divisions (e.g., Enrollment Planning, Academic Affairs, Business Affairs, Student Affairs, and IT) to gather requirements, understand reporting objectives, maintain knowledge of business processes and cross-functional data relationships, and support related technical needs.
- Communicate complex data concepts to non-technical stakeholders in a clear and concise manner.

Continuous Improvement:

- 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 to stay current with data analysis tools, methodologies, and higher education trends; share acquired knowledge to enhance team capabilities and institutional data practices.