Senior Administrator - Snowflake & SQL

Montefiore Medical Center

Yonkers, NY

JOB DETAILS
SALARY
$144,000–$180,000 Per Year
SKILLS
Access Control, Administrative Skills, Amazon Web Services (AWS), Analysis Skills, Artificial Intelligence (AI), Best Practices, Business Skills, Business Strategy, Cloning, Cloud Computing, Cloud Storage, Computer Science, Cost Control, Data Analysis, Data Management, Database Administration, DevOps, Ecosystems, Enterprise Protection, Epic Cogito Data Warehouse, Exceeded Sales Goal, Executive Relationships, Failover, Healthcare, Healthcare Administration, High Availability, Identify Issues, Incident Response, Information/Data Security (InfoSec), Maintain Compliance, Medical Treatment, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Patient Care, Performance Analysis, Performance Management, Performance Modeling, Performance Tuning/Optimization, Presentation/Verbal Skills, Process Improvement, Production Management, Query Optimization, Registered Training Organisation (RTO), Regulatory Compliance, Regulatory Requirements, Replication and Remote Mirroring, Right-Sizing, Root Cause Analysis, SQL (Structured Query Language), Service Level Agreement (SLA), Set Goals, Snowflake Schema, Software Engineering, Standard Operating Procedures (SOP), Strategic Analysis, Systems Administration/Management, Systems Engineering, Usage Analysis, Use Cases, Warehousing
LOCATION
Yonkers, NY
POSTED
30+ days ago

City/State:

Yonkers, New York

Grant Funded:

No

Department:

D&A - Data & Analytics

Work Shift:

Day

Work Days:

MON-FRI

Scheduled Hours:

8:30 AM-5 PM

Scheduled Daily Hours:

7.5 HOURS

Pay Range:

$144,000.00-$180,000.00

Montefiore is ranked among the top hospitals nationally and regionally by U.S. News & World Report. For more than 100 years we have been innovating new treatments, procedures, and approaches to patient care, producing stellar outcomes and raising the bar for academic medical centers in the region and around the world.

Our work to improve health outcomes in underserved communities is unparalleled in the United States. Our workforce is among the most diverse in the US: Montefiore associates speak 60+ languages. As Montefiore has built paths to deliver lifesaving health outcomes to underserved communities, we are looking to the future of being a data driven organization and tech-enabled care delivery to create better experiences for patients, providers, and operations teams.

Montefiore is actively investing in its data & analytics driven solutions as a new system-level priority, and we are seeking data experts who are excited to create a tangible impact with the healthcare system. We are seeking an experienced Snowflake Database Administrator (DBA) with strong expertise in Snowflake to manage, optimize, and support our enterprise data platforms. The ideal candidate will be responsible for ensuring high availability, performance, security, and scalability of the Snowflake and AWS based SQL Server data platforms, with a strong focus on Snowflake advanced administration. This role will be responsible for administrating Montefiore's AI-ready data Lakehouse in Snowflake that houses complex data solutions supporting Montefiore's business functions. This role is also critical to scaling our data and insights capabilities, empowering teams with actionable insights, and supporting our mission to improve Patient healthcare.

Responsibilities include:

Snowflake Platform Administration

Administer and manage Snowflake enterprise environments (multi-account, multiregion).

Configure and manage virtual warehouses, resource monitors, roles, users, and access controls.

Perform environment provisioning, cloning, replication, and lifecycle management.

Monitor upgrades, feature enablement, and account-level configurations.

Operational Excellence & Reliability

Ensure 24/7 operational readiness and platform stability.

Implement monitoring, alerting, and observability for performance, storage, and compute usage.

Establish operational runbooks, SOPs, and incident response processes. Partner with Montefiore AWS cloud foundations team and data engineering teams to ensure platform SLAs and reliability targets are met.

Support root cause analysis and incident resolution for platform-related issues.

Define RTO/RPO objectives and ensure compliance with enterprise resiliency standards.

Conduct periodic failover testing and recovery drills.

Security, Performance Optimization & Cost Management

Monitor and tune query performance, warehouse sizing, clustering, and data organization.

Optimize storage strategies including micro-partitioning and pruning.

Drive cost optimization through warehouse right-sizing, auto-suspend/resume strategies, and usage analytics.

Provide usage and performance reports as needed Implement and manage role-based access control (RBAC) and fine-grained access policies.

Support audit, compliance, and regulatory requirements.

Collaborate with security teams to maintain enterprise data protection standards.

Stay current with Snowflake releases and emerging capabilities.

Recommend improvements to enhance platform reliability, security, and performance.

Helix Snowflake Lakehouse Data Integration & Ecosystem Support

Support data ingestion pipelines across disparate internal and external data sources primarily Epic Cogito stack.

Collaborate with the Helix Data Engineering team to ensure optimal data loading and transformation patterns.

Support external tables and integration with AWS cloud storage.

Support enablement and operationalization of Snowflake Cortex AI capabilities.

Ensure data readiness, governance, and security for AI-driven use cases.

Optimize compute resources to support AI workloads.

Partner with AI/ML teams to maintain a high-performance platform for model development and inference. Qualifications:

Required Qualifications include:

  • 12+ years of experience in database administration or data platform operations
  • 4+ years of hands-on Snowflake administration experience in enterprise environments.
  • Proven experience managing production-grade, highly available data platforms.
  • Experience designing and implementing DR and business continuity strategies. • Solid experience administering Microsoft SQL Server.
  • Strong knowledge of SQL, query optimization, and performance tuning.
  • Experience with security, compliance, and data governance best practices.
  • Experience with AWS cloud platform is a plus
  • Strong troubleshooting and analytical skills
  • Ability to work in a fast-paced, mission-critical environment.
  • Snowflake Advanced Administration Certification
  • Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).

Preferred Qualifications:

  • Experience in health systems database administration
  • Experience in Epic Cogito stack administration
  • Experience with Infrastructure-as-Code and DevOps practices.

Competencies:

  • Ability to think strategically and drive structured execution
  • Structured, linear thinker that can conduct business outcome diagnostics and identify highest value business opportunities
  • Strong facilitation skills to help business leaders identify their most important business questions
  • Exhibits excellent judgment, especially when working with ambiguity.

Sets stretch goals and works to exceed goals with a focus for results.

  • Has the innate ability to gain the confidence of and build strong relationships with executives, peers, management and subordinates alike.
  • Excellent business-facing presentation skill

#SF-DICE-MIT

#LI-SC1

Montefiore Health System, Inc. is an equal employment opportunity employer. Montefiore Health System, Inc. will recruit, hire, train, transfer, promote, layoff and discharge associates in all job classifications without regard to their race, color, religion, creed, national origin, alienage or citizenship status, age, gender, actual or presumed disability, history of disability, sexual orientation, gender identity, gender expression, genetic predisposition or carrier status, pregnancy, military status, marital status, or partnership status, or any other characteristic protected by law.

About the Company

M

Montefiore Medical Center

About Montefiore Medical Center

Commitment to Excellence

As the academic medical center and University Hospital for Albert Einstein College of Medicine, Montefiore Medical Center is nationally recognized for clinical excellence—breaking new ground in research, training the next generation of healthcare leaders, and delivering science-driven, patient-centered care.

Montefiore is ranked among the top hospitals nationally and regionally by U.S. News & World Report. For more than 100 years we have been innovating new treatments, new procedures and new approaches to patient care, producing stellar outcomes and raising the bar for medical centers in the region and around the world. As we build on this momentum, we continue to advance the practice of medicine and set the standard for excellence.

Enduring Mission and Distinguished History

The mission of Montefiore is to heal, to teach, to discover and to advance the health of the communities we serve.

From its beginning in 1884, as a facility for the care of patients with tuberculosis and other chronic illnesses, to the new millennium, Montefiore has been at the forefront of patient care, research and education and steadfast commitment to its community.

Our Services

We provide coordinated, compassionate and leading-edge care designed to reach people when and where they need it most. Through highly integrated teams of physicians, nurses, social workers, mental health professionals and other caregivers, we have created an innovative, seamless system of care focused around the patient.

Notable Centers of Excellence

At the intersection of Einstein science and Montefiore medicine is our commitment to scientific inquiry. This commitment has resulted in the creation of the Montefiore-Einstein Centers of Excellence in cancer care, cardiovascular services, transplantation and children’s health, where nationally recognized investigators and multidisciplinary clinical teams collaborate to develop and deliver advanced, innovative care.

Advanced Specialty and Surgical Care

We offer advanced, multidisciplinary care across specialties, delivering one standard of excellence for all. Our interventions are designed to help patients understand and manage their illness, advocate for their health, access the right treatments and receive the vital social support they need to flourish. On multiple fronts, Montefiore is developing more effective and less invasive approaches to complex problems from procedures to repair diseased hearts, protocols to treat complex cancers and medical devices designed to meet the needs of growing children.

Primary Care

With nearly 50 primary care locations throughout the New York metropolitan area, we are focusing on accessible, patient-centered primary and preventive care provided by leading physicians in the areas of family and internal medicine, pediatrics, obstetrics and gynecology, and a team of experts in nursing, health education, nutrition and pharmacy.

Providing Care Without Walls

Montefiore combines its deep commitment to the community with nationally-renowned expertise to reach people in locations easiest for them. Through Montefiore’s School Health Program (MSHP), Primary Care at Home programs, mobile medical and dental health vans and health education initiatives, Montefiore provides primary care services in non-traditional settings.

Through the formation of highly integrated teams of physicians, nurses, social workers, mental health professionals, care managers and other caregivers, we provide care around the patient, when and where they need it.

Research and Education

Montefiore's partnership with Einstein advances clinical and translational research to accelerate the pace at which new discoveries become the treatments and therapies that benefit patients. Together, the two institutions are among 38 academic medical centers nationwide to be awarded a prestigious Clinical and Translational Science Award (CTSA) by the National Institutes of Health.

The second-largest medical residency program in the country, with 1,251 residents and fellows across 89 programs, Montefiore provides the doctors of tomorrow a unique opportunity for education and training in one of the most diverse urban areas in the country — one where the population is global, the disease burden is high, and the need for quality care is great.

The partnership is further strengthened by the dual appointments of faculty and physicians across both organizations—enhancing synergies and collaborations for research, teaching and patient care.

Comprehensive Care Management

Since 1996, Montefiore has developed advanced models of care management to help patients, especially those with chronic diseases such as diabetes, heart failure and mental illness, achieve better health and improved wellbeing in a cost effective way. Montefiore goes beyond fragmented fee-for-service payments, assuming total responsibility for the quality and costs of care for some of our sickest patients.

Through CMO, Montefiore Care Management, we use a global prepayment or similar strategies to manage care for 200,000 individuals over the continuum, including hospital care, rehabilitation, outpatient care, professional services, home care, mental health counseling, community-based services, remote patient monitoring and many other programs.

Our leadership in coordinating care across multiple settings has earned us federal recognition from the Centers for Medicare and Medicaid Services as a Pioneer Accountable Care Organization. Montefiore's ACO is one of only 32 organizations in the nation, as well as the only one in New York State, to operate under this new model of providing Medicare beneficiaries with higher quality care, while reducing expenditures through enhanced care coordination.

Learn More

  • Mission, Vision and Values – Montefiore’s unique path of growth into the future and the clinical excellence and outstanding customer care that will get us there.
  • History and Milestones – Proud traditions guiding our mission and the moments that helped shape Montefiore into a premier academic medical center.
  • Commitment to the Community – Community health, education and neighborhood development.
  • Leadership – Executives and clinical chairs leading Montefiore’s advancements.
  • Physicians – Widely acclaimed medical professionals and specialists who provide our patients with the highest standards of care.
  • Nursing Staff – Highly competent and compassionate professionals committed to improving the health of their patients.
  • Ways to Give – Philanthropic opportunities and other ways to support Montefiore Medical Center.
COMPANY SIZE
10,000 employees or more
INDUSTRY
Healthcare Services
WEBSITE
http://www.montefiore.org/