Lead Data Engineer 2026- US

Aimpoint Digital

$120K — $145K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor’s degree in Computer Science, Engineering, Mathematics, or equivalent experience
  • 5+ years in relational databases and query languages
  • 5+ years building data pipelines with structured, semi-structured, and unstructured data
  • 5+ years in data modeling with concepts like star schema and data vault
  • 5+ years writing maintainable code in Python or similar languages
  • Experience with dbt Core/Cloud and cloud data warehouses (Databricks or Snowflake)
  • Consulting experience strongly preferred

Responsibilities

  • Advise clients on translating business questions into AI-ready data architectures
  • Independently solve complex data engineering use cases across various industries
  • Design and implement AI-optimized data platforms and ETL/ELT pipelines
  • Build semantic and analytical layers supporting advanced analytics tools
  • Engineer modern ELT/ETL pipelines for diverse data types
  • Write production-ready code in SQL, Python, and Spark following best practices
  • Collaborate with teams to productionize AI-enabled analytics

Benefits

  • Remote work opportunity within the US
  • Potential for in-office work in Sandy Springs, GA for Atlanta applicants
  • Opportunities for career development and training in cutting-edge technologies
  • Collaborative team environment focused on best practices
  • Diverse team culture promoting inclusion and innovation
Full 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?

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 preferred
  • Experience preparing data for analytics and following a data science workflow to drive business results preferred
  • Consulting experience strongly preferred
  • Willingness to travel

We are actively seeking candidates for full-time, remote work within the US. Atlanta applicants will have the opportunity to work from headquarters in Sandy Springs, GA.

Similar Jobs

More Jobs at Aimpoint Digital

More Information Technology Jobs

Find similar Lead Data Engineer 2026- US jobs: