Description:
Essential Job Functions:
- Support clients: Work and communicate closely with their clients throughout the report/dashboard development process. Provide status updates. Help clients understand their report/dashboard. Provide on-going maintenance and support.
- Support HCS projects: Participate in outcome evaluation, program evaluation, and quality improvement studies. Attend meetings, answer data-related questions, and offer suggestions.
- Create reports and dashboards: Create ad-hoc and routine reports. Design and develop dashboards to display key metrics and trends.
- Manage data: Collect, organize, store, and share a wide variety of data.
- Transform data: Clean and optimize data for analyses.
- Ensure data quality: Audit data, data transformation processes, workflow, deliverables and outputs.
- Perform analyses: Perform statistical analyses (descriptive and inferential analyses).
- Present findings: Present data and findings in a clear and concise manner, using appropriate reporting and data visualization tools.
- Create and maintain documentation: Create FDD, document report requirement, business logic and workflow. Create data dictionaries. Ensure documentation is up-to-date.
- Maintain up-to-date knowledge on HCS information management systems, processes and data.
- Manage compliance reporting: Maintain up-to-date knowledge of CMS, DHCS and internal compliance reporting requirement. Translate reporting requirement into reports. Work with clients to ensure accuracy of data. Submit report to external and internal agencies in a timely manner. Attend compliance trainings, meetings, and data validation webinars.
- Support HCS system enhancement/implementation: Perform data-related research and testing. Stay informed of system and process changes. Identify impact on existing reports and dashboards. Modify existing reports and dashboards accordingly.
- Prioritize work and keep supervisor informed: Work on multiple projects at the same time. Organize and prioritize work effectively. Inform management when requirement or due date cannot be met.
- Adheres to all quality, compliance and regulatory standards to achieve HCS outcomes.
Required Education:
- Bachelor’s or Master’s degree in Analytics, Healthcare Informatics, Statistics, Computer Science, or related field.
Required Experience:
- At least 5 years of experience analyzing and compiling data, preferably in a health plan setting.
- Ability to manipulate and analyze data to produce accurate results. Present results in data visualizations, dashboards, and reports.
- SQL And SAS programming expertise
- Knowledge in CMS Medicare Advantage (Part C), CMS Prescription Drug Coverage (Part D), and CMS Special Needs Plan (SNP), and DHCS Medi-Cal Managed Care reporting requirements.
- Knowledge in authorization, claims, and encounter data. Clinical code knowledge (ICD, CPT, etc) related to utilization data.
- Advanced skills in Microsoft Office, SQL Transactional SQL (T-SQL), SQL Server Reporting Services (SSRS), and Tableau.
- Experience in SQL Server Integration Services (SSIS), Visual Basic for Applications (VBA).
- Must have analytical, communication, documentation, interpersonal, planning, presentation, problem-solving and research skills.
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.