Intermediate Data Analyst – Pharmacy
OhioHealth
PythonSQLTableau
Salary
💰 $124,000 - $220,000 per year
Job Level
SeniorLead
Tech Stack
CloudGuidewireSQL
About the role
- Participate in multiple simultaneous projects with a focus on preparing and understanding data needed for predictive modeling and machine learning projects. Includes: Data interrogation, exploratory data analysis, profiling, and reconciliation
- Dataset creation and revision based on product manager and data scientist/actuarial input
- Data harmonization across multiple customers
- Feature creation and initial testing
- Data reporting
- Work collaboratively with other staff including product managers, data scientists, other data analysts, architects to solve problems, develop innovative approaches, and provide project status
- Research data issues and drive understanding of how data is created and updated from both ClaimCenter and PolicyCenter configurations.
- Create and manage data assets, data harmonization, and code with a focus on simplicity, scalability, reusability, and clear documentation
- Additional work assignments not related to specific project work such as new feature development, external data research, providing user feedback on new products and tools under development
Requirements
- Bachelors or Masters degree or equivalent industry experience
- 7+ years of relevant experience
- Deep experience with Guidewire PolicyCenter and ClaimCenter configuration and data
- Deep experience with multiple US/Canadian P&C standard lines of business
- Expert data profiling and analysis skills including basic statistical analysis
- Hands on experience building modeling datasets for predictive modeling
- Expert SQL skills, including advanced functions, table design, view creation, stored procedure and script design and coding, general performance tuning
- Experience with P&C policy administration and claims processing concepts
- Proficiency with Excel and Google sheets
- Experience with DBT
- Exposure to and understanding of NLP and other ML techniques
- Experience and skill in communicating insights derived from data to both technical and non-technical personnel
- Ability to plan and carry out projects with minimal direction
- Self-motivated and detail-oriented with desire to solve problems
