Fast Facts

We're seeking a Senior ETL Developer to design and maintain high-performance ETL pipelines while ensuring data integrity and optimization within a university setting.

Responsibilities: Key responsibilities include developing ETL frameworks, optimizing data workflows, implementing security practices, and collaborating with various institutional departments to define data ingestion rules.

Skills: Required skills include proficiency in SQL, data modeling, data security, cloud platforms (AWS, Azure, GCP), and experience with DevOps practices and ETL automation.

Qualifications: Candidates should have 5+ years of experience in data engineering and ETL development, with 2+ years in a lead role, along with strong skills in cloud data warehousing and ETL tools like Informatica or AWS Glue.

Location: Fairfield, Connecticut, USA

Compensation: Not provided by employer. Typical compensation ranges for this position are between $100,000 - $130,000.

Essential Functions

ETL Framework Development & Management

• Design, develop, and maintain high-performance ETL pipeline
• 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.
• 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.
• 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.