ETL Developer

## About ITGOALS
ITGoals is a technology and software delivery company supporting enterprise organizations through software engineering, integration, data, digital transformation, and specialized technology services. We work on complex enterprise environments where quality, scalability, security, and reliable delivery are critical. Our teams collaborate across technical and business functions to build and support solutions designed for real operational impact.

## Job Title
ETL Developer

## Location
Remote / flexible; global delivery model with potential on-site requirements as needed

## Overview
ITGoals is seeking a results-driven ETL Developer with 1-3 years of professional experience to join our technology delivery team. The ETL Developer will be responsible for developing, maintaining, and supporting data integration and transformation processes across enterprise systems. The role involves working with multiple data sources, building reliable ETL pipelines, transforming and validating data, troubleshooting data issues, and supporting data warehouse and reporting requirements. The ideal candidate will have strong SQL fundamentals, practical ETL experience, and a solid understanding of data integration concepts.

## Key Responsibilities
- Design, develop, and maintain ETL processes for extracting, transforming, and loading data across different systems.
- Build and support reliable data pipelines based on business and technical requirements.
- Develop complex SQL queries, stored procedures, views, and data transformation logic.
- Integrate data from relational databases, files, APIs, and other enterprise data sources.
- Perform data validation, reconciliation, cleansing, and quality checks.
- Monitor ETL jobs and investigate failed or incomplete data loads.
- Troubleshoot performance, data integrity, and transformation issues.
- Support data warehouse, reporting, analytics, and downstream application requirements.
- Optimize ETL processes and SQL queries for performance and scalability.
- Maintain technical documentation covering data flows, mappings, transformations, and dependencies.
- Work closely with data engineers, developers, analysts, and business teams.
- Participate in testing, deployment, production support, and issue resolution.
- Follow development, version-control, and change-management standards.

## Required Experience and Skills
- 1-3 years of professional experience in ETL development, data integration, or data engineering.
- Hands-on experience building and supporting ETL processes.
- Strong working knowledge of SQL.
- Experience working with relational databases.
- Understanding of data transformation, mapping, validation, and reconciliation.
- Experience troubleshooting data and ETL processing issues.
- Understanding of data warehousing and database concepts.

## What You’ll Do to Succeed
- Deliver reliable and scalable ETL solutions aligned with business requirements.
- Collaborate with cross-functional teams to ensure data integrity and timely data availability.
- Continuously improve performance and reliability of ETL jobs and data pipelines.
- Maintain clear, comprehensive technical documentation and data dictionaries.
- Adapt to evolving data sources, transformation rules, and reporting needs.

## Why ITGOALS
- Opportunity to contribute to enterprise-scale software delivery and data integration projects.
- Collaborative environment with engineering, data, analytics, and business teams.
- Exposure to diverse data ecosystems, reporting needs, and production support in enterprise contexts.
- A culture focused on quality, security, and reliable delivery.

If you are driven by building effective data integration solutions and have a solid foundation in SQL and ETL concepts, we’d like to hear from you.