Prepare for and practice interview questions from Trillium health resources.

Trillium health resources Interview Questions

trillium health resources works in partnership with people who face significant challenges related to substance abuse, mental illness and/or developmental disability. our commitment is to provide consistently excellent, person-centered, family-oriented services within a recovery-based system that is flexible, accessible, and respects the individual's freedom of choice.

trillium health resources works in partnership with people who face significant challenges related to substance abuse, mental illness and/or developmental disability. our commitment is to provide consistently excellent, person-centered, family-oriented services within a recovery-based system that is flexible, accessible, and respects the individual's freedom of choice.

Overview

Trillium health resources 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?

Trillium health resources Salaries by Position

Pay Plan Title: IT Applications/Report Developer Working Title: Network Management Data Engineer Cost Center: 45/Network FLSA Status: Exempt Posting Salary Range: $60,409 - $95,359 Office Location: Remote in North Carolina POSTING DETAILS: Make an Impact Trillium Health Resources is a local governmental agency (LME/MCO) in North Carolina that manages serious mental health, substance use, and intellectual/developmental disability services. Serving in 46 counties, we help individuals and their families strengthen well-being and build foundations for a healthy life. Join our team as we empower others to live their best lives by providing access to quality healthcare. We offer a challenging, engaging work environment where staff take home more than a paycheck. Every day, we see the results of our dedication in the smiles of children on our accessible playgrounds and in the pride on the face of an adult cooking a meal for the first time. Working at Trillium Health Resources is more than just a job; it is an opportunity to make a direct impact on the communities we serve. At Trillium, we know that empowering others begins with supporting and developing our team. Thats why we offer competitive benefits and work-from-home flexibility so that our employees thrive outside of the office. Were also committed to building a diverse, inclusive culture where all employees have the potential to grow professionally and personally. What Were Looking For Trillium Health Resources is transforming public health in North Carolina by managing the health needs of many of the states most vulnerable populations. After successfully implementing managed care for mental health, substance use, and intellectual/developmental disabilities in the early 2010s, were currently implementing a groundbreaking new type of Medicaid health plan that focuses on peoples physical health needs, as well as factors like housing and food insecurity that can affect health. Were seeking a Network Management Data Engineer who wants to grow their career by helping us implement this new model. Youll work directly with team members from all parts of our organization to evaluate the efficacy of value based reimbursement (VBR) strategies employed within the organization. The Network Management Data Engineer is responsible for creating measurement methodology and for determining correct measures to be used based on desired outcomes of specific value based reimbursement programs. On a typical day, you might: <ul> <li>Work with various databases to collect, analyze and report data related to provider performance, statistical data on populations, disabilities, and cultural factors, and financial impact of value-based purchasing (VBP). </li> <li>Design, develop and maintain Trillium Practice Management and/or Network Management reports. </li> <li>Use reporting platforms, including SQL/SSMS, Power BI, and third-party solutions. </li> <li>Plan, coordinate and implement security measures to safeguard information in VBP files against accidental or unauthorized damage, modification or disclosure. </li> <li>Develop data reference and workflow documents for documentation purposes and operations in Practice Management. </li> </ul> Employee Benefits: Trillium knows that work/life balance is important. Thats why we offer our employees competitive benefits and flexibility that is second to none. Take a look at what we have to offer: Flexible Work Schedules Health Insurance - no premium for employee coverage Flexible Spending Accounts Paid Time Off (PTO) of 24 days, plus 12 paid holidays within first year of employment NC Local Government retirement pension, plus 401k with 5% employer match & immediate vesting Public Service Loan Forgiveness Qualifying Employer Qualifications: Education: High School or Associates Degree Required - HS and Associate degrees both require certification. Experience: High School diploma and three (3) years experience in any of the following areas: Information Technology / MIS, Mathematics (Actuarial/ Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, Human Service field, healthcare claims environment, reporting development, n-tier and web-based system development or support with strong technical knowledge in the specialized areas of application system programming, including software tools such as: SQL Server 2008 R2 or above, SQL, Oracle, NoSQL, MySQL, TFS (Team Foundation Server), Microsoft IIS and Microsoft .NET framework2.0 or above , Source Control, SSRS, SSIS, SSAS, SSMS, Visual Studio BIDS, Visual Studio 2008 or above, C#. Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements. OR Associates degree in Information Technology/MIS, Mathematics (Actuarial/Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, or Human Service Field and one (1) year experience in any of the following areas: Information Technology / MIS, Mathematics (Actuarial/ Statistics), Data Analytics, Engineering Sciences, Business, Healthcare Administration, Human Service field, healthcare claims environment, reporting development, n-tier and web-based system development or support with strong technical knowledge in the specialized areas of application system programming, including software tools such as: SQL Server 2008 R2 or above, SQL, Oracle, NoSQL, MySQL, TFS (Team Foundation Server), Microsoft IIS and Microsoft .NET framework2.0 or above , Source Control, SSRS, SSIS, SSAS, SSMS, Visual Studio BIDS, Visual Studio 2008 or above, C#. Requires certification. Applicable certification(s) may be substituted to equivalent degree and experience requirements. OR Equivalent combination of education and experience. Preferred Experience: <ul> <li>Recent Experience with SQL database management or report development </li> <li>SPSS, SPSS-X, R, Python, or similar software and/or Microsoft Power BI </li> <li>Standard coding and structures like CPT, ICD, etc. </li> <li>Managed care organization/environment or clinical setting </li> <li>Working knowledge of the MH/SU/IDD service array and benefits offered by various funding sources and provided through a network of providers preferred. </li> <li>Working knowledge of the HCP-LAN APM Framework. </li> </ul>License/Certification: High School and Two year degree requires certification Preferred: Applicable certification(s) including Microsoft data systems certifications CSTP, ISTQB, ASTQB, MTA, MCSA, MCSD, MCSE, ITIL v3, Power BI, as well as INFORMS, IIBA, AWS, Azure, CSPA, Certified Machine Learning Specialty (AWS), Predictive Analytics Certificate (SOA), and/or CPHIMS/CAHIMS or equivalent certifications will be accepted. Must have a valid drivers license Must reside in NC to be consider for remote status Deadline for application: 08/26/2024 @11:59PM To be considered for employment, all candidates are required to submit an application through ADP and upload a current resume. Your resume must provide your level of education and detailed work experience, including: <ul> <li>Employer Name <ol> <li>Dates of service (month & year) </li> <li>Average number of hours worked per week </li> <li>Essential duties of the job as related to the position youre applying for </li></ol> </li> <li>Education <ol> <li>Degree type </li> <li>Date degree was awarded </li> <li>Institution </li></ol> </li> <li>Licensure/certification, if applicable </li></ul> After submitting your application through our career center in ADP, your resume will be reviewed to ensure that your skills and experience meet the essential criteria for the role you have applied for. Join our Talent Community through our ADP career center to stay informed about positions you may qualify for. Remember to keep an update resume in the Talent Community profile. The diversity of the communities we serve is reflected in our employees. Trillium Health Resources is an Equal Employment Opportunity (EEO) employer. Trillium Health Resources is a drug-free workplace. Candidates are required to pass a drug test as a condition of employment. #Innovation #Technology #Careers #NorthCarolina #BehavioralHealth

Make an Impact
Trillium Health Resources is a local governmental agency (LME/MCO) in North Carolina that manages serious mental health, substance use, and intellectual/developmental disability services. Serving in 28 counties, we help individuals and their families strengthen well-being and build foundations for a healthy life.
Join our team as we empower others to live their best lives by providing access to quality healthcare. We offer a challenging, engaging work environment where staff take home more than a paycheck. Every day, we see the results of our dedication – in the smiles of children on our accessible playgrounds and in the pride on the face of an adult cooking a meal for the first time. Working at Trillium Health Resources is more than just a job; it is an opportunity to make a direct impact on the communities we serve.
At Trillium, we know that empowering others begins with supporting and developing our team. That’s why we offer competitive benefits and work-from-home flexibility so that our employees thrive outside of the office. We’re also committed to building a diverse, inclusive culture where all employees have the potential to grow professionally and personally.
What We’re Looking For
We’re seeking a Business Intelligence Analyst who wants to grow their IT career by helping us conduct data analysis activities for Trillium. You’ll work directly with team members from all parts of our organization to assure compliance with the DMH and DMA contract requirements as well as other external and internal reporting needs. The Business Intelligence Analyst is responsible for the validation of data collected and ensuring data integrity. You’ll be a valued member of the Informatics Data Report.
On a typical day, you might:
Ensure that data from reports are presented in a user-friendly format and made accessible to staff, consumers, and community members.
Analyze and report statistical data on populations, disabilities, and cultural factors.
Provide technical assistance to other Trillium department staff or provider agencies regarding data collection, analysis, and reporting.
Use SQL and various analytical programs such as R, SPSS, or Python for analysis of data.
Use KACE and Team Foundation Server (TFS) to respond to organizational requests, document and track progress, and maintain version control of reports and code.
Employee Benefits:
Trillium knows that work/life balance is important. That’s why we offer our employees competitive benefits and flexibility that is second to none. Take a look at what we have to offer:
Flexible Work Schedules. Remote work was a strong part of our culture prior to COVID-19, and currently, employees may work remotely 100% of the time, with an in-office option available for those who prefer that.
Paid Time Off (PTO) of 23 days per year, plus 10 paid holidays in the first year of employment.
Health Insurance - no premium for employee coverage.
NC Local Government retirement pension. This is a defined-benefit retirement plan that will pay you a monthly amount upon retirement, for the rest of your life, with as little as five years of service. For more information, go to: LGERS Handbook .
401k with 5% employer match & immediate vesting.
Public Service Loan Forgiveness Qualifying Employer.
Flexible Spending Accounts.
Qualifications:
Education: Associate’s Degree OR, based on required experience / Bachelor’s Degree.
Required Experience: Associate’s degree in Information Technology, Actuarial/Statistics, Data Analytics, Business, or Human Service field (such as Psychology, Social Work, etc.) and four (4) years’ experience in Information Technology, Actuarial/Statistics, Data Analytics, Business, or Human Service field (such as Psychology, Social Work, etc.).
OR
Bachelor’s degree in Information Technology, Actuarial/Statistics, Data Analytics, Business, or Human Service field (such as Psychology, Social Work, etc.) and a minimum of two (2) years’ experience in Information Technology, Actuarial/Statistics, Data Analytics, Business, or Human Service field (such as Psychology, Social Work, etc.).
OR
Equivalent combination of education/experience.
License/Certification: None Identified.
Preferred License/Certification (if applicable): CSPA, Certified Machine Learning – Specialty (AWS), Predictive Analytics Certificate (SOA), and/or CAHIMS, ITIL v3 or equivalent certifications preferred.
Must have a valid driver’s license.
Remote with office locations available in Greenville or Wilmington, NC.
Deadline for application: Posting closed on Wednesday, November 22, 2023, at 11:59 p.m.
To be considered for employment, all candidates are required to submit an application through ADP and upload a current resume. Your resume must provide your level of education and detailed work experience, including:
Employer Name
Dates of service (month & year)
Average number of hours worked per week
Essential duties of the job as related to the position you’re applying for.
Education
Degree type
Date degree was awarded
Institution
Licensure/certification, if applicable.
After submitting your application through our career center in ADP, your resume will be reviewed to ensure that your skills and experience meet the essential criteria for the role you have applied for.
Join our Talent Community through our ADP career center to stay informed about positions you may qualify for. Remember to keep an updated resume in the Talent Community profile.
The diversity of the communities we serve is reflected in our employees. Trillium Health Resources is an Equal Employment Opportunity (EEO) employer.
Trillium Health Resources is a drug-free workplace. Candidates are required to pass a drug test as a condition of employment.

#J-18808-Ljbffr

Trillium health resources Interview Questions

Overview

Trillium health resources Interview Guides

Trillium health resources Interview Questions

Trillium health resources Salaries by Position

Trillium health resources Opening Jobs