Analytics Consultant

At HCSC, our employees are the cornerstone of our business and the foundation to our success. We empower employees with curated development plans that foster growth and promote rewarding, fulfilling careers.

Join HCSC and be part of a purpose-driven company that will invest in your professional development.

Job Summary

This position is responsible for constructing forecasts, recommendations and strategic/tactical plans based on business data and market knowledge. Creates specifications for reports and analysis based on business needs and required or available data elements. May provide consultation to users and lead cross-functional teams to address business issues. Produces datasets and reports for analysis using system reporting tools. May perform research and assists in analyzing financial and health data, including medical algorithms to determine health care expenditures, medical and economic outcomes, and cost containment strategies. Analyzes complex business problems and issues using data from internal and external sources to provide insight to decision-makers. Identifies and interprets trends and patterns in datasets to locate influences.
HET:
The Consultant’s primary responsibility is to leverage strong technical skills (SQL, R, Python, and Tableau) and healthcare industry knowledge (payor, provider, pharmacy, public health, epidemiology, etc.) to support and enhance client-facing engagements with HCSC’s largest Commercial customers. They will be accountable for the analytic support and consultancy for HCSCs largest Commercial Clients and advisory for internal senior-leader stakeholders related to population health and insurance.
BI Solutions:
The Consultant’s primary responsibility is to leverage strong technical skills (SQL, R, Python, and Tableau) and healthcare industry knowledge (payor, provider, pharmacy, public health, epidemiology, etc.) to support clinical and business stakeholders. They will be accountable for they analytical support and consultancy of internal clients and advisory service for internal senior leaders.

JOB REQUIREMENTS:

• Bachelor's degree and 2 years of experience in data analysis and information reporting relating to healthcare data, including pharmacy.
• Requires knowledge and experience in own function; still acquiring higher-level knowledge and skills.
• Builds own knowledge of HCSC, business processes and customers
• Solves a range of problems.
• Analyzes possible solutions using standard procedures.
• Receives a moderate level of guidance and direction.

PREFERRED REQUIREMENTS:

• Analytical Thinking: Approaches a problem by using a logical, systematic, sequential approach; makes a systematic comparison of tow or more alternatives; notices discrepancies and inconsistencies in available information; identifies a set of features, parameters or considerations to take into account, in analyzing a situation or making a decision; approaches a complex task or problem by breaking it down into its component parts and considering each part in detail; weighs the costs, benefits, risks and chances for success, in making a decision identifies many possible causes for a problem; carefully weighs the priority of things to be done.
• Communication for Results: Fosters two-way communication; recalls others' main points and takes them into account in own communication; checks own understanding of others' communication; elicits comments or feedback on what has been said; maintains continuous open and consistent communication with others.
• Conceptual Thinking: Uses rule of thumb to understand a situation or problem by putting the pieces together, seeing the large picture; identifies patterns or connections between situations that are not obviously related; identifying key or underlying issues in complex situations.
• Information Seeking: Recognizes and interprets the information problem; establishes a plan of search; conducts the search; evaluates the results, and if necessary, iterates through the process again.
• Initiative:
• Openness to Learning: Demonstrates eagerness to acquire necessary technical knowledge, skills, and judgment to accomplish a result or to serve a customer's needs effectively. Has desire and drive to acquire knowledge and skills necessary to perform job more effectively.
• Results Orientation: Listens and responds effectively to customer inquiries; resolves issues; respects all internal and external customers; uses a team approach when dealing with customers; follows up to evaluate customer satisfaction; presents a cheerful, positive manner with customers.
• Teamwork: Works harmoniously with others to get a job completed; responds positively to instructions and procedures; able to work well with staff, co-workers, peers and managers.
• Thoroughness: Accomplishes a task through concern for all the areas involved, no matter how small; monitors and checks work or information and plans and organizes time and resources efficiently.
• Understanding Environment: Understands agendas and perspectives of others, recognizing and effectively balancing the interests and needs of one's own group with those of the broader organization.

HET:

Required Job Qualifications: 

•  Bachelor’s degree and 2 years of experience in health care services, statistical analysis, or insurance industry economics OR Master’s degree in related field.  
• 2 years’ experience in analyzing medical claims data. 
• Understanding, and being highly proficient at querying, a wide variety of healthcare data and related population data (medical/pharmacy claims, behavioral health claims, health care management (HCM) records, electronic medical records (EMR), provider databases (AMA, NPI, DEA, etc.), member/patient demographic data, and publicly available databases (U.S. Census, Bureau of Labor Statistics, NIH, etc.) in order to construct a robust, accurate, 360-view data environment that is unique to each client  
• Performance excellence in one or more of the following computer languages: SQL, SAS, R, Python. 
• Ability to create a dynamic and visually engaging dashboard in Tableau 
• Acquaintance with version control/collaborative tools such as GitHub 
• High degree of business intelligence and understanding how to take a business case from inception to client execution.  
• Performance excellence in championing initiatives and collaborating with multiple stakeholders to bring the initiative to life. 

 Preferred Job Qualifications: 

• Master’s Degree.
• Degree in Public Health, Epidemiology, Engineering, Business.
• Employing techniques such as a case-control study, regression analyses, principal component analyses, clustering exercises, propensity scoring, classification, ROI calculation, etc. to produce actionable insights. 
• Understanding of Agile and Waterfall project management methods 
• Versed in automation tools such as Alteryx.  

BI Solutions:

Required Job Qualifications: 

• Bachelor's degree (Applied Economics, Statistics, Data Science, CIS, Mathematics, Public Health, Healthcare Administration etc) and 2 years of experience in BI development and consulting or related field OR Master’s degree in related field. 
• Understanding, and being highly proficient at querying a wide variety of internal and external data sources to get meaningful insights. 
• Performance excellence in one or more of the following computer languages: SQL, R, Python. 
• Ability to create a dynamic and visually engaging dashboard in Tableau or Power BI 
• High degree of business intelligence and understanding how to take a business case from inception to client execution.  
• Excellent communication and presentation skills. 
• Ability to work independently and as part of a team. 
• Experience with electronic health records (EHR) data analysis is a plus. 
• Performance excellence in championing initiatives and collaborating with multiple stakeholders to bring the initiative to life. 

Preferred Job Qualifications: 

• Experience with project management methodologies. 
• Experience of Healthcare industry.  
• Acquaintance with version control/collaborative tools such as GitHub 
• Experience with transformation tools such as Alteryx. 

*Sponsorship is not available.

*This is a Flex (Hybrid) role: 3 days in office; 2 days remote.

*CA

#LI-Hybrid

Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!

HCSC Employment Statement:

We are an Equal Opportunity Employment / Affirmative Action employer dedicated to providing an inclusive workplace where the unique differences of our employees are welcomed, respected, and valued. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristics.

Base Pay Range$58,800.00 - $130,100.00