Prepare for and practice interview questions from Commonwealth care alliance.

Commonwealth care alliance Interview Questions

Commonwealth care alliance Interview Guides

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?

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

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

Commonwealth care alliance Salaries by Position

**Why This Role is Important to Us:** The Senior Software Engineer will support, maintain, & develop CCA business applications and integrations. This position will be technical leader within the Product Engineering team, involved in various stages of the end-to-end software development lifecycle, with specific responsibilities related to the requirements, architecture, design, development and support of CCA software applications and software data integrations. The Senior Software Engineer is responsible for the development and maintenance of data processes and applications designed to integrate various business systems, this may include web applications and services, API, ETL processes, and job orchestration spanning all systems and functional areas including but not limited to finance, claims, enrollment, and clinical. The Senior Software Engineer works to improve quality and efficiency across the organization. CCA's systems have largely grown up from a small-company environment to an environment requiring high availability, accessibility, ease of use, technological sophistication, reliability in handling complex data, and large user base. Integration between and among technology layers is vital to maintaining accurate, timely and robust service delivery to our business users, members, and providers. Mentors software engineers at CCA (in the U.S) Leads remote off-shore engineering and IT consulting teams on a daily basis **Supervision Exercised:** None **What You'll Be Doing:** + Supports the maintenance and enhancement of business-critical web-based applications in production Conducts technical root cause analysis and lead solution for production issues + Supports the analysis of business requirements, design specifications, development, and technical and user documentation of report development through direct interaction with internal customers + Communicates issues, risks, and ideas to appropriate audience + Seeks assistance in a timely manner + Escalates risks and needs in an appropriate manner + Provides status updates on regular cadence as requested by management team + Support the research, recommendation, and innovation and usage of new processes, tools, software and digital development technologies + Functions as technical leader within the Product Engineering team and across IT as appropriate + Identifies areas of deficiency and drive improvements. + Comfortable holding high-level technical discussions on topics like web development, OAUTH setup, API, data transformations + Expands and optimizes data and data pipeline architecture, as well as optimizes data flow and collection for cross functional teams + Works closely with business partners, data scientists, and cross-discipline developers in order to build and maintain CCA systems and processes + Identifies, designs, and implements internal process improvements: automating manual processes, optimizing user experience, data delivery, and re-designing infrastructure for greater scalability. + Is familiar with troubleshooting techniques + Assists creating technical how-to documents when necessary + Learns quickly and take on new challenges. + Possesses strong business analytical and IT knowledge and communication skills ability to talk to business stakeholders and map their business requirements to IT initiatives, projects, tasks + Creates and maintains Jira tickets, tracking, updates and follow-up **Working Conditions:** Standard office conditions **What We're Looking For:** **Education Required:** + Bachelors degree or equivalent work experience **Education /Certification Desired:** + Masters in computer science or related focus-area preferred + SQL certification(s) preferred + MuleSoft API certification(s) preferred + Talend certification(s) preferred **Experience Required:** + Minimum of 5 years of experience in a hands-on software development + Experience in writing, troubleshooting, and optimizing SQL statement, functions, and procedures in professional environment + Relational database development experience and proficiency with advanced SQL concepts such as complex joins, triggers, cursors, correlated sub queries, analytic functions (MS-SQL Server, Oracle, T-SQL, or PL/SQL) + Experience working with one or more Source Control tools (such as SVN, CVS, Git, TFS, Rational ClearCase) + Batch job processing with scripting + Experience working with end users to gather requirements and build technical solutions from concept to implementation. + Experience with data modeling including normalization, logical and physical designs. **Experience Desired:** + Software integrations experience preferred + MS-SQL Server experience preferred + API development experience preferred + Web service experience preferred + Electronic Data Interchance (EDI) experience preferred + Experience working within in both Waterfall and Agile methodologies preferred + Healthcare experience preferred + Experience working within a DevOps DevSecOps Continuous Integration Continuous Delivery (CICD) environment preferred + Experience with Salesforce preferred + Hands-on MuleSoft API experience preferred + Experience implementing web security protocols and systems (http, oauth 2.0, saml, LDAP) preferred **Knowledge, Skills & Abilities:** + Demonstrated skill with programming languages + Demonstrated knowledge of software development in a professional environment + Demonstrated skills in technical leadership + Demonstrated skills in SQL + Ability to present accurate development effort estimates and provide timely updates + Ability to manage and keep track of multiple tasks simultaneously + Proven ability to develop detailed solution designs + Understands architecture constructs (architecture/design patterns, SOAP, REST etc.). + Ability to develop solutions that consider the long and short-term perspectives of business priorities and that are maintainable and extensible. + Strong written and verbal communication skills + Detail oriented and well organized + Knowledge of software development life cycles and industry best practices + Ability to work calmly and constructively under pressure and deliver on commitments **Knowledge, Skills & Abilities Desired:** + C# .Net background preferred + Talend background preferred + Python background preferred + SSIS background preferred + Salesforce background preferred + Understanding of HIPAA and the importance of patient data privacy preferred + Understanding of cloud architecture/offerings such as AWS, Azure, and GCS (compute, storage, networking) tools preferred **Other:** + May perform data wrangling/cleansing techniques to conduct statistical analysis and identifying key insights for decision makers. + May create and maintain optimal data pipeline architecture from various databases that include SQL, Oracle DB, Teradata, Bigdata, etc. EEO is The Law Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled Please note employment with CCA is contingent upon acceptable professional references, a background check (including Mass CORI, employment, education, criminal check, and driving record, (if applicable)), an OIG Report and verification of a valid MA/RN license (if applicable). Commonwealth Care Alliance is an equal opportunity employer. Applicants are considered for positions without regard to veteran status, uniformed service member status, race, color, religion, sex, national origin, age, physical or mental disability, genetic information or any other category protected by applicable federal, state or local laws.

011580 CCA-Business Ops, Strategy & Tech
Responsibilities:   Create, generate, and publish historical [daily, weekly, monthly and bimonthly] and ad-hoc reports for management teams and regulatory teams to evaluate and improve recovery performance.
Create and generate reports studying the Member and Provider Service Operations workflow to assist in decreasing cycle time and improve department process efficiency.
Design and maintain data collection and reporting tools including modifications to current databases and interactive reporting mechanisms.
Work closely with the IT, data, and BI teams and other relevant departments to streamline data entry and transfer processes and ensure web-based reporting is accurate and timely.
Participate in meetings as a representative of the Business Operations Strategy and Technology team.
Design business analysis and data recording methods for use throughout the Service Department.
Maintain databases and perform updates as necessary to ensure accuracy.
Regularly examine data reports to locate and resolve mistakes.
Accurately analyze and collect data for various types of business reports.
Create business qualitative, quantitative and traceability reports that provide insight into key data points and track business performance.
Communicate the results of data analysis in written and verbal form to leadership and stakeholders.
Support the various departments within service operations in reaching their goals through analysis.
Monitor data to identify changes in financial, performance and business operations trends.
Analyze data and summarize performance using summary statistical procedures.
May require taking business issues and devising the best way to develop appropriate diagnostic and/or tracking data that will translate business requirements into usable decision support tools.
May make recommendations based upon data analysis.
Proven ability to pull, analyze, report, and provide insight on large complex sets of data.
Ability to identify areas of process improvement and implement automation efficiencies.
Ability to work independently, as well as work effectively as a member of a team.
Understand departmental and organizational needs and pain points related to data and technology by engaging with key stakeholders and users; recommend approaches to solutions and collaborate with the team and stakeholders to drive projects to completion.
Develop dashboards and reports using analytics tools such as Power BI and Google Sheets for various internal teams, cross-departmental and cross-geographical audiences, and management.
Assist in implementing and maintaining a central Data Warehousing strategy by interfacing with various teams to move data into a Data Warehouse, manage permissions, identify relevant data relationships, mappings and transformations, and maintain data quality of key operational data.
Effectively translate end user reporting requirements into design documents; conduct report testing and validation.
Responsible for data analysis across multiple systems; and defining data relationships and requirements for data repository.
Develop new metrics to assess operational performance. Create, maintain, optimize and support new and existing reports.
Develop databases and reports based on standard operating processes.
Extract and integrate enterprise data from various information sources.
Extract and maintain the quality and integrity of data stored in databases and other office tools that may apply.
Conduct analysis and identify trends in order to support reporting requirements.
Identify opportunities for improvement in databases, data sets, and reports utilized by the department.
Run and analyze reports per requests of organizational departments and/or leadership.
Required Education:  Bachelor's degree in mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field.
Required Experience:   Minimum (1-3) years in data analytics or directly related field.
1-3 years experience in financial or operational reporting.
Expertise with SQL, Excel, and Tableau (or similar visualization tools).
Ability to use Microsoft Excel to create pivot tables, graphs and charts.
Preferred Experience:   Three (3) years progressive corporate, non-profit, or consulting experience.
Superior in Excel, including strong modeling capability; CRM, Qualtrics, and data warehouse (EDW) experience preferred.
Required Knowledge, Skills & Abilities:   Business Planning.
Written Communication.
Data Extraction.
Data Mining.
Data Visualization Tools.
Relational Database Management.
Strong analytical and problem-solving ability.
Analytical skills that allow for the development of data-driven reports.
Experience with relational databases and knowledge of query tools and statistical software is required.
Ability to manipulate large sets of data is also required.
Strong analytical, organizational, and problem-solving skills.
This job is focused on complex and varied metrics, making recommendations.
Tendency to pay close attention to small details that could impact results.
English.
Preferred Knowledge, Skills & Abilities:   Statistical Programming Language.
Experience with R, Python, or another statistical programming language is a plus.
Experience in SAP, object-oriented programming and other data analysis programs.
1-3 years experience in Azure preferred.
Bilingual + [Spanish, Portuguese, Chinese or any other language].
Member Facing:  Partial

#J-18808-Ljbffr

011580 CCA-Business Ops, Strategy & Tech
Responsibilities: Create, generate, and publish historical [daily, weekly, monthly and bimonthly] and ad-hoc reports for management teams and regulatory teams to evaluate and improve recovery performance.
Create and generate reports studying the Member and Provider Service Operations workflow to assist in decreasing cycle time and improve department process efficiency.
Design and maintain data collection and reporting tools including modifications to current databases and interactive reporting mechanisms.
Work closely with the IT, data, and BI teams and other relevant departments to streamline data entry and transfer processes and ensure web-based reporting is accurate and timely.
Participate in meetings as a representative of the Business Operations Strategy and Technology team.
Design business analysis and data recording methods for use throughout the Service Department.
Maintain databases and perform updates as necessary to ensure accuracy.
Regularly examine data reports to locate and resolve mistakes.
Accurately analyze and collect data for various types of business reports.
Create business qualitative, quantitative and traceability reports that provide insight into key data points and track business performance.
Communicate the results of data analysis in written and verbal form to leadership and stakeholders.
Support the various departments within service operations in reaching their goals through analysis.
Monitor data to identify changes in financial, performance and business operations trends.
Analyze data and summarize performance using summary statistical procedures.
May require taking business issues and devising the best way to develop appropriate diagnostic and/or tracking data that will translate business requirements into usable decision support tools.
May make recommendations based upon data analysis.
Proven ability to pull, analyze, report, and provide insight on large complex sets of data.
Ability to identify areas of process improvement and implement automation efficiencies.
Ability to work independently, as well as work effectively as a member of a team.
Understand departmental and organizational needs and pain points related to data and technology by engaging with key stakeholders and users; recommend approaches to solutions and collaborate with the team and stakeholders to drive projects to completion.
Develop dashboards and reports using analytics tools such as Power BI and Google Sheets for various internal teams, cross-departmental and cross-geographical audiences, and management.
Assist in implementing and maintaining a central Data Warehousing strategy by interfacing with various teams to move data into a Data Warehouse, manage permissions, identify relevant data relationships, mappings and transformations, and maintain data quality of key operational data.
Effectively translate end user reporting requirements into design documents; conduct report testing and validation.
Responsible for data analysis across multiple systems; and defining data relationships and requirements for data repository.
Develop new metrics to assess operational performance. Create, maintain, optimize and support new and existing reports.
Develop databases and reports based on standard operating processes.
Extract and integrate enterprise data from various information sources.
Extract and maintain the quality and integrity of data stored in databases and other office tools that may apply.
Conduct analysis and identify trends in order to support reporting requirements.
Identify opportunities for improvement in databases, data sets, and reports utilized by the department.
Run and analyze reports per requests of organizational departments and/or leadership.
Required Education: Bachelor's degree in mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field.
Required Experience: Minimum (1-3) years in data analytics or directly related field.
1-3 years experience in financial or operational reporting.
Expertise with SQL, Excel, and Tableau (or similar visualization tools).
Ability to use Microsoft Excel to create pivot tables, graphs and charts.
Preferred Experience: Three (3) years progressive corporate, non-profit, or consulting experience.
Superior in Excel, including strong modeling capability; CRM, Qualtrics, and data warehouse (EDW) experience preferred.
Required Knowledge, Skills & Abilities: Business Planning.
Written Communication.
Data Extraction.
Data Mining.
Data Visualization Tools.
Relational Database Management.
Strong analytical and problem-solving ability.
Analytical skills that allow for the development of data-driven reports.
Experience with relational databases and knowledge of query tools and statistical software is required.
Ability to manipulate large sets of data is also required.
Strong analytical, organizational, and problem-solving skills.
This job is focused on complex and varied metrics, making recommendations.
Tendency to pay close attention to small details that could impact results.
English.
Preferred Knowledge, Skills & Abilities: Statistical Programming Language.
Experience with R, Python, or another statistical programming language is a plus.
Experience in SAP, object-oriented programming and other data analysis programs.
1-3 years experience in Azure preferred.
Bilingual + [Spanish, Portuguese, Chinese or any other language].
Member Facing: Partial

#J-18808-Ljbffr

Commonwealth care alliance Interview Questions

Commonwealth care alliance Interview Guides

Commonwealth care alliance Interview Questions

Commonwealth care alliance Salaries by Position

Commonwealth care alliance Opening Jobs