Senior ETL Developer

About the position

Fairfield University is seeking a Senior ETL Developer to contribute to the modernization of our cloud-based data infrastructure. In this role, you will design and manage data pipelines and integrations that support advanced analytics and decision-making across the institution. This is an opportunity to work with modern cloud technologies and play a key part in the university's efforts to enhance its data strategy and operational efficiency.

Responsibilities

• Design, develop, and maintain high-performance ETL pipelines.
• Ensure data accuracy, consistency, and integrity across different university systems.
• Monitor and optimize ETL performance, load balancing, and execution times.
• Work with data architects to enhance the existing cloud data warehouse framework.
• Implement data security best practices in alignment with compliance policies.
• Ensure proper access control and data masking techniques.
• Work closely with institutional researchers, finance, admissions, and other departments to define and implement data ingestion rules.
• Assist stakeholders in defining data transformations and modeling requirements.
• Stay current with emerging trends in data engineering, cloud computing, and machine learning.
• Evaluate and recommend new tools, techniques, and methodologies for data integration.
• Monitor ETL jobs, troubleshoot failures, and optimize data pipeline performance.
• Provide support for production data processes and resolve data inconsistencies.
• Maintain detailed technical documentation for ETL processes and data workflows.
• Provide training and guidance to junior developers and data analysts.
• Participate in data migration and digital transformation initiatives.
• Collaborate on business intelligence reporting and analytics solutions.
• Develop and maintain data lineage and metadata management practices.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
• 5+ years of experience in data engineering, ETL development, and data integration.
• 2+ years of experience in an ETL Architect or Lead role, designing scalable data pipelines.
• Strong experience with cloud-based data warehousing and integration.
• Proficiency in SQL, relational databases, and data modeling.
• Hands-on experience in ETL tools such as Informatica (preferred), Talend, or AWS Glue.
• Experience working with DevOps practices, version control, and CI/CD pipelines.
• Strong understanding of data security, governance, and compliance.

Nice-to-haves

• Knowledge of AWS, Azure, or GCP cloud environments.
• Experience with Python, Shell scripting, and automation tools.
• Understanding of reporting tools and dashboard integration.
• Familiarity with heterogeneous source systems, APIs, and database connectivity.