Lead Data Engineer 2026- US, COL, UK

Aimpoint Digital; Atlanta (GA); Remote; USD 140,000 - 190,000; Full time

Job summary

Aimpoint Digital is a fully remote AI and data consultancy delivering end-to-end data platforms for diverse clients in a fully remote model across the US.

The Lead Data Engineer will translate business questions into scalable architectures, build ELT/ETL pipelines, and collaborate with analytics and ML teams. Travel is possible; no ML model development.

You will work with Snowflake, Databricks, dbt, and modern cloud tools to create AI-ready data platforms and semantic layers.

Qualifications

• Degree in Computer Science, Engineering, Mathematics, or equivalent experience.
• 5+ years building data pipelines and working with relational databases.
• Experience with cloud data warehouses (Databricks or Snowflake) and dbt.
• Strong communication and stakeholder management skills.
• Willingness to travel and work remotely.

Responsibilities

• Serve as a trusted data and AI advisor to clients across industries.
• Work independently within a small team on data engineering use-cases.
• Design and implement AI-optimized data platforms and pipelines.
• Build semantic and analytical layers for BI and AI tools.
• Collaborate with analytics, data science, and ML teams to productionize analytics.

Skills

Data architecture

SQL

Python

Spark

Cloud data platforms

ETL/ELT

Snowflake

Databricks

dbt Core/Cloud

Fivetran

CI/CD

Docker

Kubernetes

Data modeling

Stakeholder management

AI/ML collaboration

Travel willingness

Education

Degree in Computer Science, Engineering, Mathematics, or equivalent

Tools

Snowflake

Databricks

dbt Core/Cloud

Fivetran

Matillion/Informatica/Talend

Docker

Kubernetes

Job description

Do you enjoy working with clients from different industries to investigate complex business problems and to design end-to-end analytical solutions that will improve their existing processes and ability to derive data-driven insights?

Aimpoint Digital is a dynamic and fully remote AI and Data consultancy. We work alongside the most innovative software providers in the data engineering space to solve our clients' toughest business problems. At Aimpoint Digital, we believe in blending modern tools and techniques with tried-and-true principles to deliver optimal data engineering solutions.

You will:

• Become a trusted data and AI advisor to our clients, from data owners and analytic users to executive stake holders helping them translate business questions into AI-ready data architectures
• Work independently as part of a small team to solve complex data engineering use-cases across a variety of industries
• Design and implement AI-optimized data platforms, including cloud data warehouses, lakehouses, ETL/ELT pipelines, orchestration jobs, and analytic layers that support LLM-driven analytics, natural language querying, and agent-based workflows
• Build and evolve semantic and analytical layers that power tools like Snowflake Cortex, Databricks Genie, BI platforms, and emerging AI Copilots
• Use modern platforms and tooling such as Snowflake, Databricks, dbt, Fivetran, and cloud-native orchestration frameworks to deliver scalable solutions, and credentialize your skills with certifications
• Engineer modern ELT/ETL pipelines that handle structured, semi-structured, and unstructured data to support AI and analytics use-cases
• Design modern data models with an emphasis on metrics layers, knowledge graphs, and semantic consistency for AI consumption
• Write production-ready code in SQL, Python, and Spark, following software engineering tools and best-practices such as Git and CI/CD
• Apply AI-assisted data engineering techniques for data exploration, quality checks, schema generation, documentation, lineage, and transformation acceleration
• Contribute to the evolution of our AI-forward data engineering and infrastructure practice, including internal accelerators, patterns, and client-ready architectures
• Collaborate with analytics, data science, and ML project teams to productionize AI-enabled analytics, features, and inference pipelines. Note: You will not be developing machine learning models or algorithms

Who you are:

We are building a diverse team of talented and motivated people who deeply understand business problems and enjoy solving them. You are a self-starter who loves working with data to build analytical tools that business users can leverage daily to do their jobs better. You are passionate about contributing to a growing team and establishing best practices.

As a Lead Data Engineer, you will be expected to work independently on client engagements or to lead small team project delivery, take part in the development of our practice, aid in business development, and contribute innovative ideas and initiatives to our company.

• Degree educated in Computer Science, Engineering, Mathematics, or equivalent experience
• Experience with managing stakeholders and collaborating with customers
• Strong written and verbal communication skills required
• 5+ years working with relational databases and query languages
• 5+ years building data pipelines in production and ability to work across structured, semi-structured and unstructured data
• 5+ years data modeling (e.g. star schema, entity-relationship, data vault)
• 5+ years writing clean, maintainable, and robust code in Python, Scala, Java, or similar coding languages
• 5+ years’ experience with dbt Core/Cloud preferred
• Experience enabling or accelerating data platform engineering workflows with AI tools such as Codex, Claude, Copilot, Snowflake Cortex Code, and/or Databricks Genie Code preferred
• Ability to manage an individual workstream independently and ability to manage a small 1-2 person team
• Expertise in software engineering concepts and best practices
• DevOps experience required
• Experience working with cloud data warehouses (Databricks or Snowflake required)
• 1 or more certifications in either Databricks or Snowflake strongly preferred
• Experience working with cloud ETL/ELT tools (Fivetran, dbt, Matillion, Informatica, Talend, etc.)preferred
• Experience working with cloud platforms (AWS, Azure, GCP) and container technologies (Docker, Kubernetes) preferred
• Experience working with Apache Spark preferredExperience preparing data for analytics and following a data science workflow to drive business results preferred
• Consulting experience strongly preferred
• Willingness to travel

This position is fully-remote within the US and COL; Atlanta-based applicants will have the opportunity to work in our headquarters in Sandy Springs, GA or our offices in London and Medellin.