Own Snowflake architecture and establish staging, curated, and conformed data-layer standards. Design dimensional, historical, identity, payer attribution, member-month, and temporal models for healthcare data. Define data quality, reconciliation, lineage, audit, exception, and operational controls while protecting sensitive information. Translate requirements into engineering designs, guide engineers, conduct design reviews, manage technical risks, and support sprint planning and estimates.
Title: Senior Snowflake Data Architect
Location: Remote
Duration: 3 Month
Job Description:
- 10+ years in data engineering, warehousing or analytics, including 5+ years as a data or solution architect.
- Deep hands-on Snowflake architecture and advanced SQL experience.
- Expert dimensional modeling: star schemas, conformed dimensions, surrogate keys and SCD Type 2.
- Experience with member identity, crosswalk/entity-resolution models and client-defined matching logic.
- Strong data quality, reconciliation, audit/control logging, exception handling, lineage and documentation skills.
- Client-facing leadership experience; healthcare payer/provider and MPI experience preferred.
- Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards.
- Translate business and technical requirements into logical and physical designs for engineering delivery.
- Lead dimensional and historical modeling for patient/member data, including SCD Type 2.
- Design patient/member crosswalks and enterprise identity structures supporting client-validated MPI logic.
- Design payer attribution, member-month and temporal models across payer/plan, provider networks, PCPs and clinics.
- Define reconciliation, schema-drift, null/datatype, referential-integrity, exception and alerting controls.
- Establish naming, lineage, source-to-target, testing, operational logging and runbook standards.
- Protect sensitive healthcare data and support client security and compliance requirements.
- Guide engineers, conduct design reviews, manage technical risks and support sprint planning and estimates.
Roles and Responsibilities:
- Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards.
- Translate business and technical requirements into logical and physical designs for engineering delivery.
- Lead dimensional and historical modeling for patient/member data, including SCD Type 2.
- Design patient/member crosswalks and enterprise identity structures supporting client-validated MPI logic.
- Design payer attribution, member-month and temporal models across payer/plan, provider networks, PCPs and clinics.
- Define reconciliation, schema-drift, null/datatype, referential-integrity, exception and alerting controls.
- Establish naming, lineage, source-to-target, testing, operational logging and runbook standards.
- Protect sensitive healthcare data and support client security and compliance requirements.
- Guide engineers, conduct design reviews, manage technical risks and support sprint planning and estimates.
About UsDatavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. About the Team
Datavail’s Data Management Services:
Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.
Similar Jobs
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Lead enterprise data architecture across warehouses, data lakes, downstream applications, and AI workloads. Design data models, Medallion Architecture, ELT standards, semantic layers, APIs, access controls, and reusable datasets. Partner with business and BI teams to drive adoption, conduct architecture reviews, establish platform standards, and mentor data and analytics engineers. The role requires deep Snowflake, dbt, data modeling, pipeline, and semantic-layer expertise, with experience in AI data patterns and cloud infrastructure preferred.
Top Skills:
AWSAzureDatabricksDbtDelta LakeGCPGraphQLLlmsPower BIRagRestSnowflakeSnowflake Unity CatalogTableau
Information Technology
Designs and delivers Snowflake data architectures on AWS, including dbt-based data engineering and AI-enabled solutions. Leads RAG, vector search, embedding, semantic search, and analytics initiatives from proof of concept through production. Directs project teams, oversees solution quality and budgets, supports proposals and business cases, and serves as a trusted technical advisor to clients. Requires strong data engineering, governance, documentation, communication, and stakeholder-management skills, with travel as needed.
Top Skills:
AWSDbtEmbedding PipelinesGenerative AiPrompt OrchestrationRetrieval-Augmented GenerationSemantic SearchSnowflakeSQLVector Search
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Investigates and processes commercial insurance claims, determines policy coverage, assesses damages, establishes reserves, negotiates settlements, prepares estimates, and maintains accurate claim documentation. The role requires direct communication with insureds, claimants, agents, and internal teams, while identifying potential fraud or subrogation opportunities and coordinating with appraisal and investigative units.
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
