> Markdown version of [/jobs/ext/1347414-senior-associate-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/1347414-senior-associate-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Associate - Analytics Engineer - **Company:** New York, Inc. - **Location:** New York, NY, United States - **Experience:** Expert - **Salary:** $124,000.0 - $177,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Business Logic, JIRA, Automation of Tests, BigQuery, Code Review, Continuous Integration, Information Engineering, Data Integrity, Data Transformation, Data Security, Digital Assets, Dimensional Modeling, Document-Oriented Databases, Graph Database, Python (Programming Language), PostgreSQL, Performance Tuning, Scrum Methodology, Systems Development Life Cycle, Cloud Services, SQL Databases, Systems Integration, Macros, Sql Optimization, Large Language Models, Snowflake, Git, Build Management, Data Management, Looker Analytics, Data Pipelines, Databricks - **Published:** July 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=b4413578cebf7d25 ## About the Role * 4+ years of progressive data engineering experience with a strong focus on analytics engineering and transformation pipeline development in production cloud environments. * Strong command of advanced SQL - window functions, CTEs, performance optimization, and complex multi-source joins - and solid Python proficiency for data engineering tasks. * Hands-on dbt experience: layered modeling, incremental models, source definitions, singular and generic tests, macros, and multi-environment project configuration. * Experience with cloud data platforms - Databricks and/or BigQuery required; experience with Snowflake or Redshift a plus. * Understanding of ELT patterns, dimensional modeling, and the design of scalable analytical data products with clear grain, ownership, and consumer contracts. * Proficiency with Git and collaborative development workflows: branching strategy, PR review, and CI/CD pipeline integration. * Experience working in Agile/Scrum delivery environments with structured sprint planning, backlog grooming, and milestone tracking. * Clear written and verbal communication skills - able to explain technical decisions, document data products, and engage effectively with both engineering and business stakeholders., * Exposure to semantic layer tooling - dbt Semantic Layer / MetricFlow, Looker LookML, or equivalent - and experience building metric definitions consumed by BI or AI systems. * Familiarity with agentic AI concepts and interest in applying LLM-assisted tooling to pipeline construction, data quality remediation, or transformation pattern generation. * Experience with data observability tooling (Monte Carlo, Anomalo, or dbt built-in monitoring patterns) and building self-monitoring pipeline patterns. * Exposure to graph data models, knowledge graphs, or context graph construction for AI or analytics use cases. * Experience with data catalog and lineage platforms (Dataplex, DataHub, Alation) and column-level governance tagging practices. * Insurance or financial services industry experience, with familiarity with data privacy standards and enterprise compliance requirements. ## Description The Senior Associate, Analytics Engineer is a practitioner who designs and implements scalable analytics engineering solutions with a high degree of independence. You lead your own workstreams end-to-end - from source alignment and data modeling through testing, deployment, and quality monitoring - engaging with the Analytics Engineering Lead and senior engineers for input on the most complex architectural decisions. You are technically strong, self-directed, and effective at translating business requirements into well-structured engineering work. You exercise independent judgment in selecting approaches and techniques, engage directly with business stakeholders to understand requirements, and provide input into team-level goals and delivery planning. You advise peers on data modeling and analytics engineering best practices, and actively contribute to improving the team's SDLC practices., * Lead, with support from the Analytics Engineering Lead, the design and implementation of scalable dbt transformation pipelines across Databricks, Postgres and Bigquery - covering layered modeling (staging / intermediate / mart), incremental strategies, and source contract definitions. * Design and build well-tested, documented data products - dimensional models, aggregates, and feature tables. * Develop solutions to complex data transformation problems using advanced SQL and Python, selecting the right approach based on evaluation, judgment, and the performance and maintainability requirements of the platform. * Optimize and tune transformation pipelines for performance, cost efficiency, and incremental processing at scale - independently identifying bottlenecks and driving improvements. * Own your data products end-to-end: source alignment, modeling, testing, documentation, deployment, and post-release monitoring, with awareness of downstream BI and AI/ML dependencies. Data Quality, Governance & SDLC * Lead, with support from senior engineers, the availability, usability, integrity, and security of data within your domain - ensuring data is consistent, trustworthy, and governed in accordance with enterprise standards. * Implement robust dbt test frameworks, source freshness checks, and data quality monitoring patterns that make pipeline health observable and failures diagnosable. * Apply governance standards at the analytics layer: column-level PII tagging, access control integration, and lineage documentation that supports the enterprise data catalog. * Lead efforts to improve SDLC practices within the team - contributing to and helping establish CI/CD pipelines, automated testing, branching conventions, and PR review standards. * Maintain data catalog entries for all owned assets: lineage, ownership, grain documentation, and business glossary alignment., * Develop and maintain reusable macro libraries and dbt modeling patterns that enforce consistency and accelerate delivery across the analytics engineering surface. * Participate in semantic layer development - building MetricFlow-based metric definitions that provide a governed, authoritative source of business logic decoupled from downstream consumption. * Contribute to self-healing pipeline patterns and agentic pipeline construction approaches - prototyping and implementing automated anomaly detection, quality remediation, and LLM-assisted transformation generation. * Support context graph construction that captures relationships between business entities and data assets, enabling richer AI reasoning and cross-domain signal integration. * Stay current with the dbt ecosystem, Databricks and BigQuery platform releases, and the broader analytics engineering field - bringing concrete, evaluated recommendations back to the team. Stakeholder Engagement & Collaboration * Engage directly with business stakeholders, data scientists, and ML engineers to understand data requirements - translating them into well-scoped Jira stories with clear acceptance criteria, grain definitions, and delivery estimates. * Partner with Integration Services on ingestion design to ensure source data arrives in shapes that are transformation-ready, correctly typed, and well-governed before reaching the analytics layer. * Collaborate with data stewards across NYL to resolve data quality issues at the source - driving shared accountability for data integrity rather than working around upstream problems. * Communicate technical decisions, modeling trade-offs, and delivery status clearly to the Analytics Engineering Lead and cross-functional partners, adapting style and depth for technical and non-technical audiences. * Advise junior engineers on data modeling approaches, dbt patterns, SQL craft, and analytics engineering best practices through code review and pair-modeling sessions. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)