Lead Data Engineer

Aimpoint Digital

United States

Remote

USD 140,000 - 210,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Aimpoint Digital is seeking an experienced data and AI advisor to help clients translate business questions into AI-ready data architectures and scalable data platforms. You will lead small project teams and design AI-optimized data solutions across industries.

You will collaborate with analytics, data science, and ML teams to productionize AI-enabled analytics, build robust data pipelines, and advance internal accelerators and architectures. Travel may be required for client engagements.

Qualifications

  • Degree in CS, engineering, mathematics, or equivalent.
  • 5+ years with relational databases and SQL.
  • 5+ years building production data pipelines across structured, semi-structured, and unstructured data.
  • 5+ years data modeling (star schema, ER, or data vault).
  • 5+ years coding in Python, Scala, Java, or similar.
  • Experience leading small project teams (1–2 people).
  • DevOps experience required.

Responsibilities

  • Act as a trusted data and AI advisor to clients and stakeholders.
  • Translate business questions into AI-ready data architectures.
  • Independently solve complex data engineering use cases or lead small project teams.
  • Design and implement AI-optimized data platforms (data warehouses/lakehouses).
  • Build semantic and analytical layers for Snowflake Cortex, Databricks Genie, BI platforms, and AI copilots.
  • Use Snowflake, Databricks, dbt, Fivetran, and cloud-native orchestration frameworks.
  • Engineer ELT/ETL pipelines for structured, semi-structured, and unstructured data.
  • Collaborate with analytics, data science, and ML teams to productionize AI-enabled analytics.
  • Contribute to practice development, accelerators, and reference architectures.

Skills

Data engineering
Stakeholder management
SQL
Python
Spark
Git & CI/CD
Communication
Consulting
Travel willingness

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or equivalent

Tools

Snowflake
Databricks
dbt
Fivetran
Airflow
Docker
Kubernetes

Job description

  • Act as a trusted data and AI advisor to clients, from data owners and analytics users to executive stakeholders
  • Translate business questions into AI-ready data architectures
  • Independently solve complex data engineering use cases across industries or lead small project teams
  • Design and implement AI-optimized data platforms, including cloud data warehouses, lakehouses, ETL/ELT pipelines, orchestration jobs, and analytical layers
  • Build and evolve semantic and analytical layers for Snowflake Cortex, Databricks Genie, BI platforms, and AI copilots
  • Use Snowflake, Databricks, dbt, Fivetran, and cloud-native orchestration frameworks to deliver scalable solutions
  • Engineer ELT/ETL pipelines for structured, semi-structured, and unstructured data
  • Design data models emphasizing metrics layers, knowledge graphs, and semantic consistency
  • Write production-ready SQL, Python, and Spark code using Git and CI/CD best practices
  • Apply AI-assisted techniques for data exploration, quality checks, schema generation, documentation, lineage, and transformation acceleration
  • Contribute to the AI-forward data engineering and infrastructure practice, including internal accelerators, patterns, and client-ready architectures
  • Collaborate with analytics, data science, and ML teams to productionize AI-enabled analytics, features, and inference pipelines
  • Participate in practice development, business development, and innovative company initiatives
  • Note: The role does not involve developing machine learning models or algorithms
  • Degree educated in Computer Science, Engineering, Mathematics, or equivalent experience
  • Experience managing stakeholders and collaborating with customers
  • Strong written and verbal communication skills
  • 5+ years working with relational databases and query languages
  • 5+ years building production data pipelines across structured, semi-structured, and unstructured data
  • 5+ years of data modeling, such as star schema, entity-relationship, or data vault
  • 5+ years writing clean, maintainable, and robust code in Python, Scala, Java, or similar 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 independently manage a workstream and manage a small 1–2 person team
  • Expertise in software engineering concepts and best practices
  • DevOps experience required
  • Experience with cloud data warehouses; Databricks or Snowflake required
  • One or more Databricks or Snowflake certifications strongly preferred
  • Experience with cloud ETL/ELT tools such as Fivetran, dbt, Matillion, Informatica, or Talend preferred
  • Experience with cloud platforms such as AWS, Azure, or GCP and container technologies such as Docker or Kubernetes preferred
  • Experience with Apache Spark preferred
  • Experience preparing data for analytics and following a data science workflow preferred
  • Consulting experience strongly preferred
  • Willingness to travel
  • Fully remote work within the US and Colombia
  • Opportunity for Atlanta-based applicants to work in the headquarters in Sandy Springs, Georgia or offices in London and Medellín
  • Professional certifications supported/encouraged
  • Opportunity to contribute to internal accelerators, patterns, and client-ready architectures
  • Opportunity to lead small-team project delivery and contribute to practice development
  • Willingness to travel
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer 2026- US
Lead Data Engineer 2026- US

Aimpoint Digital • United States

Remote
USD 140,000 - 190,000
Senior Data Engineer 2026 - US
Senior Data Engineer 2026 - US

Aimpoint Digital • United States

Remote
USD 140,000 - 190,000
Lead Data Engineer 2026- US, COL, UK
Lead Data Engineer 2026- US, COL, UK

Aimpoint Digital • Atlanta (GA)

Remote
USD 140,000 - 190,000
Senior Data Engineer 2026 - US
Senior Data Engineer 2026 - US

Aimpoint Digital • Atlanta (GA)

Remote
USD 140,000 - 190,000
Sr Data Engineer
Sr Data Engineer

Cox Automotive • Atlanta (GA)

On-site
USD 140,000 - 190,000
Senior Data Engineer (Snowflake)
Senior Data Engineer (Snowflake)

factored • United States

Remote
USD 140,000 - 210,000
Equity participation
Paid time off
Annual retreat
+4
Sr Data Engineer
Sr Data Engineer

FlexStaf IT • Irvine (CA)

Hybrid
USD 120,000 - 190,000
Senior Data Engineer
Senior Data Engineer

RBA, Inc. • United States

On-site
USD 120,000 - 190,000
Data Engineer
Data Engineer

Collectivus Holdings • United States

Remote
USD 100,000 - 150,000
Manager, Analytics & Solutions Architecture
Manager, Analytics & Solutions Architecture

Remote • San Francisco (CA)

Remote
USD 180,000 - 240,000
Fully remote work