22 days ago
Remote, Colombia or Bogotá, ColombiaSenior
Responsibilities
- Develop and maintain secure, efficient data pipelines using dbt, PySpark, and Python.
- Build ETL infrastructure and tooling with Python, dbt, Terraform, and AWS services.
- Create and maintain data models, semantic views, and ontology layers for partner teams.
- Implement process improvements and data quality testing.
- Monitor pipelines and maintain 99.5% uptime.
- Develop and deploy AI agents using Snowflake Cortex Analyst and Cortex Search for HR use cases.
- Configure and maintain Model Context Protocol connections between Snowflake and internal AI tooling.
- Perform REST API integrations, data ingestion, BigQuery optimization, and highly optimized SQL query development.
Requirements
- 5+ years of experience.
- Strong knowledge of data modeling, data marts, and data warehouse design.
- Strong knowledge of dbt for data transformations.
- Strong knowledge of Python, including object-oriented programming and data scripting.
- Strong knowledge of REST API integration and data ingestion.
- Strong knowledge of Google BigQuery querying and optimization.
- Strong SQL and highly optimized query development skills.
- Solid understanding of programming concepts, software design, and software development principles.
- Ability to work with minimal supervision, manage assigned tasks, collaborate with others, and make informed decisions.
Benefits
- Remote work arrangement.
- Full-time position.
- Base salary, bonuses, incentives, and benefits are discussed during the recruitment process; the posting does not provide a numeric salary amount.
About Capgemini
Capgemini is a global IT services and consulting firm that delivers strategy, cloud, AI, software engineering, and managed services to large enterprises and public-sector clients. Founded in 1967 and headquartered in Paris, it is publicly traded on Euronext Paris and operates in 50+ countries. The group expanded its engineering capabilities by acquiring Altran in 2020, now operating as Capgemini Engineering.