This TCL Data Analyst-TCL position will support the design, development, implementation, and support of priority data, reporting needs, and enhanced dashboard analytics for the Provider Network Department specific to TCL services. This position also conducts quality assurance testing related to IT reporting, data integrity, and analyses and serves as a liaison between TCL, Service Providers, and IT to coordinate data collection and report development efforts.
This position will allow the successful candidate to work fully remote from their home office. The candidate must reside in North Carolina and be available for travel in the Alliance catchment areas as needed (Wake, Durham, Harnett, Cumberland, Johnston, Orange, Mecklenburg counties and surrounding areas).
Responsibilities & Duties
Analyze Transition to Community Living Requirements and Translate into Specifications
- Analyze Transition to Community Living activities and data to identify trends, report current data related to expectations and requirements at the state level and within Alliance Health
- Translate data findings into report documentation specifications and present data as needed
- Conduct research through Provider Network and Transition to Community Living requirements, contracts, web resources, and in-person interviews to determine data requirements for projects
- Lead efforts to clarify any specifications that are unclear
Develop Reports and Data Visualization Solutions
- Perform data acquisition, analysis, and evaluation via advanced platform queries, MicroStrategy, and other data management tools
- Design solutions using Lean Six Sigma tools to minimize duplicate efforts and work towards utilizing dashboards and alerts to expedite reporting data to internal Alliance staff and other stakeholders
- Using thorough knowledge of available data, design products that merge data from various sources including State data, the data warehouse, and internal platforms including Jiva, TCLD, and SharePoint
- Provide support as required to ensure the accuracy of developed reports and metrics for both external and internal stakeholders
- Ensure that reporting activities are conducted in ways that correspond with externally mandated specifications
- Assist Transition to Community Living with any data assurance/integrity efforts required as part of larger quality activities, and with the completion and validation of state-required reports
- Provide support to our Social Drivers of Health (SDOH) CQI Committee as we enhance and further develop dashboard analytics, reporting capabilities and processes related to SDOH
Develop and Document Processes
- Engineer efficient processes for gathering statistical data, identifying complex trends, and translating insights into actionable recommendations.
- Maintain current records of actions being taken to ensure efficient processes and integrity within Alliance
Collaborate with Other Departments to Enhance Operations
- Work closely with others in Transition to Community Living and the Provider Network Department to enhance operations and automation of reports and processes and perform quality assurance testing of systems and products
- Actively participate in committees and work groups as appropriate
- Attend IT/Reporting trainings or meetings that are relevant to the above responsibilities
- Attend in-person meetings as required to problem-solve and/or collaborate with internal Alliance employees
Manage End User Support
- Provide End User support on solutions and data interpretation
- Conduct peer reviews and test solutions for functionality and data accuracy
Minimum Requirements
Education & Experience
Bachelor’s degree in computer science, information science, human services/healthcare, or related field and (3) three years of experience with quantitative and qualitative data collection and analysis methods, research design, program evaluation, and testing of applications or reports and dashboards.
Knowledge, Skills, & Abilities
- Knowledge of data integration (validation and cleaning)
- Knowledge of complex data and structures
- Knowledge of the healthcare industry
- Advanced knowledge of relational database systems, statistical analysis, data mining, predictive analytics, performance measurement, and other data science concepts
- Knowledge of data visualization principles and strategies
- Skilled in various software applications and informatics systems (Excel, Access, SAS, SPSS, Tableau, Power BI, Qualtrix, EPIC EMR system and SQL language/processes)
- Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams
- Strong analytical, conceptual, and problem-solving skills
- Ability to work with large-volume clinical and financial data and transactions
- Ability to manage projects and deliver within specified timeframes
- Ability to manage multiple priorities and adjust quickly to changing priorities
Salary Range
$54,825.00 to $91,375.00/Annually
Exact compensation will be determined based on the candidate's education, experience, external market data and consideration of internal equity.
An excellent fringe benefit package accompanies the salary, which includes:
- Medical, Dental, Vision, Life, Long Term Disability
- Generous retirement savings plan
- Flexible work schedules including hybrid/remote options
- Paid time off including vacation, sick leave, holiday, management leave
- Dress flexibility