Senior ETL Developer

Job Description:

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.

Basic Function

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.

Knowledge and Skills Needed

Education:

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.

• Equivalent professional experience may be considered in place of formal education.

Experience:

• 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.

Specific Knowledge:

• ETL Development & Data Integration – Design and implement ETL workflows for structured and unstructured data.

• Cloud Platforms – Knowledge of AWS, Azure, or GCP cloud environments.

• Data Modeling & Performance Optimization – Optimize database design and query performance.

• Scripting & Automation – Experience with Python, Shell scripting, and automation tools.

• Business Intelligence & Analytics – Understanding of reporting tools and dashboard integration.

• Networking & Connectivity – Familiarity with heterogeneous source systems, APIs, and database connectivity.

Reports To

Data Architect

Essential Functions

ETL Framework Development & Management

• Design, develop, and maintain high-performance ETL pipelines.

• Ensure data accuracy, consistency, and integrity across different university systems.

Data Warehouse Optimization

• Monitor and optimize ETL performance, load balancing, and execution times.

• Work with data architects to enhance the existing cloud data warehouse framework.

Data Security & Governance

• Implement data security best practices in alignment with compliance policies.

• Ensure proper access control and data masking techniques.

Collaboration with Business & IT Teams

• 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.

Technology Evaluation & Best Practices

• Stay current with emerging trends in data engineering, cloud computing, and machine learning.

• Evaluate and recommend new tools, techniques, and methodologies for data integration.

Troubleshooting & Support

• Monitor ETL jobs, troubleshoot failures, and optimize data pipeline performance.

• Provide support for production data processes and resolve data inconsistencies.

Documentation & Knowledge Sharing

• Maintain detailed technical documentation for ETL processes and data workflows.

• Provide training and guidance to junior developers and data analysts.

Additional Responsibilities:

• 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.

• Perform other duties as assigned.

Work Conditions & Expectations:

• Hybrid work environment, pre-approval required for remote work.

• Some evening or weekend work may be required for critical system updates and migrations.

• Ability to handle sensitive data securely and responsibly.

Category:

ITS - Admin

Performs such other duties, responsibilities, and activities as required by supervisor and as departmental/University needs indicate. 
 

*Disclaimer

The above information indicates the general nature and level of work performed by employees within this classification. It is not designed to contain and should not be interpreted as a comprehensive inventory of all duties, responsibilities, activities, and/or qualifications required or expected of employees assigned to this job. Duties, responsibilities, and activities may change and new ones may be assigned at any time, with or without notice.

All offers of employment are contingent upon a satisfactory background check.

Fairfield University provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Load a resume or CV first, then upload supporting documents including a cover letter at the bottom of the third page under the "My Experience" section where it says to upload a Resume/CV. You will be able to upload up to 5 other documents in this section. You will be unable to edit your application, so please have all documents available before applying. Faculty Positions: If you need to upload more than 5 documents, please either combine them to upload or email the additional documents to the applicable contact in the job description. Staff positions: If you need to upload more than 5 documents, please either combine them to upload or email them to hr@fairfield.edu