Logo for EPAM Systems

Lead Data Integration Engineer

Role overview

Qualifications

  • 5+ years of experience in Data Management, Storage, Analytics, Migration, and Database Design
  • Expert knowledge of Cloud environments (AWS, Azure, GCP)
  • Experience with data modeling, including OLAP, OLTP, ETL, DWH, Data Lake methodologies
  • Advanced knowledge of Data Security

Responsibilities

  • Lead a team of engineers, providing technical leadership and mentorship
  • Design and implement data integration solutions, model databases, and build scalable data platforms
  • Collaborate with product and engineering teams to define technical requirements
  • Participate in code reviews and testing to ensure adherence to best practices

Key facts

Hard skills

Key skills for this role

Other skills

  • Mentorship
  • Collaboration
  • Communication

About the company

EPAM Systems logo

EPAM Systems

  • IT Services & Consulting
  • XLarge
  • 10,001+
Since 1993, EPAM Systems, Inc. (NYSE: EPAM) has used its software engineering expertise to become a leading global provider of digital engineering, cloud and AI-enabled transformation services, and a leading business and experience consulting partner for global enterprises and ambitious startups. We address our clients’ transformation challenges by fusing EPAM Continuum’s integrated strategy, experience and technology consulting with our 30+ years of engineering execution to speed our clients’ time to market and drive greater value from their innovations and digital investments. We make GenAI real with our AI LLM orchestration, testing and engineering solutions, EPAM DIAL, EPAM EliteA™ and EPAM AI/RUN™, respectively. We deliver globally, but engage locally with our expert teams of consultants, architects, designers and engineers, making the future real for our clients, our partners and our people around the world. We believe the right solutions are the ones that improve people’s lives and fuel competitive advantage for our clients across diverse industries. Our thinking comes to life in the experiences, products and platforms we design and bring to market. Added to the S&P 500 and the Forbes Global 2000 in 2021 and recognized by Glassdoor and Newsweek as a Top 100 Best Workplace, our multidisciplinary teams serve customers across six continents. We are proud to be among the top 15 companies in Information Technology Services in the Fortune 1000 and to be recognized as a leader in the IDC MarketScapes for Worldwide Experience Build Services, Worldwide Experience Design Services and Worldwide Software Engineering Services. Learn more at www.epam.com.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

We are looking for an experienced Lead Data Integration Engineer 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. 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 tools (Databases, ETL/ELT, MDM tools, BI platforms) as well as implement modern Cloud or Hybrid data solutions Contribute to Cloud Solution Architecture, select the right toolset, and serve as a role model for the team Collaborate with product and engineering teams to define technical requirements, evaluate new features, and drive architectural decisions Build partnerships with architects and key 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, oversee team members, and provide technical guidance Write and maintain project documentation, including high-quality 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 experience with multiple cloud providers Deep expertise in cloud data warehousing solutions (Redshift, Azure Synapse Analytics, Google BigQuery, Snowflake, etc.) Experience designing and implementing Data Integration, Data Analytics & Visualization, and Cloud Migration solutions Expertise in Data Integration tools (Azure Data Factory, AWS Glue, GCP Dataflow, Talend, Informatica, Apache NiFi, KNIME, SSIS, etc.) Strong understanding of Relational Databases (MS SQL Server, Oracle, MySQL, PostgreSQL) and the ability to articulate the pros and cons of different solutions Production coding experience in one of the data-oriented programming languages (SQL, Python, SparkSQL, PySpark, R, Bash, Scala) Advanced knowledge of Data Security (Row-level security, auditing, etc.) Experience with data modeling, including OLAP, OLTP, ETL, DWH, Data Lake, Delta Lake, and Data Mesh methodologies Strong knowledge of integration patterns, CDC methods, micro-batching, and delta extracts General understanding of Housekeeping processes (logging, monitoring, exception management, archiving, retention policies, hot/cold data) Deep understanding of Data Lineage, Metadata Management, and Data Traceability concepts Ability to create high-quality design documentation and maintain audit records Compliance awareness (PI, GDPR, HIPAA) Experience in direct customer communication and ability to present technical solutions effectively Experience across various business domains English proficiency for professional communication 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

Related jobs

See all Data Platform Engineer jobs

Other jobs at EPAM Systems