Strategic Data Analyst, Utilization Management

Healthfirst; Connecticut; On-site; USD 61,000 - 91,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision coverage

401(k) contributions

Job summary

Healthfirst in Connecticut is seeking an Operations Strategic Data Analyst to unite disparate data sets, design data models, and develop scoring methodologies that inform executive decisions.

You will build advanced queries, craft reports, and present outcomes to analytics leadership and enterprise stakeholders, driving data maturity across the organization.

Qualifications

• Bachelor's degree or equivalent relevant work experience.
• Advanced MS Excel skills including pivot tables, macros, v/h lookups and VBA.
• Familiarity with SQL (and/or SAS) queries for analyzing data and establishing business rules.

Responsibilities

• Operate with intellectual curiosity and assess existing processes to identify improvements.
• Develop analyses integrating multiple data sources and standardize data.
• Create complex queries and reports supporting business teams and executives.
• Summarize data outcomes and present recommendations to analytics leadership.
• Learn and leverage leading analytical tools to advance departmental analytics.
• Ensure accuracy, completeness, and quality of deliverables across the analytics process.
• Document and comment code for persistence, reusability, and scalability.
• Highlight data issues and collaborate with cross-department teams.
• Additional duties as assigned.

Skills

Bachelor's degree

Critical thinking

Advanced MS Excel

SQL / SAS

Relational databases

Data modeling

Data lifecycle

Team collaboration

Written & verbal communication

Attention to detail

Education

Bachelor's degree or equivalent

Data science/Data analytics-related degree (preferred)

Tools

Alteryx

Tableau

Amazon Redshift

QlikView

Python

R

Job description

The Operations Strategic Data Analyst embraces complex, disparate data sets and leading technologies to design data models, craft scoring methodologies and develop algorithms that inform the leaders of our business on our performance. This individual will be working directly on Healthfirst strategic initiatives to identify solutions that have visibility at the highest levels of the company.

Duties & Responsibilities

• Operate with intellectual curiosity and critically assess existing processes and procedures to identify opportunities for improvement
• Develop complex analyses requiring the integration of multiple data sources, evaluation of data quality, and standardization of data to consistent format/structure
• Create advanced queries and reports that extract data to support business teams’ needs, including working with nesting tables and temp tables and writing multiple conditions against varying data sets)
• Summarize and present data outcomes, recommendations, and methodology to analytics leadership, department leadership, and enterprise stakeholders
• Learn, adopt and leverage leading analytical tools and technologies to further the maturity of departmental analytics at-large
• Hold oneself accountable for the accuracy, completeness, quality, and relevance of deliverables in order to own responsibility for work product and consider these factors in the end-to-end analytical process, from data gathering to analysis to formatting and presentation
• Employ best practices in documentation, coding style and comments to facilitate persistence, reusability, and scalability of your solutions
• Document and amplify data issues as appropriate
• Exhibit collaborative attitude, willingness to work with others on data projects that included working team(s) made of cross departmental/interdisciplinary users
• Additional duties as assigned

Minimum Qualifications

• Bachelor’s degree from an accredited institution or equivalent relevant work experience
• Working experience exhibiting strong critical thinking and analytical skills
• Advanced MS Excel skills that include creating pivot tables, macros, utilizing v/h lookups and VBA
• Familiarity with writing SQL (and/or SAS) queries for analyzing data and establishing business rules and requirements
• Familiarity with relational database structures, theories, principles, and practices
• Familiarity with data models and/or data modelling
• Understanding of the data lifecycle within the organization and its impact on the business
• Experience working in a team-oriented, collaborative environment
• Experience communicating effectively verbally and in writing while demonstrating good grammar, spelling, and punctuation skills
• Work experience requiring meticulous attention to detail

Preferred Qualifications

• Degree in Mathematics, Computer Science, Data Sciences, Engineering, Business Analytics, Informatics, or similar concentration
• Experience working with SQL in a professional environment
• Experience with Alteryx, Tableau, Amazon Redshift, QlikView, or other similar tools/platforms
• Familiarity with statistical principles, such as standard deviations, normal distributions, and regressions
• Familiarity with Python and/or R
• Familiarity with healthcare data
• Balances working independently with an understanding of when to elevate with questions/issues
• Ability to work effectively with both business and technical stakeholders

Compliance & Regulatory Responsibilities: N/A

License/Certification: N/A

Hiring Range*

• Greater New York City Area (NY, NJ, CT residents): $68,900 - $99,620
• All Other Locations (within approved locations): $61,300 - $91,120

As a candidate for this position, your salary and related elements of compensation will be contingent upon your work experience, education, licenses and certifications, and any other factors Healthfirst deems pertinent to the hiring decision.

In addition to your salary, Healthfirst offers employees a full range of benefits such as, medical, dental and vision coverage, incentive and recognition programs, life insurance, and 401k contributions (all benefits are subject to eligibility requirements). Healthfirst believes in providing a competitive compensation and benefits package wherever its employees work and live.

• The hiring range is defined as the lowest and highest salaries that Healthfirst in “good faith” would pay to a new hire, or for a job promotion, or transfer into this role.