**DESCRIPTION**:
Join our team as a remote **Data Integration Engineer **at EPAM!
We're seeking a highly skilled professional with expertise in migrating, building, and maintaining data pipelines, optimizing data workflows, and ensuring the reliability of our data infrastructure.
In this role, you'll lead the Data and Platform migration from GCP BigQuery into AWS Redshift.
If you're ready to make a significant impact, we'd love to hear from you.
EPAM is a leading global provider of digital platform engineering and development services. We are committed to having a positive impact on our customers, our employees, and our communities. We embrace a dynamic and inclusive culture. Here you will collaborate with multi-national teams, contribute to a myriad of innovative projects that deliver the most creative and cutting-edge solutions, and have an opportunity to continuously learn and grow. No matter where you are located, you will join a dedicated, creative, and diverse community that will help you discover your fullest potential.
RESPONSIBILITIES
- Migrating current data pipelines and DAGs from GCP BigQuery stored procedures into AWS Redshift
- Performing necessary data backfills and validating the quality and integrity during and post-migration
- Designing, developing, and maintaining data pipelines using AWS services such as Amazon Redshift, Amazon S3, dbt, and Apache Airflow
- Utilizing SQL and ETL/ELT solutions to transform and load data from various sources into data warehouses and data lakes
- Optimizing data workflows and processes to ensure efficiency, scalability, and reliability
**REQUIREMENTS**:
- Prepared to adjust your work schedule to ensure a 1-hour overlap with the client team based in Seattle, WA
- Comfortable communicating daily tasks with the English-speaking engineering team on the client side
- Advanced SQL, PLSQL, TSQL for data transformation and optimization




- Experience with writing ETL/ELT code, managing, and deploying DAGs using dbt or Airflow
- Hands-on experience working with AWS Redshift, or similar Cloud EDW systems
NICE TO HAVE
- Familiarity with Google Cloud Platform (GCP) and Google Cloud BigQuery for data storage and analytics
- Knowledge of AWS migration tools for transitioning data and workloads from Google Cloud Platform to AWS
- Experience with analytics and data assessment techniques to evaluate data quality, integrity, and usability
TECHNOLOGIES
- AWS Redshift
- Amazon S3
- dbt
- Apache Airflow
- SQL, PLSQL, TSQL
WE OFFER
- Career plan and real growth opportunities
- Unlimited access to LinkedIn learning solutions
- International Mobility Plan within 25 countries
- Constant training, mentoring, online corporate courses, eLearning and more
- English classes with a certified teacher
- Support for employee’s initiatives (Algorithms club, toastmasters, agile club and more)
- Enjoyable working environment (Gaming room, napping area, amenities, events, sport teams and more)
- Versátil work schedule and dress code
- Collaborate in a multicultural environment and share best practices from around the globe
- Hired directly by EPAM & 100% under payroll
- Law benefits (IMSS, INFONAVIT, 25% vacation bonus)
- Major medical expenses insurance: Life, Major medical expenses with dental & visual coverage (for the employee and direct family members)
- 13 % employee savings fund, capped to the law limit
- Grocery coupons
- 30 days December bonus
- Employee Stock Purchase Plan
- 12 vacations days plus 4 floating days
- Official Mexican holidays, plus 5 extra holidays (Maundry Thursday and Friday, November 2nd, December 24th & 31st)
- Relocation bonus: transportation, 2 weeks of accommodation for you and your family and more
- Monthly non-taxable amount for the electricity and internet bills
CONDITIONS

📌 Data Integration Engineer (México)
🏢 Epam Systems
📍 México