linkedin
Senior Data Analyst
State of South Carolina
Charleston, UAE
Temporary
Senior
1 months ago
SQLETLELTData WarehousingData LakeEllucian Banner
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
SQLETLELT
About the Role
The State of South Carolina is seeking a Senior Data Analyst to collaborate on data management, ETL/ELT processes, and business intelligence. The role involves designing data pipelines, developing dashboards, and ensuring data governance.
Key Skills for This Role
SQLETLELTData WarehousingData LakeEllucian Banner
Responsibilities
- Collaborate with IT, Institutional Research, and campus stakeholders to design and build automated data pipelines supporting 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 lifecycle of institutional data to ensure integrity, accuracy, consistency, and availability
- Implement and enforce data governance practices, including metadata management, data quality standards, and data lineage tracking
- Develop and maintain dashboards, reports, and visualizations to communicate findings to stakeholders
- Provide training and support to end users on how to effectively use and interpret business intelligence reports
- Contribute to institutional data literacy goals
Requirements
- Bachelor’s degree in Data Science, Computer Science, Information Technology, Statistics, Math, or related field
- Five years of applicable experience in data analysis and warehousing
- Master’s degree preferred
Full Job Posting
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
- 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
- Develop and maintain data and business process documentation in written and visual forms
- Triage existing data problems and collaborate with business unit departmental data analysts and institutional data stewards
- Conduct thorough testing and validation of reports to ensure accuracy and reliability
Business Intelligence (BI) Strategy And Project Management
- Contribute to institutional data literacy goals that empower campus stakeholders to understand, interpret, and effectively use data
- 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, industry trends, and new analytical methods
- Evaluate, implement, and optimize business intelligence tools and functionalities
- 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
- 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
Minimum And Additional 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.
Preferred Qualifications
- A Master’s degree is preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career