Data Engineer (Snowflake)

Prominence Advisors is actively seeking a Data Engineer (Snowflake) to join our team.
Who We Are
Prominence is a healthcare and life sciences technology and consulting firm dedicated to helping leading organizations do more with their data. With deep expertise across the full ecosystem — spanning providers, payers, and life sciences — we turn complex data into actionable insight.
We deliver a full spectrum of services, including advisory, analytics, optimization, and IT staffing. Our work helps organizations operate more efficiently, improve patient outcomes, and deliver measurable financial impact through smarter use of data. Recognized as a 2x Best in KLAS organization, we partner with more than 120 health systems and 40 life sciences organizations, including 7 of the top 10 U.S. News & World Report-ranked institutions.
Through our life sciences brands, Tegra Analytics and WLH Consulting & Learning Solutions, we extend these capabilities to pharmaceutical and biotech organizations — combining data, consulting, and learning to advance commercial excellence.
By connecting strategy, data, and execution, we help organizations translate data into clarity, strategy into action, and vision into measurable results. At our core, we are a people-first, values-driven organization that believes strong teams and trusted partnerships are what ultimately make healthcare and life sciences smarter.
Your Role
Our consultants guide our customers through complex data challenges to summit the task at hand. As a Data Engineer, you will design, build, and maintain pipelines and workflows that enable our customers to put their data to work. You will need to be able to create order out of chaos, transforming raw sources into clean, reliable, and scalable data streams.
Our ideal team members are humble, smart, and driven to ensure our customer’s success. This includes a passion to deliver high-quality results, while teaching our counterparts how to fish and grow the skills needed to support and expand upon the deliverables of our projects.
If this sounds like you, and you meet the requirements below, we encourage you to . If you know of someone else who would be a great fit, let us know.
Requirements
Prominence is looking for a Data Engineer with deep Snowflake experience and strong SQL and Python skills to help us build and optimize data pipelines in partnership with some of the nation's leading healthcare providers.
Our ideal candidate has built and operated production workloads on Snowflake — not just queried them — and understands how warehouse sizing, data modeling, and pipeline design translate directly into performance and cost. You should be able to build scalable data pipelines that ingest, transform, and deliver data from diverse sources (EHRs, claims, APIs, CRM) into analytics-ready structures in Snowflake. You should also be well versed in DevOps practices, integrating pipeline development with version control and CI/CD to support repeatable deployments across environments, change tracking, and appropriate approval gates. You'll work directly with client architects and analysts, so you should be comfortable explaining tradeoffs as well as implementing them.
More important than any single tool is the demonstrated desire and ability to tackle new and unfamiliar technical challenges.
This position is a full-time, salaried role with benefits. There is no relocation required. Candidates are required to have a suitable home office to operate from.
Minimum Qualifications
- 3+ years of professional experience in data engineering or related roles
- 2+ years of hands-on Snowflake experience in a production environment, including:
- Strong Snowflake development experience, including query profile analysis, query optimization, and debugging
- Virtual warehouse sizing, scaling policies, and credit/cost management
- Data loading and ingestion patterns (COPY INTO, Snowpipe, external stages, external tables)
- Table design and performanc