Lead Data Integration Specialist

Role Summary

We are looking for an experienced Lead Data Integration Specialist to join our team.

The ideal candidate has at least 5 years of experience in data management, storage, modeling, analytics, migration, and database design. As a Tech Lead/Team Lead, you will design and implement innovative data integration solutions, contribute to cloud solution architecture, and lead a high-performing team to ensure best practices are followed. Your deep expertise in cloud environments, data warehousing solutions, and data security will help drive the success of our projects.

This position offers hybrid setup with the flexibility to work from any location in Latvia, whether it's your home or our office in Riga.

#LI-DNI#LI-DD1

Technologies - Cloud Platforms (AWS, Azure, GCP): Storage, Compute, Networking, Identity & Security, Data Warehousing (Redshift, Snowflake, BigQuery, Azure Synapse)

• Data Integration Tools (Azure Data Factory, AWS Glue, GCP Dataflow, Talend, Informatica, Apache NiFi, KNIME, SSIS, etc.)
• Programming Languages: SQL, Python, SparkSQL, PySpark, R, Bash, Scala
• Relational Databases (MS SQL Server, Oracle, MySQL, PostgreSQL)
• Dataflow orchestration, replication, and data preparation tools
• Version Control Systems (Git, SVN)
• Testing: Component, Integration Testing, and Data Reconciliation

Responsibilities - Lead a team of engineers, providing technical leadership and mentorship

• Design and implement data integration solutions, model databases, and build scalable data platforms
• Work with classic data technologies and modern cloud or hybrid data solutions
• Contribute to cloud solution architecture and serve as a role model for the team
• Collaborate with product and engineering teams to define technical requirements and drive architectural decisions
• Build partnerships with architects and stakeholders within the organization
• Perform detailed analysis of business problems and technical environments to design high-quality solutions
• Participate in code reviews and testing to ensure adherence to best practices
• Foster a high-performance engineering culture and provide technical guidance
• Write and maintain project documentation, including technical documentation and use cases

Requirements - 5+ years of experience in data management, storage, analytics, migration, and database design

• Proven ability to lead technical teams and mentor engineers
• Expert knowledge of cloud environments (AWS, Azure, GCP) and data warehousing solutions (Redshift, Azure Synapse Analytics, Google BigQuery, Snowflake)
• Experience with data integration tools (Azure Data Factory, AWS Glue, GCP Dataflow, Talend, Informatica, Apache NiFi, KNIME, SSIS)
• Strong understanding of relational databases (MS SQL Server, Oracle, MySQL, PostgreSQL) and production coding experience in SQL, Python, SparkSQL, PySpark, R, Bash, Scala
• Advanced knowledge of data security, data modeling, and data integration methodologies (OLAP, OLTP, ETL, DWH, Data Lake, Delta Lake, Data Mesh)
• Experience with integration patterns, CDC methods, micro-batching, delta extracts, and housekeeping processes
• Deep understanding of data lineage, metadata management, data traceability, and the ability to create high-quality design documentation
• Compliance awareness (PI, GDPR, HIPAA) and proficiency in English for professional communication
• Experience in direct customer communication and presenting technical solutions effectively

We offer - Engineering Heritage: Best-in-class experts sharing a culture of engineering excellence and tackling complex engineering challenges for over 30 years

• Advanced Tech Stack: Innovative projects where you can apply or enhance your expertise in Cloud, Data, AI, and other emerging technologies
• World-Class Clients: Work closely with 295+ of the Forbes Global 2000 on creating disruptive solutions that make a global impact
• Professional Growth: Exceptional support for career development with comprehensive resources for upskilling or reskilling in pioneering practices
• GenAI Community: Strong AI competencies with 600+ experts across 55+ locations driving GenAI-enabled transformation journeys
• Entrepreneurial Culture: If you're passionate and dedicated to improving business transformation, we provide the support you need to bring your ideas to life
• Hybrid Setup: The flexibility to work from any location in Latvia, whether it's your home or our office in Riga
• Other Benefits: Additional vacation and trust days, private health insurance, Employee Stock Purchase Plan and more

About EPAM

EPAM is a leading global provider of digital platform engineering and development services. For over 30 years, our team has helped leading brands navigate the waves of digital transformation, building solutions that help them stay competitive through constant market disruption.

With offices in 55+ countries, EPAM has grown in Latvia to over 888+ talented innovators in 3 years. We foster creativity and unconventional ways of doing things, welcoming like-minded professionals to join us.