Data Engineer

The Data Engineer, Data Platform will build and operate the data capabilities that help AHEAD teams access trusted, usable, and well-managed information. This role will develop ingestion pipelines, transformations, data models, and curated data products in the modern cloud data platform, with an emphasis on Snowflake and dbt.

The role will support data coming from enterprise applications and services, including Salesforce, Hatch, NetSuite, Signal, and approved APIs. The Data Engineer will help make data available for analytics, applications, automation, and AI-enabled workflows through consistent engineering patterns,documented definitions, appropriate access controls, and dependable operational practices. Active use of AI throughout the software development lifecycle is a core expectation of this role, including AI-assisted code generation, automated testing, documentation, troubleshooting, and review with appropriate human validation.

Working under the Director, Data Platform and alongside the Data Governance Lead, this role will contribute to a product-oriented engineering team. The role will partner with data consumers and other engineering teams to understand requirements, deliver useful platform capabilities, and improve the speed and consistency of data delivery.

Duties/Responsibilities

- Build, maintain, and improve batch and low-latency data ingestion pipelines from enterprise systems, APIs, and other approved sources.

- Follow the AI SDLC by actively using approved AI coding tools and agents to generate, refactor, explain, and review code; validate generated output through engineering judgment, testing, and peer review.

- Use AI to generate and improve unit, integration, data-quality, and regression tests, then verify that automated tests accurately validate the intended behavior.

- Use AI-assisted workflows to create and maintain technical documentation, data-product documentation, runbooks, lineage notes, and change summaries as part of delivery.

- Build toward coordinated multi-agent delivery patterns that can divide and accelerate discovery, implementation, testing, documentation, and operational support while preserving human accountability.

- Develop SQL and Python solutions that collect, validate, transform, and publish data for downstream consumption.

- Use Snowflake and dbt to implement reliable transformations, reusable models, curated datasets, and data products across raw, common, and curated layers.

- Translate business and technical requirements into source mappings, data models, acceptance criteria, and maintainable engineering solutions.

- Partner with analytics, application, AI, Integration Platform, and business teams to make data available through governed and documented access patterns.

- Apply data quality checks for completeness, freshness, uniqueness, consistency, referential integrity, and other relevant quality dimensions.

- Add metadata, documentation, lineage, ownership, and usage guidance to data products so consumers can find and understand the data they use.

- Implement secure access patterns in partnership with Data Governance and Security teams, including role-based access, classification tags, masking, and row- or column-level controls when appropriate.

- Build automated tests and deployment processes that support consistent delivery through development, quality assurance, and production environments.

- Monitor pipeline health, data freshness, processing performance, and failures; troubleshoot issues and participate in incident resolution.

- Optimize Snowflake workloads, queries, transformations, and storage patterns for performance, reliability, and cost discipline.

- Support the curation and publication of cross-system data needed for shared business context, entity-aware access, reporting, automation, and AI use cases.

- Work with the Integration Platform and semantic-layer capabilities, including Horizon, to support consistent business meanin