Senior Data Engineer: Cloud Data Lakehouse & ETL Pipelines

Description Ciklum; United States; On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Healthcare

Life Insurance

Short and Long-term disability

Udemy access

Language courses

Company-paid certifications

Job summary

Ciklum is seeking a Senior Data Engineer to design, build, and optimize enterprise data pipelines and lakehouse solutions in a cloud-first environment. You will partner with cross-functional teams to enable analytics, reporting, and AI-driven capabilities.

You will work across ERP, CRM, and operational platforms, ensuring data quality, security, and scalable data solutions aligned with governance standards. This role offers growth within a global, fast-growing team in the United States.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 4+ years of experience in data engineering or data platform development.
• Strong experience designing and building ETL/ELT pipelines in cloud environments.
• Hands-on experience with AWS (S3, Redshift, Glue, DMS) and Azure (Data Factory, SSIS).
• Strong proficiency in SQL and relational database design.
• Solid understanding of data warehousing, data lakes, and lakehouse architecture.
• Experience with structured, semi-structured, and unstructured data processing.
• Experience with data modeling, data quality, and performance optimization.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines across enterprise systems.
• Build and support cloud-based data lakehouse architecture with governance standards.
• Develop and maintain data models, semantic layers, and curated datasets for analytics.
• Translate business requirements into technical data solutions with stakeholders.
• Ensure data quality, integrity, and security per governance standards.
• Optimize SQL queries and pipelines for performance on AWS and Azure.
• Support data integration initiatives including Data Lake, D365 ERP, and CRM/AMS.
• Monitor pipeline health and troubleshoot to ensure high availability.
• Contribute to improvements in data architecture and best practices.
• Support AI and analytics initiatives by providing accessible data.

Skills

ETL/ELT pipelines design

AWS

Azure

SQL

Data warehousing

Lakehouse architecture

Data modeling

Data governance

Analytics/BI

Education

Bachelor's degree in Computer Science or related field

Tools

Databricks

Spark

Azure Data Factory

Git

Azure DevOps

Job description

Ciklum is seeking a Senior Data Engineer to design, build, and optimize enterprise data pipelines and lakehouse solutions in a cloud-first environment. You will partner with cross-functional teams to enable analytics, reporting, and AI-driven capabilities.

You will work across ERP, CRM, and operational platforms, ensuring data quality, security, and scalable data solutions aligned with governance standards. This role offers growth within a global, fast-growing team in the United States.