Healthfirst is looking to solve complex business problems by analyzing disparate data sets and developing algorithms to inform business leaders on performance
Requirements
- 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
- Experience working with SQL in a professional environment
- Experience with Alteryx, Tableau, Amazon Redshift, QlikView, or other similar tools/platforms
- Familiarity with Python and/or R
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
- Employ best practices in documentation, coding style and comments to facilitate persistence, reusability, and scalability of your solutions
- Document and escalate data issues as appropriate
Other
- Bachelor’s degree from an accredited institution or equivalent relevant work experience
- HS Diploma or GED accredited institution
- 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
