Posted in

Senior ETL Developer

Senior ETL Developer

CompanyFairfield University
LocationFairfield, CT, USA
Salary$Not Provided – $Not Provided
TypeFull-Time
DegreesBachelor’s
Experience LevelSenior

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.