Design, build, and optimize enterprise ETL/ELT pipelines, cloud data lakes, lakehouse solutions, data models, and semantic layers across AWS and Azure. Ensure data quality, security, performance, reliability, and governance while supporting analytics, reporting, and AI initiatives. Collaborate with product, engineering, IT, and business stakeholders to translate requirements into scalable data solutions, monitor pipeline health, troubleshoot issues, and improve data architecture and practices.
Ciklum is looking for a Senior Data Engineer to join our team full-time in the US .
We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.
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, 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
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. We can’t wait to see you at Ciklum.
#LI-HD1
Similar Jobs
.png)
Fintech • Insurance • Machine Learning • Analytics • Financial Services • Automation
Build and maintain production data pipelines, Airflow DAGs, Snowflake infrastructure, and Data Vault 2.0 models. Ensure data quality, observability, security, governance, reliability, and cost efficiency through automated testing and CI/CD. Lead technical projects end-to-end, collaborate with stakeholders, and support SOX-relevant reporting while developing expertise in commercial insurance data and processes.
Top Skills:
Apache AirflowBigQueryCi/CdClaude CodeCursorData Vault 2.0PythonRedshiftSnowflakeSnowflake CortexSQL
Fintech • Financial Services
Designs and develops complex cloud-native data solutions, scalable batch and real-time pipelines, APIs, data models, and enterprise data platforms. Implements data governance, quality, lineage, security, observability, CI/CD, automated testing, and operational reporting capabilities. Collaborates with architects, product owners, analysts, governance, security, and platform teams on technology strategy and cloud modernization. Mentors engineers, leads technical design discussions, presents recommendations, and supports AI-ready data products and emerging development tools.
Top Skills:
Ai FoundryAlationApache AirflowApi ManagementAWSAzureAzure Ai SearchAzure Container AppsAzure Data FactoryAzure DatabricksAzure DevopsAzure FunctionsAzure OpenaiAzure PurviewAzure SqlAzure StorageBigQueryCi/CdCollibraCopilot StudioCosmos DbEltErwinETLEvent HubsGCPGitGit FlowGitGithub CopilotInformatica MdmInfosphereJavaMcpMicrosoft FabricPythonScalaSnowflakeSQLTrunk-Based Development
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Develop and automate tests for ETL pipelines, validating data records, content, metadata, and schema alignment. Integrate data tests into CI/CD workflows using GitHub Actions, and create release test suites to monitor performance and memory degradation. Analyze edge cases, investigate pipeline issues, and log defects while working with Databricks, Python, SQL, and ETL orchestration tools.
Top Skills:
AirflowAzure Data FactoryCi/CdDatabricksETLGithub ActionsPythonSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
