Technology is our how. And people are our why. For over two decades, we have been harnessing technology to drive meaningful change. By combining world‑class engineering, industry expertise and a people‑centric mindset, we consult and partner with leading brands from various industries to create dynamic platforms and intelligent digital experiences that drive innovation and transform businesses. From prototype to real‑world impact – be part of a global shift by doing work that matters. Job Description We are seeking a Data Consultant to join a high‑impact project for a private debt investment client. The role focuses on designing and implementing scalable data pipelines, data models, and migration processes using Snowflake and modern data transformation tools (Coalesce.io / dbt). This position requires a high level of autonomy, ownership, and proactive mindset, working closely with business stakeholders to translate requirements into robust data solutions. As a Data Consultant at Endava you will focus on the technical implementation of various data projects, from designing and building DW solutions, to developing end‑to‑end migration frameworks or building data reporting systems. Key Responsibilities Design, build, and optimise data pipelines and transformations. Translate business requirements into technical data models and pipelines. Embed data quality rules and validation checks within pipelines and data models. Provide technical guidance on Snowflake, Coalesce, and Fivetran usage and trade‑offs. Ensure data governance, lineage, and metadata management using tools like Alation. Contribute to CI/CD processes, Azure DevOps, enabling automated deployments across environments. Define and enforce data engineering standards (naming conventions, metadata, tagging, DQ frameworks). Required Technical Skills Strong expertise in SQL (advanced level). Hands‑on experience with Snowflake . Experience with data transformation tools: Coalesce.io or dbt (Data Build Tool). Experience building ETL/ELT pipelines and data migration solutions. Knowledge of data modelling techniques Data Vault / Kimball (dimensional modelling). Experience working with CDC pipelines and large datasets (e.g., SQL Server CDC, ADF). Understanding of CI/CD practices in data engineering. Required Soft Skills Strong autonomy and self‑management (critical for success in this role). High level of initiative and proactivity. Excellent analytical and problem‑solving skills. Ability to translate business needs into technical solutions. Strong communication skills for stakeholder interaction. Nice to Have Experience in banking, asset management, or capital markets. Knowledge of data governance frameworks and enterprise data standards. Familiarity with data governance and lineage tools (e.g., Alation). Key Success Factors Ability to own and deliver data engineering solutions autonomously. Strong business understanding and requirement translation capability. Commitment to data quality, governance, and scalability. Experience working in a fast‑paced, high‑impact financial environment. Qualifications Programming Languages: Python, Scala, SQL Big Data Frameworks: Apache Spark, Databricks (including Delta Lake and Delta Tables) Cloud Platforms & Services: Microsoft Azure (Azure Data Factory, Azure Event Hub, Azure Functions) Data Engineering: Data pipelines, ETL/ELT design, batch and streaming data processing Data Storage & Management: Delta Tables, Azure Data Lake, Azure Blob Storage Orchestration & Integration: Azure Data Factory, Azure Functions, event‑driven architecture Workflow & Automation Tools: CI/CD pipelines, version control (Git), DevOps practices Data Modeling & Warehousing: Dimensional modelling, data lakes, lakehouse architectures Monitoring & Optimization: Performance tuning in Spark, job monitoring with Azure tools Collaboration Tools: Jira, Confluence, Agile/Scrum methodologies Additional Information Discover some of the global benefits that empower our people to become the best version of themselves: Finance: Competitive salary package, share plan, value‑based recognition awards, referral bonus. Career Development: Career coaching, global career opportunities, non‑linear career paths, internal development programmes for management and technical leadership. Learning Opportunities: Complex projects, rotations, internal tech communities, training, certifications, coaching, online learning platforms subscriptions, pass‑it‑on sessions, workshops, conferences. Work‑Life Balance: Hybrid work and flexible working hours, employee assistance programme. Health: Global internal wellbeing programme, access to wellbeing apps. Community: Global internal tech communities, hobby clubs and interest groups, inclusion and diversity programmes, events and celebrations. In compliance with the Law 1581 of 2012, Endava S.A.S. / Endava Colombia S.A.S, identified with NIT. Nº -3 / N° -9, with an address at Street 96 No. 10 – 38, floor 7 in the city of Bogotá and Career 48 No. 18A – 14 Floor 19, with telephone number ( , (hereinafter referred as “ENDAVA” or the “Organization”), as RESPONSIBLE for the processing of personal information informs: ... (legal text continued) At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives—because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know. #J-18808-Ljbffr