Data Engineer - Remote

## About the Company

Prominence Advisors is a healthcare and life sciences technology and consulting firm focused on helping organizations make better use of their data. The company provides services across advisory, analytics, optimization, and IT staffing, supporting healthcare providers, payers, and life sciences organizations.

Prominence works with more than 120 health systems and 40 life sciences organizations and has been recognized as a 2x Best in KLAS organization. Through its life sciences brands, Tegra Analytics and WLH Consulting & Learning Solutions, the company also supports pharmaceutical and biotech organizations.

Prominence takes a people-first, values-driven approach, combining data, strategy, and execution to help customers turn complex information into actionable insights.

## About the Role

Prominence Advisors is seeking a Data Engineer with deep Snowflake experience and strong SQL and Python skills to design, build, and optimize data pipelines for leading healthcare organizations.

In this role, you will transform raw data from diverse sources—including EHRs, claims, APIs, and CRM systems—into clean, reliable, scalable, analytics-ready data structures. You will work closely with client architects and analysts while applying data engineering, DevOps, and cloud technologies to solve complex technical challenges.

The ideal candidate has operated production Snowflake workloads and understands how warehouse sizing, data modeling, query optimization, and pipeline architecture affect performance and cost.

### Key Responsibilities

• * Design, build, and maintain scalable data pipelines and workflows.
• * Develop data ingestion and transformation processes using Snowflake.
• * Transform data from EHRs, claims, APIs, CRM systems, and other sources into analytics-ready structures.
• * Optimize Snowflake queries, warehouse configurations, and pipeline performance.
• * Analyze query profiles, troubleshoot issues, and identify opportunities for optimization.
• * Apply appropriate Snowflake warehouse sizing, scaling policies, and cost-management practices.
• * Implement data loading and ingestion patterns using COPY INTO, Snowpipe, external stages, and external tables.
• * Design efficient tables and leverage Snowflake performance features.
• * Implement Snowflake security models, roles, grants, and RBAC structures.
• * Develop transformation and orchestration workflows using technologies such as dbt, Streams and Tasks, Dynamic Tables, Snowpark, Airflow, or Azure Data Factory.
• * Apply ETL/ELT, dimensional modeling, data warehousing, and data vault concepts.
• * Integrate data engineering workflows with Git, CI/CD, and DevOps practices.
• * Collaborate with client architects, analysts, and other stakeholders.
• * Communicate technical tradeoffs and recommendations clearly.
• * Identify and resolve unfamiliar or complex technical challenges.
• * Mentor and guide team members when appropriate.

### Minimum Qualifications

• * 3+ years of professional experience in data engineering or a related field.
• * 2+ years of hands-on Snowflake experience in production environments.
• * Strong Snowflake development and optimization experience.
• * Experience with query profiling, query optimization, and debugging.
• * Understanding of virtual warehouse sizing, scaling policies, and credit/cost management.
• * Experience with data loading and ingestion patterns, including COPY INTO, Snowpipe, external stages, and external tables.
• * Knowledge of Snowflake table design and performance features, including clustering keys, micro-partition behavior, materialized views, Time Travel, and zero-copy cloning.
• * Understanding of Snowflake security, including roles, grants, and RBAC hierarchy design.
• * Proficiency in Python or another programming/scripting language such as Scala or Java.
• * Experience building transformation and orchestration logic using one or more of the following:

• * dbt
• * Snowflake Streams and Tasks
• * Dynamic Tables
• * Snowpark for Python
• * Apache Airflow
• * Azure Data Factory
• * Another orchestration framework
• * Strong understanding of ETL/ELT principles, dimensional modeling, data vault concepts, and data warehousing.
• * Experience with at least one major cloud platform: AWS, Azure, or GCP.
• * Understanding of cloud storage and networking concepts relevant to Snowflake integrations.

### Desired Qualifications

• * Healthcare industry experience, including Epic Clarity/Caboodle, HL7, FHIR, or claims data.
• * Experience handling PHI in Snowflake using dynamic data masking, row access policies, tagging, and HIPAA-aligned configurations.
• * SnowPro Core or SnowPro Advanced: Data Engineer certification.
• * Experience with CI/CD, Git, and DevOps workflows.
• * Experience with schema migration tools such as schemachange, Flyway, Liquibase, or dbt-native deployment.
• * Familiarity with Infrastructure-as-Code and the Snowflake Terraform provider.
• * Experience with Snowflake Secure Data Sharing, Snowflake Marketplace, or reader accounts.
• * Familiarity with Snowflake Cortex AI functions, Streamlit in Snowflake, or Iceberg tables.
• * Experience with real-time or streaming ingestion using Kafka Connector, Snowpipe Streaming, Kinesis, or Pub/Sub.
• * Experience migrating workloads from SQL Server, Teradata, Oracle, Netezza, or Redshift to Snowflake.
• * Exposure to other cloud data platforms such as Databricks, BigQuery, or Redshift.

### Success Criteria

Successful team members at Prominence demonstrate:

• * Professionalism, integrity, and respect for others.
• * Strong organizational and project management skills.
• * Self-motivation and accountability for deadlines and deliverables.
• * Adaptability to new projects and technical environments.
• * Creative and collaborative problem-solving skills.
• * Clear and concise written and verbal communication.
• * Ability to anticipate issues and escalate effectively.
• * A willingness to mentor and guide colleagues.
• * A strong commitment to customer success and high-quality results.

### Benefits and Perks

• * Fully remote work anywhere within the United States.
• * Flexible scheduling.
• * 15 days of paid time off.
• * Up to 16 paid holidays each year.
• * Opportunities for career growth across Analytics and Epic Services.
• * Exposure to leading healthcare organizations and complex data projects.
• * Opportunities to work with highly experienced healthcare technology professionals.
• * A culture focused on professional development, collaboration, and innovation.

### Work Arrangement

This is a fully remote, salaried position with benefits. There is no relocation requirement, and candidates must have a suitable home office for performing the role.

## Equal Opportunity

Prominence Advisors is committed to providing equal employment opportunities and fostering an inclusive workplace. Employment decisions are made without regard to sex, gender, sexual orientation, gender identity, race, color, religion, national origin, age, disability, veteran status, or any other characteristic protected by applicable law.