Plan and evaluate activities through the design and development of data/reports and the analysis and interpretation of data. This includes the development of database tools and analysis to produce data support for various company-wide programs and activities.
Position overview
Essential Functions:
- Analyze health management programs including data collection, validation and outcome measurement.
- Strong ability to analyze Provider, Member, Pharmacy, Claims, and healthcare data
- Internal data cleansing and data reconciliation analysis
- Trend analysis in various functional areas of health care management.
- Create and generate reports through MS-Excel, MS-Access, MS-Power Platform and SQL using Business Objects interface and direct links to core databases
- Navigate complex data structures in SQL Server to retrieve data
- Produce reports for and interface with senior management and internal and external stakeholders.
- Gather and interpret business requirements and monitor data trends to proactively identify issues
- Execute data changes and update core systems as needed
- Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly
- Assist with training Associate Data Analyst.
- Responsible for analytical data needs. Handle complex data requests, reports, and predictive data modeling.
- Perform data cleaning, loading, extraction, processing, storage and manipulation.
- Build and maintain program source code written by self and others.
- Maintain detailed documentation of programming and analyses.
- Communicate project results to managers and various users.
- Design and develop relational databases for collecting data and create data collection screens.
- Participate in decisions regarding study design, data collection, and data analysis.
- Backup EDI analyst in job duties
- Perform other duties as assigned.
These are the qualifications typically needed to succeed in this position. However, you don’t need to meet every requirement to apply.
Education and experience
- Bachelor’s degree in computer science, statistics, mathematics, economics or similar field.
- Four (4) years’ work experience in DB reporting data analysis and programming.
- Solid experience with SQL and DB design and maintenance with Microsoft SQL is a must.
- Experience in interpreting and reporting results of analysis, data processing and management, HIPAA EDI, and the use of health data codes.
- Basic statistical concepts, models, and procedures.
- Medi-Cal and/or Medicare programs highly preferred.
- Personal computers and proficiency in Microsoft Power Platform include Power BI, Power Apps, and Power Automate.
- API Endpoints management and development.
- Analyze data and create reports/data extractions.
- Organize work, manage time, and meet deadlines.
- Work under deadlines; manage multiple job requests simultaneously.
- Communicate effectively and provide a high standard of customer service.
- Thoroughly document work adapts to changes in requirements/priorities for daily and specialized tasks.
- Translate users need to program functional specifications.
- Communicate and work with users having a wide range of computer skill levels.
- Problem-solve and consider the entire solution.
- Work independently as well as part of a team; support team decisions.
- Effectively interact with internal and external contacts.
- Work cooperatively with others.
- Work as part of a team and support team decisions.
- Communicate effectively, both verbally and in writing.
- Adapt to changes in requirements/priorities for daily and specialized tasks
Skills:
- Microsoft .NET, C#, Visual Studio, Azure, Power Platform
- Microsoft SQL Server, Data Warehousing, Database Administration, Business Intelligence
The starting salary range is $92,240 - $118,485 per year, depending on the candidate’s work experience.
Excellent benefits package includes:
- HPSM-paid premiums for employee’s medical, dental and vision coverage (employee pays 10% of each dependent’s premiums)
- Fully paid life, AD&D and LTD insurance
- Retirement plan (HPSM contributes equivalent of 10% of annual compensation)
- 12 paid holidays a year, 12 paid sick days a year and paid vacation starting at 16 days a year
- Tuition reimbursement plan
- Employee wellness program
Report job
