Senior Data Engineer

Ciklum•United States,

14d•Onsite

About The Position

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.

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

Nice To Haves

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

Responsibilities

Design, develop, and maintain scalable ETL/ELT pipelines across enterprise systems including ERP, CRM, and operational platforms
Build and support ICC’s cloud-based data lakehouse architecture (aligned to medallion layers and governance standards)
Develop and maintain data 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
Optimize SQL 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 escalate a problem or ask for assistance