Lead Data Integration Engineer

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