GENERAL SUMMARY

The Data Analyst I, will be responsible for developing, monitoring and enhancing in-house processes, reports and applications. Will help in gathering requirements, documenting, and producing automated IPA reports, Health Plan reports and Management reports. They will also be expected to help monitor and maintain automated processing. The analyst will work closely with key business users as well as managers to gather and define the reporting and process requirements. He/she will be responsible for analyzing the data for completeness and accuracy.

ESSENTIAL FUNCTIONS

• Collaborate with business users to gather and define the process requirements
• Build, develop and maintain SQL based reporting processes using stored procedures and Power BI
• Document, design, evaluate and enhance MS SSRS, MS Power BI, MS Access, MS Excel reports as well as custom report applications
• Produce supporting documentation in Confluence
• Monitor processes, report on major changes to metrics, annotate projects and document changes to the system that have impacted KPI.
• Automate repetitive processs where applicable
• Verify and validate process outputs
• Summarize, document, and present findings to senior level executives, both internal and external.
• Produce data sets from multiple systems, both systematically and manually, using own discretion and independent judgement.
• Identify areas of concern and present proposed solutions to senior operations/finance management teams
• Construct analysis and prepare recommendations for implementation of new systems, procedures, and organizational changes

QUALIFICATIONS

• Excellent verbal and communication skills
• Customer service oriented
• Experience with MS SQL Server
• Experience with a Programming language(s) and/or concepts (Python, Shell, T-SQL, C#, C++, FTP,SFTP)
• Experience with Microsoft Office Products
• Experience with Power BI and/or SSRS
• Experience with Airflow and/or Kafka a plus

EDUCATION and/or EXPERIENCE

• Bachelor's degree or one to two years related experience and/or training; or equivalent combination of education and experience.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently is required to stand and walk. The employee is occasionally required to stoop, kneel, crouch, or crawl. The employee may occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals to perform the essential functions.