[Hiring] Data Engineer @Prominence Advisors

Role Description

Prominence Advisors is actively seeking a Data Engineer (Snowflake) to join our team. 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.
• Create order out of chaos, transforming raw sources into clean, reliable, and scalable data streams.
• Deliver high-quality results while teaching counterparts how to grow the skills needed to support and expand upon project deliverables.

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 leading healthcare providers. Our ideal candidate:

• Has built and operated production workloads on Snowflake.
• Understands how warehouse sizing, data modeling, and pipeline design translate directly into performance and cost.
• Can build scalable data pipelines that ingest, transform, and deliver data from diverse sources (EHRs, claims, APIs, CRM) into analytics-ready structures in Snowflake.
• Is well-versed in DevOps practices, integrating pipeline development with version control and CI/CD.
• Is comfortable explaining tradeoffs and implementing them.

More important than any single tool is the demonstrated desire and ability to tackle new and unfamiliar technical challenges.

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 performance features (clustering keys, micro-partition behavior, materialized views, Time Travel, zero-copy cloning).
  • Snowflake security model: 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 in Snowflake using one or more of the following:
  • dbt.
  • Snowflake Streams and Tasks, or Dynamic Tables.
  • Snowpark (Python).
  • Apache Airflow, Azure Data Factory, or another orchestration framework.
• Solid grounding in ETL/ELT principles, dimensional and data-vault-style modeling, and data warehousing concepts.
• Experience with at least one major cloud provider (AWS, Azure, or GCP), including storage and networking basics as they relate to Snowflake integrations.

Requirements

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

Success Criteria

• High degree of professionalism; treats others with respect, keeps commitments, builds trust within a team, works with integrity, and upholds organizational values.
• Highly organized; able to manage multi-faceted work streams.
• Self-motivated; able to manage schedules, meet deadlines, and monitor personal work product.
• Highly adaptable; able to acclimate quickly to new project assignments and work environments.
• Creative; not paralyzed by problems and able to work collaboratively to find novel solutions.
• Clear communication skills; ability to convey messaging in clear and concise written and verbal communications.
• Ability to anticipate issues before they arise and escalate effectively.
• Passion to mentor and guide others.

Benefits

• 15 days PTO and up to 16 paid Holidays each year for full-time staff.
• Diverse healthcare offering, including low and high deductible health plans, HSAs, LTD/STD Insurance, Health and Dependent Savings Accounts, Vision, Dental, 401k offering, an annual Professional Development fund, and Signing Bonuses.