Snowflake Data Platform Administrator

Posted:
10/10/2024, 5:00:00 PM

Location(s):
Massachusetts, United States ⋅ Missouri, United States ⋅ Florida, United States ⋅ Georgia, United States ⋅ Texas, United States ⋅ New Jersey, United States

Experience Level(s):
Senior

Field(s):
DevOps & Infrastructure ⋅ Software Engineering

Workplace Type:
Remote

Responsibilities:

  • Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC).

  • Optimize databases' performance, security, and reliability within the Snowflake Data Cloud platform.

  • Setup and Manage virtual warehouses.

  • Extensive experience in Query Tuning.

  • Use data replication for data sharing across accounts and for failover scenarios.

  • Setup framework to share data securely both within and outside the organization.

  • Develop and implement backup and disaster recovery procedures.

  • Provide technical support and troubleshooting for Snowflake users.

  • Stay up to date on the latest Snowflake features and best practices.

  • Integrate Snowflake with various data sources and third-party tools.

  • Troubleshoot issues related to Snowflake implementations.

  • Experience in supporting/developing ETL workload.

  • Recommend the Snowflake best practices for management, monitoring, and optimization.

  • Experience of working Azure and AWS Cloud.

  • Sizing and capacity projections for the platform.

  • Design and CICD and other Deployments

  • Experience in setting up and maintaining Snowflake container services.

Requirements:

Minimum of 8+ years’ overall data engineering experience:

  • Snowflake Data Platform Administration

  • Cloud Platform Experience: Azure/AWS

Preferred Skills:

  • Snowflake Certification.

  • ETL tool to include any of the following: Azure Data Factory; DBT; Informatica; Matillion; Talend; SSIS

  • Design and development of data marts in Snowflake preferred

  • Working knowledge of Azure/AWS Architecture, Data Lake,

  • Business analysis experience to analyze data to write code and drive solutions

  • Knowledge of: GitHub, Airflow, Agile, Jira, and Confluence

  • Working knowledge on Erwin for data modelling

Independence/ Accountability:

  • Requires minimal daily supervision 

  • Receives detailed instruction on new assignments and determines next steps with guidance

  • Regularly reviews goals and objectives with supervisor

  • Demonstrates competence in relevant job responsibilities which allows for increasing level of independence

  • Ability to manage and prioritize multiple tasks

  • Ability to work under pressure and meet deadlines

Problem Solving:

  • Makes logical suggestions of likely causes of problems and independently suggests solutions

  • Excellent organizational skills are required to prioritize responsibilities, thus completing work in a timely fashion

  • Outstanding ability to multiplex tasks as required

  • Excellent project management and/or business analysis skills.

  • Attention to detail and concern for impact is essential

Zelis is modernizing the healthcare financial experience by providing a connected platform that bridges the gaps and aligns interests across payers, providers, and healthcare consumers. This platform serves more than 750 payers, including the top 5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, and millions of healthcare providers and consumers. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts – driving real, measurable results for clients.

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 qualified 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 [email protected].  

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.