Prepare for and practice interview questions from Symetra.

Symetra Interview Questions

Symetra 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

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 you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Symetra Salaries by Position

Symetra has an exciting opportunity to join our team as a Healthcare Data Analyst!
About the role
In this role, you will review and analyze medical and pharmacy claims data to identify high risks and help optimize the underwriting process. You will create, analyze, and provide claim overviews to underwriters, nurses, and management. 
What you will do
<ul>
<li>Data reporting, analytics, and mining. Coordinate with relevant departments to determine areas for analysis and the appropriate metrics to use for ensuring data analysis is useful.</li>
<li>Leverage clinical expertise and system data manipulation skills to review large, complex reports and identify individuals with potentially catastrophic claims.</li>
<li>Prepare "Shock Claims Summaries" - Review underwriting group reports to identify and extract data corresponding to individuals diagnosed with potentially catastrophic conditions and present to Underwriting.</li>
<li>Customize report review guidelines - Create, document, update and publish step-by-step guidelines crafted to facilitate the consistent review of underwriting reports (e.g., UHC, Aetna, Cigna, BCBS Plans, etc.).</li>
<li>Interact with Underwriting and Medical Risk Consultants to discuss significant risk findings on new and renewal business experience reports.</li>
<li>Work on special assignments or projects as requested.</li>
</ul>
Why Work at Symetra
Here's what some of our employees have to say about why they work at Symetra:
"If you're looking for a place to call home, grow professionally and personally and most importantly, be yourself, Symetra is the right fit." Daniel P. - Senior Underwriter
"We're big enough to make an impact on the country, but small enough to care and know who you are and what you're contributing to the organization. All new ideas are welcome!" Stephanie F. - VP Customer Service & Operations 
What we offer you
Benefits and Perks
We don't take a "one-size-fits-all" approach when it comes to our employees. Our programs are designed to make your life better both at work and at home.
<ul>
<li>Flexible full-time or hybrid telecommuting arrangements</li>
<li>Plan for your future with our 401(k) plan and take advantage of immediate vesting and company matching up to 6%</li>
<li>Paid time away including vacation and sick time, flex days and ten paid holidays</li>
<li>Give back to your community and double your impact through our company matching </li>
<li>Want more details? Check out our Symetra Benefits Overview</li>
</ul>
Compensation
Hourly Range: $28.09 - $46.80 plus eligibility for annual bonus program 
Who You Are
<ul>
<li>Certified Coding Specialist (CCS), Certified Coding Specialist - Physician-Based, (CCS-P), Certified Professional Coder-Payer (CPC-P), or Registered Health Information Administrator (RHIA) required.</li>
<li>Must have completed and passed a formal medical coding education program.</li>
<li>Associate degree in Health Management or Health Information Management required.</li>
<li>3-5 years' experience in a remote setting that is related to medical coding, healthcare (hospital, managed care, medical group) analytic or reporting environment required.</li>
<li>Technical aptitude including proficiency with the MS Office Suite of applications and intermediate to advanced Excel skills.</li>
<li>David Young/ESL experience a plus.</li>
<li>Data manipulation, analysis, and interpretation skills.</li>
<li>Critical thinking and problem-solving skills. </li>
<li>High attention-to-detail.</li>
<li>Able to prioritize, effectively manage time and meet deadlines.</li>
<li>Comfortable working independently and collaborating in groups.</li>
<li>Excellent written and verbal communications skills.</li>
<li>Demonstrated experience working effectively in a virtual environment.</li>
<li>Experience in first dollar medical claims and case management preferred.</li>
<li>Experience in group medical insurance, Excess Loss or as a Reinsurance Licensed Practical Nurse, Certified Medical Assistant, or other healthcare equivalent preferred.</li>
<li>Some minimal travel preferred.</li>
</ul>
We empower inclusion
At Symetra, we aspire to be the most inclusive insurance company in the country. We're building a place where every employee feels valued, respected, and has opportunities to contribute. 
Inclusion is about recognizing our assumptions, considering multiple perspective, and removing barriers. We accept and celebrate diverse experiences, identities, and perspectives, because lifting each other up fuels thought and builds a stronger, more innovative company. We invite you to learn more about our efforts here.
Creating a world where more people have access to financial freedom
Symetra is a national financial services company dedicated to helping people achieve their financial goals and feel confident about the future. In our daily work, we're guided by the principles of Value, Transparency and Sustainability. This means we provide products and services people need at a competitive price, we communicate clearly and openly so people understand what they're buying, and we design products-and operate our company-to stand the test of time. We're committed to showing up for our communities, lifting up our employees, and standing up for diversity, equity and inclusion (DEI). Join our team and help us create a world where more people have access to financial freedom.
For more information about our careers visit: https://symetra.eightfold.ai/careers
Work Authorization
Employer work visa sponsorship and support are not provided for this role. Applicants must be currently authorized to work in the United States at hire and must maintain authorization to work in the United States throughout their employment with our company.
#LI-NW1
#LI-Remote

Symetra Interview Questions

Symetra Interview Guides

Symetra Interview Questions

Symetra Salaries by Position

Symetra Opening Jobs