> Markdown version of [/jobs/ext/3952646-senior-consultant-ai-data-engineering](https://www.wearedevelopers.com/jobs/ext/3952646-senior-consultant-ai-data-engineering). 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 Consultant, AI & Data Engineering

- **Company:** Castleton, Town of Inc
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Salary:** $250,000.0
- **Contract:** Permanent contract
- **Skills:** Artificial Intelligence, Airflow, Amazon Web Services, Microsoft Azure, Cloud Computing, Data as a Services, Information Engineering, Data Governance, Data Transformation, Data Warehousing, Python (Programming Language), NumPy, Query Optimization, Web Applications, Cloud Platform System, Snowflake, Apache Spark, Pandas, Data Lakes, Scikit Learn, Data Management, Data Pipelines, Databricks
- **Published:** October 27, 2026
- **Apply:** https://www.careerbuilder.com/job-details/senior-consultant-ai-data-engineering-new-york-ny--5a66c85e-675f-434b-8d22-0b61b8a99dd6

## About the Role

* 7+ years of hands-on experience in a technical or analytical role (Quant, Quant Dev, Data Scientist, or Data Engineer). Minimum of 5 years for highly exceptional candidates
 * Prior experience at hedge funds, fintech firms/startups, market makers, or top-tier asset management firms. Experience at top technology or strategy consulting firms considered on a case-by-case basis
 * Demonstrated project leadership, ideally overseeing technical delivery from inception to production
 * Proficiency in Python (Pandas, NumPy, Scikit-learn) and advanced SQL query optimization
 * Experience with at least one major cloud platform (AWS, GCP, or Azure) and associated data services (Snowflake, Databricks)
 * Deep understanding of data modeling and data warehousing principles

Valued:

 * Familiarity with data pipeline orchestration tools (Airflow, Dagster, Prefect)
 * Experience building quantitative trading or investment tools
 * Background in financial data (market data, portfolio analytics, fund accounting)

Personal Attributes:

 * High ownership mentality: you see problems through to resolution without being told
 * Understands what high-quality work looks like and how to deliver it
 * Curious and interested in learning about new technologies and the investment industry
 * Seeks to understand the broader business context, not just the technical requirements
 * Independent thinker who takes initiative

## Description

* Strategic Impact: Lead full-scope projects from architecture design to production deployment
 * Direct Mentorship: Work alongside the firm's Principals on every engagement
 * Modern Tech Stack: Work with best-in-class tools (Snowflake, Databricks, dbt, Dagster, cloud infrastructure, etc.) and cutting-edge AI/agentic development workflows
 * Path to Partnership: Clear trajectory toward firm equity and partnership for high performers

Core Responsibilities

Technical Leadership

 * Lead the design and implementation of scalable data platforms (data warehouses, data lakes) and end-to-end data pipelines
 * Develop and optimize production-grade code (Python/Spark) for data transformation and financial analysis
 * Build customized analytical applications, dashboards, and quantitative investment tools
 * Ensure efficient delivery and adherence to data governance and integrity standards

Client Engagement

 * Collaborate with client investment teams to translate investment process requirements into robust, automated tools and data products
 * Provide technical and project leadership across engagements
 * Understand client business context to ensure technical solutions solve real problems