Prepare for and practice interview questions from Medical Mutual.

Medical Mutual Interview Questions

Medical Mutual Interview Guides

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?

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?

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

Medical Mutual Salaries by Position

About Us Curi is a full-service advisory firm that serves physicians and medical practices. Equal parts fierce physician advocates, smart business leaders, and thoughtful partners, Curis advisory, capital, and insurance offerings deliver valued advice that is grounded in client priorities and elevated by their outcomes. From data-driven advisory services to private wealth offerings, to tailored medical malpractice insurance solutions and beyond, we deliver performance that is time-tested and trustedin medicine, business, and life. The Role Were looking for a skilled and experienced self-starter to work in our Technology department as a Data Engineer. Reporting to our Manager, Data Engineering, you will be involved in data Lakehouse development including requirements gathering, database modeling, ETL and dashboard/report development activities. You will frequently conduct data analysis, write advanced database queries, and optimize data storage needed by business and/or executive operations. You will enable daily business activities by providing the foundation of all federated querying and analysis produced by the BI, Actuarial, and Data Science teams. Key Result Areas Develop and maintain enterprise data warehousing platform <ul> <li>Work with business users to establish data warehousing and data lake requirements </li> <li>Develop and maintain ETL to support the Data and Analytics reporting platform </li> <li>Development of SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems for existing systems </li> <li>Support existing Data Warehouse (Oracle) </li> <li>Participate peer code reviews, unit testing and documentation of code developed </li> </ul>Maintain data Lakehouse, ETL, and reporting environments <ul> <li>Participate in design, coding, testing, implementation, and documentation of solutions </li> <li>Contribute to, enforce, and document database policies, procedures and standards </li> <li>Provide technical and business knowledge support to the team </li> <li>Participate in data governance </li> </ul> <ul><li>Perform tests and evaluations regularly to ensure data security, privacy and integrity </li></ul> Detect and resolve production performance issues <ul> <li>Participate in performance tuning and database optimization </li> <li>Provide ongoing maintenance support through query tuning and optimization </li> <li>Analyze troubleshoot and remediate data integrity issues </li> </ul>Key Skills <ul> <li>Strong working knowledge of: <ul> <li>SQL (including complex querying) </li> <li>Python </li> </ul></li> <li>Must be a self-starter who requires minimal supervision, with excellent problem-solving skills with a focus on data quality and performance optimization </li> <li>Familiarity with Data Lake and/or Lakehouse concepts </li> <li>Exposure to Cloud Database Management Systems </li> <li>Proven ability to design and develop ETL processes for Kimball star schema data warehouse and reporting platform (Oracle preferred) </li> <li>Solid understanding of relational database theory, principles, and best practices </li> <li>Excellent analytical skills with the ability to identify patterns and insights from large datasets </li> <li>Strong collaboration skills to work effectively with cross-functional teams and stakeholders </li> </ul>Qualifications <ul> <li>At least three years of data engineering experience required </li> <li>Property and casualty insurance data experience preferred </li> <li>Bachelor's degree preferred </li> </ul>

Candidate must reside and work in Ohio - Relocation is NOT an option.Sponsorship is not provided for this position Under moderate to limited supervision, conducts routine to moderately complex quantitative analysis supporting strategic business decisions. Focuses on measuring and analyzing customer behaviors across channels and interactions. Primarily works indirectly with internal business customers.ResponsibilitiesCustomer Data Analyst II· Identifies, recommends and implements analytics strategy and approach including routine to moderately complex processes and analyses to deliver meaningful and actionable results as it relates to customer behavior, feedback, operational metrics and segmentation.·Combines data from the customer data warehouse, operational systems, and channel specific reporting systems to deliver actionable insights.·Publishes and communicates results, ensuring timely and accurate reports are delivered to business partners. Develops dashboards and presentations which include solutions to known problems. Responds and follows up on questions from business partners.· Delivers cross-channel metrics and identifies customer trends.·Performs ad-hoc reporting requests as needed.Customer Data Analyst III· Implements analytics strategy and approach, including routine to complex and/or varied processes and analyses to deliver meaningful and actionable results as it relates to customer behavior, feedback and operational metrics and segmentation.· Collaborates with business partners to identify issues and develop statistically valid and methodologically sound approaches to address business needs.· Publishes and communicates results, ensuring timely and accurate insights are delivered to business partners. Develops dashboards and presentations which include solutions to known problems. Responds and follows up on questions from business partners.·Orients, trains and assists more junior level staff.·Performs ad-hoc reporting requests as needed. Sr. Customer Data Analyst · Implements analytics strategy and approach, including complex and/or varied processes and analyses to deliver meaningful and actionable results as it relates to customer behavior, feedback, operational metrics and segmentation· Collaborates with business partners to identify issues and develops and implements statistically valid and methodologically sound approaches to address business needs·Publishes and communicates results, ensuring timely and accurate reports are delivered to the business partners· Provides reporting and analytics to support business processes, including accessing data structures and using analytical tools· Delivers cross-channel metrics which identify customer trends and cross business feedback· Orients, trains and assists and may review work of more junior level staff.· May provide project specific indirect leadership to other analysts within the customer experience department.· Provides limited or indirect supervision or leadership responsibility over a group.· Performs other duties as assigned. Qualifications - ExternalQualificationsCustomer Data Analyst IIEducation and Experience:· Bachelor’s Degree in Statistics, Economics, Social Sciences or related field.·2 years of experience as a Customer Data Analyst or equivalent experience in data or business analytics, preferably in a health insurance environment. Technical Skills and Knowledge:·Knowledge of customer analytics and/or Relationship Management theory and practice.·Intermediate proficiency in SAS, SPSS, SQL and other analytical tools.·Intermediate Microsoft Office skills (word processing, spreadsheets, database reporting, presentation graphics) and other related applications such as Tableau.· Good presentation skills; ability to put together decks and dashboards displaying results. Customer Data Analyst IIIEducation and Experience:·Bachelors Degree in Statistics, Economics, Social Sciences or related field.· 3 years experience as a Customer Data Analyst or equivalent experience in data or business analytics, preferably in a health insurance environment. Technical Skills and Knowledge:· Strong knowledge of Customer Analytics and/or Relationship Management theory and practice.·Strong proficiency in SAS, SPSS, SQL and other analytical tools including Tableau.·Intermediate to advanced Microsoft Office skills (word processing, spreadsheets, database reporting, presentation graphics) and other related applications such as Tableau.·Strong presentation skills; ability to put together decks and dashboards displaying results. Sr. Customer Data AnalystEducation and Experience:·Bachelors Degree in Statistics, Economics, Social Sciences or related field.·Master's Degree preferred.· 5 years progressive experience as a Customer Data Analyst or equivalent experience in data or business analytics, preferably in a health insurance environment. Technical Skills and Knowledge:·Comprehensive knowledge of Customer Analytics and/or Relationship Management theory and practice.·Advanced proficiency in SAS, SPSS and other analytical tools including Tableau.·Advanced Microsoft Office skills (word processing, spreadsheets, database reporting, presentation graphics) and other related applications such as Tableau.·Ability to work with Customer Experience leaders and leaders in other areas to deliver meaningful insights.

About Us Curi is a full-service advisory firm that serves physicians and medical practices. Equal parts fierce physician advocates, smart business leaders, and thoughtful partners, Curis advisory, capital, and insurance offerings deliver valued advice that is grounded in client priorities and elevated by their outcomes. From data-driven advisory services to private wealth offerings, to tailored medical malpractice insurance solutions and beyond, we deliver performance that is time-tested and trustedin medicine, business, and life. The Role Were looking for a skilled and experienced self-starter to work in our Technology department as a Data Engineer. Reporting to our Manager, Data Engineering, you will be involved in data Lakehouse development including requirements gathering, database modeling, ETL and dashboard/report development activities. You will frequently conduct data analysis, write advanced database queries, and optimize data storage needed by business and/or executive operations. You will enable daily business activities by providing the foundation of all federated querying and analysis produced by the BI, Actuarial, and Data Science teams. Key Result Areas Develop and maintain enterprise data warehousing platform <ul> <li>Work with business users to establish data warehousing and data lake requirements </li><li>Develop and maintain ETL to support the Data and Analytics reporting platform </li><li>Development of SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems for existing systems </li><li>Support existing Data Warehouse (Oracle) </li><li>Participate peer code reviews, unit testing and documentation of code developed </li></ul>Maintain data Lakehouse, ETL, and reporting environments <ul><li>Participate in design, coding, testing, implementation, and documentation of solutions </li><li>Contribute to, enforce, and document database policies, procedures and standards </li><li>Provide technical and business knowledge support to the team </li><li>Participate in data governance </li> </ul><ul><li>Perform tests and evaluations regularly to ensure data security, privacy and integrity </li></ul> Detect and resolve production performance issues <ul> <li>Participate in performance tuning and database optimization </li><li>Provide ongoing maintenance support through query tuning and optimization </li><li>Analyze troubleshoot and remediate data integrity issues </li></ul>Key Skills <ul> <li>Strong working knowledge of: <ul> <li>SQL (including complex querying) </li><li>Python </li> </ul></li> <li>Must be a self-starter who requires minimal supervision, with excellent problem-solving skills with a focus on data quality and performance optimization </li> <li>Familiarity with Data Lake and/or Lakehouse concepts </li><li>Exposure to Cloud Database Management Systems </li><li>Proven ability to design and develop ETL processes for Kimball star schema data warehouse and reporting platform (Oracle preferred) </li><li>Solid understanding of relational database theory, principles, and best practices </li><li>Excellent analytical skills with the ability to identify patterns and insights from large datasets </li><li>Strong collaboration skills to work effectively with cross-functional teams and stakeholders </li> </ul>Qualifications <ul> <li>At least three years of data engineering experience required </li><li>Property and casualty insurance data experience preferred </li> <li>Bachelor's degree preferred </li> </ul>

Medical Mutual Interview Questions

Medical Mutual Interview Guides

Medical Mutual Interview Questions

Medical Mutual Salaries by Position

Medical Mutual Opening Jobs