Sr. Clinical Snowflake Architect

7 hours ago


La Jolla, United States Softworld, Inc. Full time


Job Title: Sr. Clinical Snowflake Architect


Job Location: La Jolla CA 92037 Remote


Job Description:



  • This is a three-to-six-month flexible consultant role that will design architecture, organize, and enable delivery of commercial, research, and clinical research data from diverse data sources using Snowflake with SQL and Python scripting on Azure.
  • This position will work collaboratively with quality assurance, bioinformatics, clinicians, researchers, and business leaders at Client to create a data warehouse so that all data recipients have a single source of truth and data deliverables are consistent across the business.
  • This position will be responsible for leveraging cloud architecture (Azure), managing integrations, designing processes for data aggregation and access management that comply with 21 CFR Part 11 and best practices for compliance in a highly regulated environment with strict requirements for blind management, confidentiality, and applicable privacy regulations.
  • The Senior Data Warehouse Architect Consultant will also mentor and guide the less senior resources in the team.
  • As part of the responsibilities, the individual is expected to technically lead projects and efforts; provide strategic and tactical input to management; translate incoming business requirements into technical architectural solutions, as well as help define the short term and long-term roadmap of the enterprise Data Warehouse Architecture.
  • Data integration & engineering using modern enterprise development toolsets
  • Responsible for cloud data integration architecture, security, development, testing, data quality, and on-going auditing, including integration with Okta, LSAF, and Tableau
  • Serves as an expert resource and consultant for all areas of cloud data integration with regard to data collection, standards, management, governance, retrieval, and use as well as design and use of data elements and tools.
  • Provides data modeling and architecture expertise for complex projects.
  • Collaborates with quality assurance, IT, biostatisticians, data scientists, researchers, clinicians, and business leaders to understand requirements and translate into functional specifications.
  • Designs data marts and develops scheduled and ad-hoc parameterized queries and reports from a variety of data sources and provides on-going analytical support for these requests
  • Converts existing reporting tools to a standardized reporting infrastructure
  • Accurately scopes, defines and estimates work effort and resource plan for assigned projects
  • Determines testing needed to assure the accuracy of information being delivered by creating test plans and evaluate testing results
  • Identifies data quality issues and supports the data governance initiative
  • Forecasts and analyzes data and trends to create reports that highlight areas needing improvement
  • Leverage cloud technologies (Azure), Snowflake SQL and/or Python, ETL/ELT processes, and enterprise modeling tools
  • Ensure data models, metadata, and clinical decision support elements are aligned with best practices and facilitate data standardization
  • Implement data lineage and change data capture (CDC) mechanisms
  • Guide junior team members, sharing your expertise and fostering growth
  • Lead technical projects, provide strategic input, and contribute to the long-term roadmap of the enterprise Data Warehouse Architecture
  • Maintain excellent code control and coding practices with clean documentation to create a culture of compliance

  • Solution Architect

    3 days ago


    La Jolla, California, United States Pfizer Full time

    Job Title: Solution EngineerPfizer is a global leader in the pharmaceutical industry, and we're seeking a highly motivated Solution Engineer to join our Digital Commercial and Customer Creation Center (C4) Digital Technology team.About the RoleWe're looking for a talented engineer to design, develop, and maintain curated data sources in Tableau to support...


  • La Crosse, United States Short Elliott Hendrickson, Inc Full time

    Job DescriptionJob DescriptionImagine being an employee-owner of a company guided by engaged and empowered team members like yourself. Where a culture of respect, flexibility, and accountability aren't just ideals - they're our foundation, and diverse backgrounds and perspectives are valued as drivers of innovation and growth. Join us, as together,...


  • La Jolla, United States Vaco Full time

    About Vaco: Vaco provides expert consulting, permanent placement, executive search, and strategic staffing for companies around the world, in the areas of accounting, finance, operations, administration and more. As a premier talent solutions firm, Vaco connects people to their dream jobs and helps leading companies find talent to grow their business. About...


  • La Jolla, United States Vaco Full time

    About Vaco: Vaco provides expert consulting, permanent placement, executive search, and strategic staffing for companies around the world, in the areas of accounting, finance, operations, administration and more. As a premier talent solutions firm, Vaco connects people to their dream jobs and helps leading companies find talent to grow their business. ...


  • La Vista, United States The Weitz Company Contrack Watts, Inc. Full time

    Job DescriptionJob DescriptionSalary: Our Company views employees as our most valuable asset, and the key to our success. We are committed to growing a diverse and inclusive culture that inspires, motivates, and continuously improves. Community involvement, employee empowerment, and strong relationships makes The Weitz Company a great place to work. We are...


  • La Grange, United States Austin Heart Full time

    Description Introduction Are you passionate about the patient experience? At HCA Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as a(an) Non-Licensed Clinic Manager today with Austin Heart. Benefits Austin Heart, offers a total rewards package that supports the health, life, career...


  • Saint-Priest-la-Feuille, Nouvelle-Aquitaine, United States Johnston-Willis Hospital Full time

    Job SummaryThe Clinical Nurse Coordinator (CNC) plays a pivotal role in ensuring high-quality, patient-centered care and coordination of all functions in the Neuroscience ICU during the designated shift.Key ResponsibilitiesAssists with admission and discharge processes to ensure efficient throughput and high-quality, patient-centered care.Participates in the...


  • Saint-Priest-la-Feuille, Nouvelle-Aquitaine, United States Johnston-Willis Hospital Full time

    IntroductionWe are looking for a Clinical Nurse Coordinator RN for the Intermediate Care Unit at Johnston-Willis Hospital to foster growth and create opportunities. At HCA Healthcare, our mission is to enhance the care and quality of human life. Utilize your leadership abilities and make a significant impact with us. We have recently increased our...

  • Sr Admin Asst

    1 month ago


    La Cienga, NM, United States Christus Health Full time

    In collaboration with Clinical Management and interdisciplinary staff members participates in assessment of educational needs of clinical and non - clinical staff; evaluates effectiveness of curricula through analyses of class participation, feedback and written tests; participates in workshops designed for career advancement of nursing staff; instructs...

  • Sr Admin Asst

    1 month ago


    La Cienga, NM, United States Christus Health Full time

    In collaboration with Clinical Management and interdisciplinary staff members participates in assessment of educational needs of clinical and non - clinical staff; evaluates effectiveness of curricula through analyses of class participation, feedback and written tests; participates in workshops designed for career advancement of nursing staff; instructs...


  • La Mesa, California, United States Sharp HealthCare Full time

    Job SummaryWe are seeking a skilled Licensed Vocational Nurse (LVN) to join our Surgical Float Pool team at Sharp Rees-Stealy Medical Plaza. As an LVN, you will provide high-quality patient care and support to our surgical teams in a fast-paced environment.Key ResponsibilitiesAssist patients, staff, and physicians in maintaining a high level of efficiency...


  • La Mesa, California, United States Sharp HealthCare Full time

    Job SummaryWe are seeking a skilled Licensed Vocational Nurse (LVN) to join our Surgical Float Pool team at Sharp Rees-Stealy Medical Plaza. As an LVN, you will provide high-quality patient care and support to our surgical teams in a fast-paced environment.Key ResponsibilitiesAssist patients, staff, and physicians in maintaining a high level of efficiency...


  • La Plata, United States UMMS ProvidersPhysicians Full time

    Job DescriptionJob DescriptionCompany DescriptionJoin the dedicated and diverse team at University of Maryland Charles Regional Medical Center (UM CRMC), where excellence is our standard. We are consistently recognized among the top 100 Best Places to Work in Maryland, fostering a supportive and stimulating environment for professional growth and...

  • Gastroenterologist

    3 weeks ago


    La Plata, United States University of Maryland Medical System Full time

    Join the dedicated and diverse team at University of Maryland Charles Regional Medical Center (UM CRMC), where excellence is our standard. We are consistently recognized among the top 100 Best Places to Work in Maryland, fostering a supportive and stimulating environment for professional growth and development. At UM CRMC, we are passionate about serving our...


  • La Plata, United States University of Maryland Medical System Full time

    Job Description General Summary: As a Gastroenterologist at UM Charles Regional, you will be entrusted with providing high-quality, efficient, patient-centered, and cost-effective care to our diverse patient population. This role encompasses care delivery in ambulatory, sub-acute, and acute care settings, ensuring comprehensive treatment for all assigned...


  • La Grange, United States Emcor Inc Full time

    Job Title: Project Manager / EstimatorLocation: LaGrange, ILReports to: Sr. Vice PresidentFLSA Status: ExemptPrepared By: Human ResourcesJob SummaryThe Project Manager / Estimator position is a critical role for the company. This individual will be responsible for estimating and providing management with detailed pricing for development of bid quotations and...


  • New Orleans, LA , USA, United States Ochsner Health Full time

    About the RoleWe are seeking a highly skilled and experienced Construction Superintendent to join our team at Ochsner Health. As a key member of our facilities management team, you will be responsible for overseeing the planning, organization, and execution of construction projects across our clinics and hospitals.Key ResponsibilitiesSupervise and coordinate...


  • Alexandria, LA, United States Rapides Regional Medical Center Full time

    Description Introduction Do you want to join an organization that invests in you? At Rapides Regional Medical Center , you come first! HCA Healthcare is committed to the growth and development of our future nurses! The HCA Healthcare StaRN Residency Program is a year-long program designed to give you hands-on experience to help establish...


  • Alexandria, LA, United States Rapides Regional Physician Group – Women’s Health Clinic Full time

    Description IntroductionAre you passionate about the patient experience? At HCA Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as a Licensed Practical Nurse today with Rapides Regional Physician Group – Women’s Health Clinic.BenefitsRapides Regional Physician Group –...


  • Alexandria, LA, United States Rapides Regional Physician Group Womens Health Clinic Full time

    Description Introduction Are you passionate about the patient experience? At HCA Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as a Licensed Practical Nurse today with Rapides Regional Physician Group - Women's Health Clinic. Benefits Rapides Regional Physician Group - Women's...