Designs and delivers analytics solutions on Snowflake using dbt, SQL, and modern ELT practices. Responsibilities include data modeling, pipeline development, migrations, performance optimization, data quality, security, orchestration, CI/CD, and release management. Leads discovery and requirements gathering, translates business needs into analytics architectures, provides technical guidance, and communicates recommendations to client stakeholders in agile consulting environments.
As a Senior Data Management Consultant, you will play a key role in designing, building, and enabling analytics solutions on modern cloud data platforms. This role focuses on solving complex data integration and modeling challenges using Snowflake and dbt, while partnering closely with clients and stakeholders to deliver trusted, high-impact analytics solutions.
This position requires a strong blend of technical expertise and consulting skills, including the ability to lead discovery, translate business needs into well-designed data models, and communicate effectively with both technical and non-technical audiences.
RESPONSIBILITIES
- Analyze data from diverse source systems to understand upstream business processes, data semantics, and integration requirements
- Lead discovery and requirements-gathering efforts with business and technical stakeholders to shape analytics solutions
- Design and implement scalable Snowflake-based data architectures that support analytics, reporting, and downstream consumption
- Develop, test, and maintain robust, performance-optimized ELT pipelines using Snowflake and dbt best practices
- Build curated, analytics-ready data models that enable self-service reporting and decision-making
- Apply analytics engineering best practices, including modular modeling, testing, documentation, and version control using dbt
- Identify and resolve complex data integration, data quality, and performance issues across the analytics stack
- Implement and maintain CI/CD workflows for data pipelines and analytics models using GitHub or GitLab
- Lead or support data migrations from on-premises or legacy platforms to Snowflake
- Provide technical leadership and guidance on data modeling standards, transformation patterns, and analytics architecture
- Collaborate effectively with cross-functional teams using agile delivery methodologies
- Support release management for data platforms, pipelines, and analytics assets
- Design and manage workflow orchestration and monitoring for data pipelines
- Ensure data platform security, including role-based access control and secure data sharing within Snowflake
- Communicate clearly and confidently with clients, including presenting technical concepts, tradeoffs, and recommendations
QUALIFICATIONS
- 5+ years of hands-on experience in data engineering, analytics engineering, or data management roles
- Strong experience designing and delivering analytics solutions on Snowflake, including data modeling, performance optimization, and security
- Hands-on experience using dbt for analytics engineering, including model development, testing, and documentation
- Advanced SQL skills, including complex transformations, multi-layer queries, and analytical patterns
- Experience developing ELT pipelines in a modern cloud data platform environment
- Strong understanding of modern data warehousing, analytics engineering, and semantic modeling concepts
- Experience with CI/CD tooling and version control using GitHub and or GitLab
- Demonstrated ability to translate ambiguous business requirements into well-structured data models and analytics solutions
- Strong consulting and client-facing skills, including stakeholder communication, expectation management, and solution ownership
- Ability to explain complex technical concepts clearly to non-technical audiences
- Experience working in agile, client-facing, or consulting environments
The anticipated base salary for this role is $120,000 - 160,000. Final pay rate will be determined based on experience, qualifications and geographic location
It is our policy to provide and promote equal employment opportunity to all employees and applicants for employment following all local, state, and federal laws and regulations governing personnel activities. Under federal guidelines we are committed to a program of affirmative action for work sites in the United States.
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Senior Data Engineer responsible for Epic and EHR integrations supporting value-based care, risk and quality workflows, member attribution, roster management, and care-gap tools. The role designs and executes EHR development tasks, coordinates with clinical, data, operations, and development teams, documents business and data flows, evaluates AI and automation opportunities, and develops reporting to identify data-quality issues and prevent outages.
Top Skills:
Ai ToolsCaboodleClarityEhr IntegrationsEpicHealthy PlanetSQL
Big Data • Cloud • Productivity • Software • Database • Analytics • Automation
Build and maintain Databricks-based data platforms, including ingestion, transformation, storage, governance, data modeling, and serving pipelines. Establish medallion architecture standards, canonical data models, quality controls, lineage, schema evolution, and reliable batch or incremental processing. Improve pipeline observability, scalability, idempotency, and recoverability while moving curated data to systems such as ClickHouse. Collaborate across application and analytics teams to create durable, governed production datasets.
Top Skills:
Amazon AuroraAmazon RdsApache AirflowSparkBigQueryCdcClickhouseCloud Object StorageDatabricksDelta LakeIamOpenmetadataPostgresSnowflakeUnity Catalog
AdTech • Consumer Web • Digital Media • eCommerce • Marketing Tech • SEO
Build and support scalable data platforms and pipelines, leading migrations such as Snowflake to BigQuery and transitioning reporting to Looker. Responsibilities include data architecture, ETL/ELT, API and marketing integrations, data quality, production troubleshooting, warehousing, performance optimization, and platform modernization. The role partners with analytics and business teams, owns projects through production, documents solutions, and provides technical guidance.
Top Skills:
AWSAzureBigQueryConfluenceDraw.IoGCPGitJIRAKafkaLookerLucidchartMiroModeNotionPower BIPythonSnowflakeSparkSQLTableauTalend
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
