7 days ago
USA (city not specified)Senior
Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines across ERP, CRM, and operational systems.
- Build and support cloud-based data lakehouse architecture aligned with medallion layers and governance standards.
- Develop data models, semantic layers, and curated datasets for analytics and business intelligence.
- Translate business requirements into technical data solutions with product, engineering, and business stakeholders.
- Ensure data quality, integrity, security, and compliance with data governance standards.
- Optimize SQL queries, data pipelines, and storage performance across AWS and Azure.
- Support data integration initiatives involving data lakes, D365 ERP, and CRM/AMS platforms.
- Monitor pipeline health, troubleshoot issues, and maintain high availability and reliability of data systems.
- Contribute to data architecture, standards, best practices, and continuous improvement.
- Enable AI and analytics initiatives by providing high-quality, accessible downstream data.
- Collaborate effectively across multiple IT disciplines and respond appropriately to business issues and escalation needs.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- At least 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 services including S3, Redshift, Glue, and DMS, and Azure services including Data Factory and SSIS.
- Strong SQL proficiency and relational database design experience.
- Understanding of data warehousing, data lakes, and lakehouse architecture.
- Experience processing structured, semi-structured, and unstructured data.
- Experience with data modeling, data quality, and performance optimization.
- Strong analytical, problem-solving, communication, collaboration, and stakeholder-management skills.
- Desirable experience with medallion/lakehouse architecture, AWS and Azure multi-cloud environments, Databricks, Spark, Azure Fabric, Power BI, AI/ML data enablement, AWS Bedrock, RAG concepts, Git, Azure DevOps, and CI/CD practices.
- Understanding of Agile methodologies and SDLC.
Benefits
- Full-time role based in the US.
- Opportunities to work on large-scale, globally impactful projects and explore diverse domains through internal mobility.
- Internal learning events, meetups, conferences, workshops, Udemy access, language courses, and company-paid certifications.
- Healthcare, basic life insurance, and short- and long-term disability insurance according to company benefit plans.
- Collaborative, open-door environment with opportunities for professional growth.
Tech Stack
Categories
Data Engineering
About Ciklum
Ciklum is an IT services firm that builds custom digital products and provides nearshore engineering teams, QA, DevOps, data analytics, and UX for enterprises and high-growth startups. It operates a services model spanning product engineering, e-commerce solutions, and managed delivery centers. Founded in 2002 and headquartered in London, the privately held company serves global clients including Just Eat and Zurich Insurance.