Reporting & Integrations Analyst

The Reporting and Integrations Analyst I is responsible for designing, creating, and executing analytical products including standard reporting, custom reporting, import / export data files and simulation models.

This person will join Serve You Rx’s Reporting and Analytics team and will serve as the technical resource on external implementations establishing data exchange.

This person will also work with staff to produce routine reports that provide valuable insight for all areas of the business to enable continuous business improvements with current practices, products, and services.

The ideal candidate loves data, is eager to learn, and wants to make a difference.

This position is located in our Milwaukee office and is open to part-time remote.

What You’ll Do :

As the Reporting & Integrations Analyst, you will be :

Working with business users and decision makers at various levels within the organization to understand business data needs and translate them into the required reporting solutions.

Develop and execute standard reports and data files using AS / 400 and MS SQL Server data query tools and provide to users.

Assist with the development of custom reports.

Interpreting standard data and analyzing results using statistical techniques and provide ongoing reports. Identifying, analyzing, and interpreting trends or patterns in data sets.

Referring complex projects to higher-level staff for review.

• Completing daily production tasks, not limited to, eligibility processing, controlled substance reporting, claim cycle reporting, SUPPORT Act reporting, pharmacy network credentialing reporting, and provider network audit reporting escalating issues when necessary
• Working closely with management to prioritize business and information needs. Supporting corporate initiatives and projects related to data requests and analytical products.

Submitting routine reports to internal staff and executive team as requested. Devoting up to 10% of time providing quality management reporting for the mail service pharmacy.

• Initially validating results to ensure data integrity of the reports and / or files produced.
• Working 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.

Establishing and documenting report data formatting, delivery methods, and maintenance procedures.

Serving as technical resource on implementations with clients, partners, vendors to establish data exchange, writing data mapping specifications for custom file layouts.

This includes developing and testing eligibility data files, claim files, and custom extracts / reporting with clients, partners, and vendors, defining profiles, and documenting procedures.

• Training internal and external users on reporting tools and providing ongoing support. Working with external customers and system vendors to coordinate data file transfers.
• May provide technical direction to support staff. Use existing procedures to solve routine and non-routine problems. Has limited discretion to vary from established procedures by performing structured work assignments.

Receiving instruction, guidance, and direction from others.

Completing other duties as assigned.

Qualifications :

• Bachelor’s degree in Information Technology, Mathematics, and / or Statistics or equivalent combination of education and experience.
• Previous related experience such as authoring SQL queries and using report writing tools with SSRS preferred.
• Prior pharmacy / medical claim data reporting and analysis preferred.

Why Serve You Rx?

Serve You Rx is a full-service pharmacy solutions provider based in Milwaukee, Wisconsin. We specialize in pharmacy benefit management, mail order services, and specialty medication management.

For more than 35 years, Serve You Rx has been collaborating with benefit advisors, third-party administrators, and employers to design and deliver strategies that reduce prescription drug costs and improve consumer access to affordable and clinically appropriate medication therapies.

Serve You Rx is privately held, and our owned assets include our Specialty Pharmacy, mail order pharmacy, and member services call center.

In addition to the great workplace culture, Serve You Rx offers generous benefits to include : medical, dental, vision, 401k, HSA, identity theft, and pet insurance, 18 days of paid time off in your first year.

If working on site, we offer a newly remodeled and clean facility, easy on / off freeway access, plenty of free surface parking directly outside our facility doors, scenic walking trails,