Healthcare Strategic Data Analyst

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision coverage

401k contributions

Job summary

Healthfirst is seeking an Operations Strategic Data Analyst to design data models, develop scoring methodologies, and craft algorithms informing senior leadership on performance.

The role involves integrating disparate data sources, creating complex analyses, and presenting results to analytics and enterprise leaders while adopting leading analytics tools to advance the department's maturity.

Qualifications

• Bachelor's degree or equivalent relevant work experience.
• Strong analytical skills and critical thinking.
• Advanced Excel with pivots, macros, VLOOKUPs, VBA.
• Experience writing SQL (or SAS) queries and data modeling concepts.
• Familiarity with relational databases and data lifecycle.

Responsibilities

• Develop analyses integrating multiple data sources and standardize data.
• Create complex queries and reports to support business needs.
• Document methodology and present findings to analytics and enterprise leaders.
• Adopt leading analytics tools to advance departmental analytics maturity.
• Collaborate with cross‑functional teams on data projects.

Skills

SQL

Excel

Critical thinking

Data analysis

Teamwork

Education

Bachelor's degree

Tools

Alteryx

Tableau

Amazon Redshift

QlikView

SAS

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 escalat… (obviously include entire sentence: Document and escalation…)
• 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 escalate 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.