Prepare for and practice interview questions from Baylor Scott & White Health.

Baylor Scott & White Health Interview Questions

Baylor Scott & White Health Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Baylor Scott & White Health Salaries by Position

The Business Analyst I for the Baylor Scott & White Healthplan performs activities to help systems, applications and reporting that are essential to core business processes. ESSENTIAL FUNCTIONS OF THE ROLE Coordinates and facilitates process improvem Business Analyst, Business, Health, Analyst, Operations, Technology, Healthcare, Systems

**JOB SUMMARY** The Enterprise Data Architect is accountable for data architecture, integration, design, development, implementation to deliver modern business intelligence, analytics and data warehousing solutions for the enterprise. This role will also ensure the optimal and scalable solutions are implemented and provide guidance and direction on data conversion, data migration, data quality and data load performance. The Enterprise Data Architect works with customers in assisting with, gathering, reviewing and interpretation of business and technical requirements and understanding use case targets. This role trains and helps less experienced developers & analysts, and is a leader in helping methodologies and processes, as well as streamlining development (focus on reusable code) for faster delivery to end customers. **ESSENTIAL FUNCTIONS OF THE ROLE** + Develops strategic data architecture for enterprise data warehouses used for analytics and healthcare use cases. + Develops database and data solutions by designing data architectures, including business architecture definition, data storage, data analytics, data transformation, and data access + Provides delivery leadership in the design, deployment and data conversion of complex data solutions, including data validation, UAT and Data Quality practices + Accountable for validation of the data quality and integration of all data architecture components, and capture of necessary data architecture metrics for benchmarking and trending to help quality of processes and related artifacts. + Examines detailed end user specifications which includes architecting, designing and developing solutions to accommodate business requirements. + Accountable for creation and communication of data architecture, data integration, profiling standards and best practices + Assists developers and analysts in the design and profiling, provides training and learning opportunities. + Establishes and participates in data management processes including data lineage, data profiling, data quality management and governance. + Performs other position appropriate duties as required in a competent, professional and courteous manner. **KEY SUCCESS FACTORS** + Must have at least 10 years of experience in Data Integration using integration tools like DBT and ADF + Must have 2+ years of experience working with Snowflake, preferably in Azure cloud + Must have at least 10 years of experience in database development using SQL + Must have at least 5 years of experience in architecture and design of Enterprise Data Warehouse environments. + Must have CI/CD experience + Must have experience coding in Python + Must possess excellent documentation and communication skills + 2+ years Healthcare experience is preferred. + Knowledge and expertise of all aspects of database tuning, data access, data manipulation, SQL, and physical storage. + Experience with development and execution of database security policies, procedures and auditing-experience with database authentication methods, authorization methods, and data encryption techniques. + Experience helping technology strategy / roadmap. + Performs code reviews and Design and develop test plans for unit testing. **SCHEDULE** : Hybrid - Mostly remote but may need to come into the Dallas office from time-to-time **BENEFITS** Our competitive benefits package includes the following + Immediate eligibility for health and welfare benefits + 401(k) savings plan with dollar-for-dollar match up to 5% + Tuition Reimbursement + PTO accrual beginning Day 1 Note: Benefits may vary based upon position type and/or level **MINIMUM QUALIFICATIONS** + EDUCATION - Bachelor's + EXPERIENCE - 10 Years of Experience As a health care system committed to improving the health of those we serve, we are asking our employees to model the same behaviours that we promote to our patients. As of January 1, 2012, Baylor Scott & White Health no longer hires individuals who use nicotine products. We are an equal opportunity employer committed to ensuring a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

**Background** Baylor Scott and White Health (BSWH) is uniquely positioned to revolutionize the way healthcare is delivered. Since 2017, BSWH has invested in modern technology, processes, people, and the cultural mindset to think radically and serve its consumers as a digital organization while delivering high quality care across the entire care continuum. The healthcare industry faces many problems affordability, substandard customer service, and inconsistency in care quality and is not designed around the consumer needs. BSWH is on its journey to reimagine a system that is built around the needs of the customers it serves with high-value solutions to alleviate these pain points. As part of its transformation, BSWH is building a customer-centric healthcare ecosystem and is incubating and commercializing new products and services that solve unmet consumer needs as part of a new Consumer Solutions business, an internal startup formed within the health system. Our initial product categories will focus on maintaining health, immediate care, and specialty care. We are looking for people to join this exciting new team of passionate problem solvers that want to shape the future of healthcare delivery and reimagine the healthcare experience for consumers. **Position Summary:** The Product Manager for the Immediate Care product category will report directly into the Director of Product, Immediate Care. This role sits at the forefront of BSWHs innovation agenda and will be responsible for supporting the planning, development, and launch of new, innovative products within the Immediate Care category that differentiate BSWH in the market. The Product Manager will execute on the product roadmap, assist in the development of key product features, product documentation and support go-to-market planning. This is an exciting opportunity to be part of an innovative team that is changing the status quo in how a healthcare provider goes to market and provides an environment that stimulates professional growth. **Jobs to Be Done:** + Execute product roadmap aligned with BSWH strategy and organizational objectives + Produce actionable insights to build product problem statement and use cases, including buyer and user personas + Analyze research to develop preliminary recommendation of external partners based on track record, current capabilities, and long-term outlook + Synthesize data to conduct addressable market assessment and sizing, as well as inventory the competitive landscape + Support scalability of products across BSWH enterprise + Be responsible and accountable for the implementation and success of each product launch + Execute product OKRs and continuously monitor and report on progress. + Product manage an agile team to decompose the strategy and roadmap into features and user stories + The scope of those features and user stories should address people, process, and technology concerns + Fulfill the traditional agile role of Product Owner + Analyze research to develop preliminary recommendation of external partners based on track record, current capabilities, and long-term outlook + With the assistance of Engineering on the agile team, scope and define technical work to support the product roadmap and operational processes + With the assistance of the Enterprise Data and Analytics groups, establish reporting to monitor product performance + Use customer and staff insights to drive continuous improvement after product launch + Liaise with members of the agile team as required to support their efforts + This may include thought partnership while defining processes, technical build, metrics, etc. + Recommend opportunities to improve the product roadmap to the Director of Product **Responsibilities:** + Execute product roadmap aligned with BSWH strategy and organizational objectives + Ensure business requirements are translated into technical implementation + Support scalability of products across BSWH enterprise + Produce actionable insights to build product problem statement and use cases, including buyer and user personas + Analyze research to develop preliminary recommendation of external partners based on track record, current capabilities, and long-term outlook + Synthesize data to conduct addressable market assessment and sizing, as well as inventory the competitive landscape + Assess for and apply process improvements to optimize operations and financial performance + Partner with Director of Product to work with internal stakeholders (e.g. engineering, operations, finance) to understand use cases, assess costs and feasibility, and align product development with BSWH objectives + Collaborate with customer relationship counterparts to bring in the voice of the customer and ongoing strategy into the product delivery + Synthesize market intelligence data to help identify areas for enhancements until product reaches maturity + Support go-to-market strategies within product line + Assist in assessment of promotion channels and implement campaigns by channel to reach customers + Monitor and analyze product performance and competitive environment to support refinement of go-to-market strategy + Support implementation team in successful launch and implementation of products + Ability to work with and manage external vendors and provide support with contracting efforts **Benefits** Our competitive benefits package includes the following + Immediate eligibility for health and welfare benefits + 401(k) savings plan with dollar-for-dollar match up to 5% + Tuition Reimbursement + PTO accrual beginning Day 1 Note: Benefits may vary based upon position type and/or level **PREFERRED QUALIFICATIONS:** + 5+ years of professional experience in healthcare or digital product management, product operations, or similar roles. + Experience with building new products following an agile methodology + Knowledge and experience with Azure DevOps agile project management + Prior experience in a healthcare organization or health-related startup, particularly in the navigation space + Experience working with products that utilize chatbot, LLM, and generative AI technologies + Experience with AB testing and product driven hypothesis testing + Strong program management skills and ability to collaborate with multiple stakeholders to drive a process forward. + Experience assessing and managing vendors + Exhibits a growth-mindset; can be nimble, is able to continuously test, learn, iterate, and pivot to meet customer needs + Able to coach and guide a high-performing team + Embraces ambiguity and thrives in a startup environment + Has a strong customer orientation and appreciates the value of customer research and journey mapping + Ability to travel to Dallas, as needed **MINIMUM QUALIFICATIONS** + EDUCATION - Bachelor's or 4 years of work experience above the minimum qualification + EXPERIENCE - 5 Years of ExperienceAs a health care system committed to improving the health of those we serve, we are asking our employees to model the same behaviours that we promote to our patients. As of January 1, 2012, Baylor Scott & White Health no longer hires individuals who use nicotine products. We are an equal opportunity employer committed to ensuring a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Baylor Scott & White Health Interview Questions

Baylor Scott & White Health Interview Guides

Baylor Scott & White Health Interview Questions

Baylor Scott & White Health Salaries by Position

Baylor Scott & White Health Opening Jobs