Strategic Data Analyst, Utilization Management

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

Benefits offered by this job

Medical, Dental & Vision

401(k) contributions

Life insurance

Incentive programs

Job summary

Healthfirst is seeking an Operations Strategic Data Analyst who will work on strategic initiatives, designing data models and scoring methodologies to inform executives. You will integrate multiple data sources, develop complex analyses, and create advanced queries and reports to support business teams.

The role emphasizes collaboration with analytics leadership and cross-departmental stakeholders, ensuring accuracy and reproducibility of deliverables while leveraging leading tools like SQL,

Qualifications

• Bachelor’s degree or equivalent work experience.
• Strong analytical and critical thinking skills with attention to detail.
• Advanced Excel skills including pivots, macros, v/h lookups, and VBA.
• Experience writing SQL/SAS queries and understanding data models.

Responsibilities

• Operate with intellectual curiosity to identify process improvements.
• Develop analyses by integrating multiple data sources and standardizing data.
• Create complex queries and reports to support business needs.
• Summarize data outcomes and present to leadership and stakeholders.
• Adopt leading analytics tools to advance department analytics maturity.

Skills

Critical thinking

Advanced Excel

SQL queries

Data modelling

Teamwork

Communication

Attention to detail

Education

Bachelor’s degree or equivalent experience

Tools

SQL

SAS

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.