General Statement of Job
The Data Analyst will apply understanding of data architecture and modeling and serve as a collaborator for multiple projects requiring specialized skills and breadth of expertise using a variety of data. This role is responsible for working with internal and external stakeholders in conceptualizing business questions, identifying necessary data for systems, completing complex analyses, and interpreting and disseminating results to key audiences in a manner appropriate to each audience. This individual will also be involved with understanding the data transformation, data harmonization and visualization. Delivering quality solutions including, but not limited to, the implementation and support of the following areas are also components of this role: Electronic Data Interfaces (EDI)/gateway, data mapping and database conversion processes, advanced SQL knowledge, local, state and federal mandated reporting requirements (HIPAA and HTECH).
Specific Duties and Responsibilities
Identifies, extracts, and scrubs data from legacy systems for migration into new solutions.
Extracts data from a variety of relational databases including SQL and manipulates, explores data using quantitative, statistical and visualization tools.
Integrates data from various internal and external sources in order to provide data for analysis and/or reporting. Works with various reporting tools including but not limited to SSRS.
Analyzes and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.
Analyze reports of data duplicates or other errors to provide ongoing, appropriate inter-departmental communication and monthly or daily data reports.
Utilize data visualization tools such as Tableau, Birst, or Qlikview.
Provides adequate back up for personnel technical requirements, including on-call first level support across the IT customer base, as needed.
Provides support for the Help Desk functions, and IT On-Call duties, as needed.
Travels to remote locations on-request appropriately to provide IT support.
Emergency duty may be required of the incumbent that includes working in Red Cross shelters or to perform other emergency duties including, but not limited to, responses to threats or disasters, man-made or natural.
High School diploma or G.E.D. required. Bachelor’s degree in Computer Science or related business experience with concentration in business intelligence preferred.
Three or more (3+) years of proven business analysis experience with work in a data analytical role and with business process re-engineering and architecture required. Solid SQL experience and Microsoft BI Suite (SSRS, SSIS, SSAS) required. Experience working with large data sets/BigData required. Experience working with Tableau or other BI tools preferred. Ability to take large data sets and summarize down to actionable levels, turning analysis into answers. Experience with health care industry data a plus.