Senior ETL Developer
Company | Fairfield University |
---|---|
Location | Fairfield, CT, USA |
Salary | $Not Provided – $Not Provided |
Type | Full-Time |
Degrees | Bachelor’s |
Experience Level | Senior |
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.
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.
Preferred Qualifications
- Hands-on experience in ETL tools such as Informatica (preferred), Talend, or AWS Glue.
- Knowledge of AWS, Azure, or GCP cloud environments.
- Experience with Python, Shell scripting, and automation tools.