The Data Analyst is responsible for designing, creating and executing analytical products including standard reporting, custom reporting, import/export data files and simulation models. The Data Analyst will work with staff to produce reports that provide valuable insight for all areas of the business to enable continuous business improvements with current practices, products and services.
Essential Duties and Responsibilities
- Develop and execute standard reports, custom reports, and data files using AS/400 and MS SQL Server data query tools and provide to users.
- Interpret data and analyze results using statistical techniques and provide ongoing reports.
- Identify, analyze, and interpret trends or patterns in complex data sets.
- Work closely with management to prioritize business and information needs.
- Initially validate results to ensure data integrity of the reports and/or files produced.
- Work with internal customers on custom data reporting and file requests to define requirements, create queries to meet requirements, conduct testing, and any import/export processes.
- Establish and document report data formatting, delivery methods, and maintenance procedures.
- Work with clients to establish eligibility data exchange and write data mapping specifications for custom file layouts, including testing data files with vendor, defining profiles, and documenting procedures.
- Support corporate initiatives and projects related to data requests and analytical products.
- Train internal and external users on reporting tools and provide ongoing support.
- Work with external customers and system vendors to coordinate data file transfers.
- Submit routine reports to internal staff and executive team as requested.
- Devote up to 10% of time providing quality management reporting for the other business unit(s).
- Complete other duties as assigned.
Education and Experience
- BS degree in Information Technology, Mathematics, and/or Statistics or equivalent combination of education and experience.
- 3 years of experience authoring SQL queries and using report writing tools with SSRS experience. (preferred)
- Prior pharmacy/medical claim data reporting and analysis. (preferred)
- Adaptable to change and able to work independently and as part of a team.
- Technical expertise with data modeling, database design, and data mining. Strong problem analysis skills to include the use of mathematical concepts to validate results.
- Strong analytical skills with the ability to collect, organize, disseminate, and present significant amounts of information with an attention to detail and accuracy.
- Proficient with Microsoft Office Professional.
- Clear and concise communication with superior written and verbal communication skills.
- Ability to interact with all levels of internal and external business partners.
- Manage and prioritize work effectively with minimal supervision.
- Sitting for extended time periods (between 8-10 hours/day).
- Operate typical office equipment such as a computer, telephone