Data Engineer (Snowflake)

About the 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.

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.
• You should have 3+ years of professional experience in data engineering or related roles and 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

Qualifications

• Minimum Qualifications: 3+ years of professional experience in data engineering or related roles, 2+ years of hands-on Snowflake experience in a production environment
• Desired Qualifications: Healthcare industry knowledge and experience, Experience handling PHI in Snowflake, Experience with CI/CD pipelines, Familiarity with Infrastructure-as-Code, Exposure to other cloud data platforms, and the ability to speak to how they compare

Benefits

Prominence is dedicated to hiring the best and brightest minds in healthcare, and maintaining a culture that rewards our employees for following their passion. You'll join a team of highly motivated and passionate people who do great work for the nation's leading healthcare organizations, including 7 of the top 10 academic medical centers. In the past 5 years, we've received 20+ Best Places to Work Awards and are highly rated in KLAS, reflecting the quality work from our team of A-players who move mountains daily for our customers.