What are the responsibilities and job description for the Data Analyst position at ASCENSION DEPAUL SERVICES?
Data Analyst gathers and analyzes healthcare data from multiple sources. Including, but not limited to, SQL databases, clinical quality date and other data sources. The analyst extracts trends and business insights from data to assist the organization. In this position, the analyst will assist with presentation of the data various business units. The analyst will lead and develop business intelligence platform for databases and applications in use. Lead and facilitate data submission for federal reports and other reporting requirements across the agency. The analyst will conduct full life cycle activities to include requirements analysis and design, develop, publish distribute and monitor data and reporting solutions.
DUTIES & RESPONSIBILITIES
- Build data models that capture wide range of healthcare operations and analyze data for executives, departments, managers, providers and other internal resources.
- Analyze data to both increase healthcare quality and reduce costs while streamlining processes using technical skills
- Pull and integrate data from multiple disparate sources (costs, claims, financial, population health, labs or clinical data from dental, optometry and medical applications)
- Prepares the data capture tool process making necessary changes to Stored Procedures and final reports to reflect the evolving requirements dictated by stakeholders.
- Troubleshoot errors that occur as a result of changing requirements and validate end results.
- Design, build and automate patient matching and attribution processes using techniques ranging from simple demographic based to building unique identifiers through various variables.
- Develops the pertinent data-centric process for PCMH certification; and payer aligned outcomes data
- Develops appropriate participation of users in data collection and validation
- Will need to ensure high data quality, consistency and completeness across all databases
- Develop, implement and maintain processes for data cleaning, data import/export and analysis.
- Performs process documentation management including coding, reporting and report execution instructions along with guide for understanding data.
- Administers internal enterprise reporting system monthly, quarterly, and annual reporting needs along with calendar of activities for data.
- Build visualizations and dashboard functionality for services and programs identifying business needs
- Maintains and publishes to dashboard while continuously developing Business Intelligence adoption
- Collaborate with management and internal teams to implement and evaluate workflow improvements
- Maintain and update record keeping processes and reporting catalog
- All other duties as assigned
MINIMUM QUALIFICATIONS
- Bachelor’s degree in Analytics, Biostatistics, Economics, Computer Science, Information management or equivalent required with 5 years’ experience in database management, Statistics, Analytics, Business Intelligence and Reporting using analytical tools such as Azara, Tableau, SAS, SPSS, STATA, Power View, Power BI. OR Master’s degree in Public Health, Biostatistics, Epidemiology, Statistics, Economics or equivalent required with 2 years of experience managing, database, Statistics, Analytics, Business Intelligence and Reporting using analytical tools such as Azara, SAS, Tableau, SPSS, STATA, Power View, Power BI required.
- One year experience in programming knowledge such as R, SAS, SQL, or Python required
- One year experience of analyzing data from disparate and heterogeneous sources required.
- Strong knowledge of ETL frameworks and EDW required
- Expertise using Microsoft Office, Access, Excel and Power Point required
- Ability to think proactively and function independently
- Excellent problem solving, analytical and time management skills.
- Ability to foster collaboration across departments
- Good listening, flexibility and adaptability skills
- Excellent interpersonal skills and ability to work effectively with others in the workplace
- Must be detail oriented and able to manage complex projects and multiple tasks
- Aim to make technology a better solution for clinicians and business units
- Organize/prioritize tasks and maintain attention to detail
- Willingness to update job skills in a changing environment
- Flexibility to manage unanticipated changes
PREFERRED QUALIFICATIONS
- Experience with geo-mapping and geo-spatial analysis preferred.
- Certification in SAS /STATA/SPSS preferred.
- Coding language preferred
We are an Equal Opportunity Employer and do not discriminate against applicants due to race, ethnicity, gender, veteran status, or on the basis of disability or any other federal, state or local protected class.