Volunteer State Community College is looking to solve the problem of seamless data flow and integration, and to create a robust foundation for the college's data ecosystem.
Requirements
- Experience in computer programming with Python and SQL.
- Microsoft Fabric Analytics Engineer Associate Certification.
- Microsoft Power BI Data Analyst Associate Certification.
- Datacamp Data Engineer Associate Certification.
- Datacamp SQL Associate Certification.
- CompTIA A+ Certification.
- Technical experience with Ellucian Banner.
Responsibilities
- Use Python and SQL to extract and integrate data from Ellucian Banner and external APIs, ensuring seamless data flow into the Microsoft Fabric Lakehouse solution.
- Design, develop, and deploy high-performance Python-based data pipelines for structured, semi-structured, and unstructured data.
- Implement performance tuning techniques to improve data engineering workloads.
- Work with Microsoft Azure and Fabric cloud services to design and implement robust cloud data architectures.
- Ensure the security and compliance of data products through the implementation of appropriate controls and data governance best practices.
- Design and maintain reporting dashboards and visualizations to track key performance indicators for various college initiatives.
- Create and maintain scripts and reports to facilitate the rapid completion of federally required surveys, such as IPEDS.
Other
- Associate's degree and three years of related experience OR Bachelor's degree and one year of related experience.
- Must be detail-oriented, highly organized, and self-motivated.
- Ability to handle multiple tasks simultaneously and meet deadlines.
- Ability to restructure transactional data into meaningful data models, such as star schemas.
- Supervise staff, assigns projects, monitors and evaluates performance, and provides training.
