Data Consultant

We are seeking a Data Consultant  to join a high-impact project for a based 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 ( / 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 optimize 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: or dbt (Data Build Tool)
• Experience building ETL/ELT pipelines and data migration solutions.
• Knowledge of data modeling techniques Data Vault / Kimball (dimensional modeling)
• 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 is a plus).

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 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 (ADF) Azure Functions Event-driven architecture

• Workflow & Automation Tools: CI/CD pipelines version control (Git) DevOps practices

• Data Modeling & Warehousing: Dimensional modeling 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º 900.955.679-3 / N 900.594.521-9  with an address at Street 96 No. 10 38 floor 7th in the city of Bogotá and Career 48 No. 18A 14 Floor 19 with telephone number (571)(hereinafter referred as ENDAVA or the Organization) as RESPONSIBLE for the processing of personal information informs:

Keep in mind that once you decide to participate in ENDAVA COLOMBIAs recruitment processes the physical delivery or sending via e-mail your resume implies the express acceptance through conclusive behavior of authorizing ENDAVA to process your data with the purpose to participate in the recruitment processes in the Organization. In particular the personal data provided shall be part of our Talent Bank for a maximum term of two (2) years which shall be stored on servers located outside the country and may be processed for the purpose of; verifying compliance with the requirements to participate in the Organizations current and/or future recruitment processes; execute interviews and in general send notifications related to the recruitment case your resume is not pre-selected it shall be permanently deleted. ENDAVA guarantees that the personal data obtained shall be used only for the announced purposes and shall be kept for the time required by law.

You and every personal information owner have the right to: know update and rectify your personal data; access to it free of charge; to be informed about its use; request proof of authorization; file complaints for violations of the provisions of current regulations before the Superintendence of Industry and Commerce. Finally in some applicable cases modify and revoke the consent given and/or request the deletion of your personal information.

For any additional information related to the processing of your personal data our Personal Information Processing Policy and/or exercising of your right to the habeas data you can contact us through the service channel provided by ENDAVA: .

At Endava were 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 perspectivesbecause 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.

Remote Work :

No

Employment Type :

Full-time