Prepare for and practice interview questions from Healthedge.

Healthedge Interview Questions

Healthedge Interview Guides

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

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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Healthedge Salaries by Position

Overview Customer Data Analyst The Data & Analytics team atWellframebrings new and existingcutting-edgemachine learning technologies to solve problems at the intersection of healthcare and technology. Our mission is to gain 360-degree insights into patients lives and use these insights to build a better digital healthcare product that is tailored for specific patient populations. We are seeking aDataAnalyst tojoin ourData & Analytics teampartneringclosely with our Customer Successand ProductOrganizationstoidentifyand deliver customer insights. Reportingintothe Director, Data & Analytics, this individual willbe responsible forquerying, analyzing,visualizing, and presentingcustomerdata toprovide insights to customers in pursuit ofsupporting their strategic goals. Your impact: Data Analysis and Insights Utilize SQL and git to build new analyses and support existing onesexaminingtrends and patterns toultimatelyincreaseunderstanding of customer behavior, product usage, and satisfaction and maximize customer growth potential Communicatefindingsto various company stakeholders (customer success, product)in a cohesive story, including summarizing insights from analyses,identifyingnextstepsand providing recommendations Responsible for the design, development, maintenance, accuracy, andtimelydelivery of reports andanalysesto meet company and customer needs Customer Experience Optimization Help drive change in usage of data through actively surfacing and conveying customer specific insights toaccount facing teams and customers Partner with account facing teams and customers to translate customer business needs into data deliverables in for the form of analyses, standard reports, data extracts Consistentlyprovidestrong data-driven business and technical judgement to support customer business needs Create training materials and tip sheets to help customers bestutilizereporting and data products Internal Data Support & Tracking Participate in ad-hoc projects andinitiativessuch as:expanding data warehouse with clean data ready for analysis, incorporating new metricsinto our BI tool Train other functional team members on the reporting tool(s) and best practices from a data analytics perspective What you bring: Bachelors Degree 1-3yearsof experience working with big data for healthcare Expertisewith Looker or other Business Intelligence/Visualization Tools such as Tableau, Power BI, etc. Expertisewith SQL and Excel Understanding of how relational databases work, and experience with designing transformations, mappings, and working with reference tables Experience investigating data issues, and working with cross functional teams forproblem resolution Highproficiencywith PowerPoint, G Suite, and Microsoft Office tools Who you are: Excellent communication skills with a proventrack recordof communicating well with internal and external stakeholders Strong analytical thinking - effective atidentifyingthe critical question, capable of navigating tradeoffs between accuracy / comprehensiveness / complexity vs. speed and simplicity Can distill more complex analysis into simple charts to communicate key takeaways Ability to document work, issues, and communicate standards and requirements Can do attitude and willingness to think beyond the status quo Strong attention to detail HealthEdge commits to building an environment and culture that supports the diverse representation of our teams. We aspire to have an inclusive workplace. We aspire to be a place where all employees have the opportunity to belong, make an impact and deliver excellent software and services to our customers. Work Environment: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job: The employee is occasionally required to move around the office. Specific vision abilities required by this job include close vision, color vision, peripheral vision, depth perception, and ability to adjust focus. Work across multiple time zones in a hybrid or remote work environment. Long periods of time sitting and/or standing in front of a computer using video technology. May require travel dependent on company needs. The above statements are intended to describe the general nature and level of the job being performed by the individual(s) assigned to this position. They are not intended to be an exhaustive list of all duties, responsibilities, and skills required. HealthEdge reserves the right to modify, add, or remove duties and to assign other duties as necessary. In addition, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position in compliance with the Americans with Disabilities Act of 1990. Candidates may be required to go through a pre-employment criminal background check. HealthEdge is an equal opportunity employer. We are committed to workforce diversity and actively encourage all qualified persons to seek employment with us, including, but not limited to, racial and ethnic minorities, women, veterans and persons with disabilities. LI-Remote Job Locations US-Remote ID 2024-4756 Category Hidden (29003) Position Type Full-Time HealthEdge provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type 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.

Senior Data Engineer What will you do:<ul><li>Build data pipelines to assemble large, complex sets of data that meet non-functional and functional business requirements</li><li>Develop ETL solutions using Python, Powershell, SQL, SSIS etc. to load and automate complex datasets in PDF, Excel, flat files, JSON, XML, EDI etc.</li><li>Take the full ownership of end-to-end data processes on Azure Cloud environments</li><li>Work closely with data architect, SMEs and other technology partners to develop & execute data architecture and product roadmap</li><li>Collaborate with the backend developers independently to understand the legacy applications and implement the features in a new system.</li><li>Troubleshoot issues and other operational bottlenecks to support continuous data delivery for various applications.</li><li>Take initiatives to make changes and improvements, work on technical debt, new and complex challenges.</li><li>Implement complex warehouse views, make database design decisions to support the UI need, optimize scripts to periodically refresh large volume datasets.</li><li>Perform code reviews and coach team members</li><li>Develop reports on data dictionary, server metadata, data files and implement the reporting tools as needed.</li><li>Implement best practices for data updates and development, troubleshoot performance and other data related issues on multiple product applications.</li><li>Keep current on big data and data visualization technology trends, evaluate, work on proof-of concept and make recommendations on cloud technologies.</li></ul>What you bring:<ul><li>5-7+ years of data engineering experience working in partnership with large data sets and cloud architecture</li><li>Deep experience in building data pipelines using the ETL tools and paradigms and loading data to and from RDBMS such Postgres, SQL Server, Oracle or similar.</li><li>Proficient in cloud services technologies such as Microsoft Fabric, Azure Data Factory, Data Lake, and other related technologies</li><li>Proficient in using SSDT tools for building SQL server relational databases, databases in Azure SQL, Analysis Services data models, Integration Services packages and Reporting Services reports</li><li>Solid experience building data solutions with the programming languages such as Python, Powershell</li><li>Advanced T-SQL and ETL automation experience</li><li>Experience working with orchestration tools such as Airflow and building complex dependency workflows</li><li>Self-motivated with the ability to work and learn new technology independently</li><li>Great problem-solving capabilities, troubleshooting data issues and experience in stabilizing big data systems.</li><li>Excellent communication and presentation skills</li></ul>Bonus points:<ul><li>Hands-on deep experience with cloud data migration, and experience working with analytic platforms like Fabric, Databricks on the cloud</li><li>Certification in one of the cloud platforms (AWS/GCP/Azure)</li><li>Experience with real-time data streaming tools like Kafka, Kinesis or any similar tools.</li><li>Experience with the US health care reimbursement-related terminology and data is a plus</li></ul>

Healthedge Interview Questions

Healthedge Interview Guides

Healthedge Interview Questions

Healthedge Salaries by Position

Healthedge Opening Jobs