Join the Edison family of high-growth, market-leading companies in financial services, healthcare, enterprise software sectors.


Snowflake Data Platform Architect



Multiple locations
Posted on Saturday, March 30, 2024

Zelis is hiring a Snowflake Data Platform Architect who will be responsible for designing, implementing, and optimizing Snowflake data warehouses and related solutions for an existing Data platform. The ideal candidate will have extensive experience in data architecture, cloud computing, and Snowflake platform capabilities.

The Snowflake Platform Architect will be responsible for:

  • Designing scalable and efficient data warehouse solutions using Snowflake architecture.

  • Leading the architecture efforts & implementation of data platform on Snowflake, including data modeling, ETL/ELT processes, and data integration / dissemination / Data Sharing.

  • Collaborating with data engineers, data scientists, and Product owners to understand data requirements and translate them into technical solutions.

  • Performance tuning and optimization of existing platform to ensure high availability, reliability, costs, performance & security.

  • Implementing security best practices and data governance policies within Data platform environments.

  • Providing guidance and mentoring to team members on Snowflake best practices and techniques.

  • Evaluating new Snowflake features and capabilities and recommending their adoption to improve overall functionality and also system performance.

  • Troubleshooting and resolving issues related to Snowflake databases and data pipelines.

  • Collaborating, designing, and enabling Snowflake Horizon features.

  • Advanced Analytics - Demonstrated proficiency in implementing advanced analytics solutions within Snowflake, including forecasting, predictive modeling and anomaly detection, leveraging Cortex AI.

  • Machine Learning Utilization- Proven track record of utilizing machine learning models directly within Snowflake to derive actionable insights from large datasets.

  • Real-time Decision Making- Expertise in enabling real-time decision-making capabilities within Snowflake by integrating Cortex AI, enabling rapid responses to evolving business scenarios.

  • Designing scalable batch/real time data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse and Data Lake

  • Working in Data Lake, Data Warehouse Concepts and Dimensional Data Model.

  • Maintaining awareness of and ensure adherence to Zelis standards regarding privacy.

  • Creating and maintaining Architecture documents.

Required Experience:

  • Minimum of 12 years of experience in data architecture, database design, and development; to include 5+ yrs with Snowflake

  • Experience with cloud computing concepts and cloud platforms such as AWS or Azure.

  • SQL and Python experience with ETL/ELT tools and techniques.

  • Snowflake certification(s) (e.g., SnowPro Core, SnowPro Advanced).

  • Experience with SQL, indexes, stored procedures, triggers, functions, views, etc.

Preferred Experience:

  • Data modeling and schema design in Snowflake.

  • MDM tools and implementation.

  • Ability to design and implement highly scalable and performant data warehouse solutions.

  • Data governance, security, and compliance requirements in a data warehouse environment.

  • Git and Azure DevOps.

  • Agile, Jira and Confluence.

  • Healthcare.

As a leading payments company in healthcare, we guide, price, explain, and pay for care on behalf of insurers and their members. We’re Zelis in our pursuit to align the interests of payers, providers, and consumers to deliver a better financial experience and more affordable, transparent care for all. We partner with more than 700 payers, including the top-5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, over 4 million providers, and 100 million members, enabling the healthcare industry to pay for care, with care. Zelis brings adaptive technology, a deeply ingrained service culture, and a comprehensive navigation through adjudication and payment platform to manage the complete payment process.

Commitment to Diversity, Equity, Inclusion, and Belonging
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.

Equal Employment Opportunity
Zelis is proud to be an equal opportunity employer. All applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

We encourage members of traditionally underrepresented communities to apply, even if you do not believe you 100% fit the qualifications of the position, including women, LGBTQIA people, people of color, and people with disabilities.

Accessibility Support

We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email TalentAcquisition@zelis.com

SCAM ALERT: There is an active nationwide employment scam which is now using Zelis to garner personal information or financial scams. This site is secure, and any applications made here are with our legitimate partner. If you’re contacted by a Zelis Recruiter, please ensure whomever is contacting you truly represents Zelis Healthcare. We will never asked for the exchange of any money or credit card details during the recruitment process. Please be aware of any suspicious email activity from people who could be pretending to be recruiters or senior professionals at Zelis.