Data Consultant

Company Description

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

Our data team has expertise across engineering, analysis, architecture, modeling, machine learning, artificial intelligence, and data science. This discipline is responsible for transforming raw data into actionable insights, building robust data infrastructures, and enabling data-driven decision-making and innovation through advanced analytics and predictive modeling. 

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.

Responsibilities:

• Lead the development of solution architectures for data migration and integration.
• Design the architecture for data pipelines and implement using Apache Airflow (or Astronomer) as the primary orchestration tool.
• Collaborate with the Data Architect to create and maintain source-to-target mapping documentation.
• Identify, document, and implement measures to visualize and track data quality across pipelines.
• Drive end-to-end data migration projects between systems hosted in different environments (on-premises, AWS, Azure, etc.).
• Participate in Agile ceremonies, define task sizes, and set clear deliverables.
• Prepare detailed technical plans and coordinate resources within change programs.
• Advise on technical aspects of solution development, ensuring correct application of strategies, policies, standards, and security best practices.

Qualifications

• 8+ years of experience in designing, developing, and managing data solutions, with at least 3 end-to-end data migration projects from SQL Server to Cloud (Snowflake, Azure, AWS, or GCP).
• Proven track record leading data migration projects from planning and initial analysis through execution, validation, and production deployment.
• 3+ years of hands-on Snowflake experience, including architecture, development, and optimization.
• Strong understanding of data modeling techniques (3NF, dimensional modeling, Data Vault).
• Extensive experience designing and optimizing data pipelines, ETL/ELT processes, and both batch and streaming data processing.
• 5+ years of experience with one or more data platforms (e.g., Oracle, SQL Server).
• Proficiency in Python, SQL, and Microsoft SSIS; Scala is a plus.
• Knowledge and experience in Cloud technologies (Azure, AWS, or GCP), including orchestration tools such as Airflow.
• SnowPro Core and SnowPro Advanced Architect certifications are a strong plus.
• Experience managing multidisciplinary teams, setting priorities and deliverables, and reporting progress to executive stakeholders.
• Excellent communication skills in advanced English (oral and written).

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, 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) 3905061, (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 COLOMBIA's 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 Organization's current and/or future recruitment processes; execute interviews and in general, send notifications related to the recruitment processes. In 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: protecciondatoscolombia@endava.com.

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.