The College of the Holy Cross needs to design, build, and maintain the infrastructure for capturing, processing, and analyzing critical data across its systems to support operational effectiveness and strategic planning.
Requirements
- Strong proficiency with SQL and scripting languages such as Python.
- Experience with basic computer programming/scripting languages.
- Experience with git and other development tools.
- Solid understanding of data modeling techniques, ETL/ELT pipelines, and processing of structured and semi-structured data.
- Familiarity with metadata management tools, data catalogs, and data dictionaries.
- Experience implementing observability practices for data pipelines and cloud infrastructure.
- Hands-on experience developing in AWS environments and working with Snowflake data platforms preferred
Responsibilities
- Design, develop, and maintain scalable data pipelines and workflows using platforms such as AWS and Workato.
- Integrate structured and unstructured data from multiple sources into centralized repositories, including Snowflake-based data warehouses.
- Create and manage ETL/ELT processes to ensure timely, accurate, and secure data transformation and delivery.
- Monitor data infrastructure for performance, availability, and data integrity, and implement systems for logging, alerting, and quality control.
- Support the development of data models that align with business requirements through dimensional modeling, fact/dimension tables, and metadata documentation.
- Assist in maintaining data governance protocols, including metadata catalogs and access control mechanisms.
- Partner with IT security, cloud engineering, and data architecture teams to ensure infrastructure reliability and compliance with security standards.
Other
- Collaborate with cross-functional teams to support analytics, business intelligence, and institutional research needs.
- Ability to work collaboratively with stakeholders across analytics, IT, and academic functional areas.
- Knowledge of best practices in data security and compliance within cloud-based environments.
- Excellent Written & Verbal Communication
- Proficient Problem Solving
