Note: The job is a remote job and is open to candidates in USA. Prominence Advisors is a healthcare and life sciences technology and consulting firm that helps organizations use data to improve operational efficiency, patient outcomes, and financial performance. The Data Engineer will design, build, and maintain Snowflake-based data pipelines and workflows, transforming diverse raw data sources into reliable, scalable, analytics-ready structures while collaborating with client architects and analysts.
Responsibilities
- 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
- 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
- Help us build and optimize data pipelines in partnership with some of the nation's leading healthcare providers
- You'll work directly with client architects and analysts, so you should be comfortable explaining tradeoffs as well as implementing them
- 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 your 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
Skills
- • 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
- 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
- • 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
Benefits
- Diversified career path, stability in a rapidly changing market, and opportunities for growth within Prominence through the Analytics and Epic Services business nodes
- Fully remote work within the US, with flexibility to manage your schedule
- 15 days PTO and up to 16 paid Holidays each year for full-time staff
- Low and high deductible health plans, HSAs, LTD/STD Insurance, Health and Dependent Savings Accounts, Vision, and Dental
- 401k offering
- An annual Professional Development fund
- Signing Bonuses
Company Overview