Senior Data Engineer

Ciklum; United States; On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Healthcare

Language courses

Udemy access

Certifications

Job summary

Ciklum is seeking a Senior Data Engineer to design and optimize enterprise data pipelines and lakehouse solutions aligned with our cloud-first strategy. You will partner with cross‑functional teams to deliver secure, scalable data solutions enabling analytics, reporting, and AI capabilities.

The role requires 4+ years in data engineering, strong SQL, and hands-on AWS/Azure experience. You will build data models, governance‑aligned datasets, and support BI platforms while improving data quality

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 datalakehouse 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, pipelines, and storage across AWS and Azure.
• Monitor pipeline health and troubleshoot issues to ensure high availability.
• Support data integration initiatives including Data Lake, D365 ERP, and CRM/AMS.

Skills

SQL proficiency

ETL/ELT design

Cloud data engineering

Data modeling

Analytical skills

Communication skills

Education

Bachelor's degree

Tools

AWS

Azure

Databricks

Spark

Power BI

Azure Data Factory

Job description

About the role:

As a Senior Data Engineer, become a part of a cross-functional development team engineering experiences of tomorrow. Design, build, and optimize enterprise data pipelines and lakehouse solutions aligned to Client's data architecture, governance standards, and cloud-first strategy. Partner with cross-functional teams to deliver secure, scalable, and high-quality data solutions that enable analytics, reporting, and AI-driven capabilities.

Responsibilities:

• Design, develop, andmaintainscalable ETL/ELT pipelines across enterprise systems including ERP, CRM, and operational platforms
• Build and support ICC's cloud-based datalakehouse architecture (aligned to medallion layers and governance standards)
• Develop and maintaindata models, semantic layers, and curated datasets for analytics and business intelligence
• Translate business requirements into technical data solutions in collaboration with product, engineering, and business stakeholders
• Ensure data quality, integrity, and security in alignment with ICC data governance and compliance standards
• OptimizeSQL queries, data pipelines, and storage performance across AWS and Azure platforms
• Support data integration initiatives including Data Lake, D365 ERP, and CRM/AMS platforms
• Monitor pipeline health, troubleshoot issues, and ensure high availability and reliability of data systems
• Contribute to continuous improvement of data architecture, standards, and best practices
• Support AI and analytics initiatives by enabling high-quality, accessible data for downstream consumption
• Ability to establish positive working relationships with multiple disciplines of Information technology department & staff levels
• Demonstrated ability to collaborate and receive feedback regarding ongoing projects
• Demonstrated ability to respond to business issues with the appropriate sense of urgency
• Sense of when to escape a problem or ask for assistance

Requirements:

• 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

Desirable:

• Experience with medallion/lakehouse architecture patterns
• Experience working in multi‑cloud environments (AWS and Azure)
• Experience with Databricks, Spark, or Azure Fabric
• Experience with Power BI or enterprise reporting platforms
• Familiarity with AI/ML data enablement and tools (e.g., AWS Bedrock, RAG concepts)
• Experience with Git, Azure DevOps, and CI/CD practices
• Understanding of Agile methodologies and SDLC

What’s in it for you?

• Strong community: Work alongside top professionals in a friendly, open‑door environment
• Growth focus: Take on large‑scale projects with a global impact and expand your expertise
• Tailored learning: Boost your skills with internal events (meetups, conferences, workshops), Udemy access, language courses, and company‑paid certifications
• Endless opportunities: Explore diverse domains through internal mobility, finding the best fit to gain hands‑on experience with cutting‑edge technologies
• Care: Healthcare, Basic Life Insurance, Short and Long‑term disability insurance according to the Company's Benefit Plans

About us:

At Ciklum, we are always exploring innovations, empowering each other to achieve more, and engineering solutions that matter. With us, you’ll work with cutting‑edge technologies, contribute to impactful projects, and be part of a One Team culture that values collaboration and progress. In the US, Ciklum is growing fast - inviting experienced professionals to lead digital transformation alongside Fortune 500 clients. Be part of a company where innovation and impact go hand in hand.

Explore, empower, engineer with Ciklum!

Interested already? We would love to get to know you! Submit your application. Can't wait to see you at Ciklum.