Senior ETL Developer

Fairfield Department of Health • Fairfield, CT

307d

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. The Senior ETL Developer is responsible for designing, developing, and maintaining the Extract, Transform, Load (ETL) processes that support Fairfield University’s cloud-based data warehouse and analytics platforms. This role involves managing data ingestion, data transformation, and integration to ensure high-quality, efficient, and scalable data movement across university systems. The Senior ETL Developer will work closely with business stakeholders, data architects, and IT teams to support institutional data initiatives and strategic objectives.

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.

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.

Benefits

• Equal employment opportunities to all employees and applicants for employment.
• Prohibits discrimination and harassment of any type.
• Commitment to fostering a healthy workplace and lifestyle for employees.

What This Job Offers

• Career Level: Senior
• Education Level: Bachelor's degree