Reporting and Integrations Analyst II

Serve You Rx; Milwaukee (WI); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Remote work

Job summary

Serve You Rx is seeking a Reporting and Integrations Analyst II to design, create and execute analytical products, including standard and custom reports, import/export data files, dashboards, and simulation models. This role collaborates with staff to deliver insights that drive continuous improvement across products and services.

This position is a 9-month temp-to-hire opportunity and is open to full-time remote work.

Qualifications

• Bachelor's degree or equivalent experience in IT/Analytics.
• 3+ years authoring SQL queries and using report tools with SSRS experience.
• Healthcare/life sciences claim data reporting experience is a plus.
• Strong data modeling, database design and data mining knowledge.
• Proficient in SQL, SSMS, SSIS, SSRS and Power BI; able to work independently.
• Excellent communication and ability to interact with all levels of staff.

Responsibilities

• Design, create and execute standard and custom reports and data files.
• Develop dashboards and data files using SQL tools and Power BI where applicable.
• Analyze data trends and present results to stakeholders.
• Support data import/export processes and data validation activities.
• Collaborate with internal/external partners on data exchange and mappings.
• Provide training and guidance on reporting tools to users.
• Ensure data security and HIPAA-compliant data handling.
• Participate in external implementations and data mapping activities.

Skills

Analytical thinking

Data modeling

Data mining

Data interpretation

Communication

Problem solving

Attention to detail

Education

Bachelor's degree in Information Technology, Computer Science, Data Analytics, and/or Mathematics

Tools

MS SQL Server

SSRS

SSMS

SSIS

Power BI

Microsoft Office

Job description

Under limited supervision, the Reporting and Integrations Analyst II is responsible for designing, creating and executing analytical products including standard reporting, custom reporting, import/export data files, eligibility processing, dashboards, and simulation models. This role works with staff to produce routine and non-routine reports that provide valuable insight for all areas of the business to enable continuous business improvements with current practices, products and services.

This position is a 9-month temp-to-hire opportunity and is also open to full-time remote work.

What You'll Do:

As the temporary Reporting and Integrations Analyst II, you will:

• Work with business users and decision makers at various levels within the organization to understand business data needs and translate them into reporting solutions. Develop and execute standard and custom reports and data files using MS SQL Server data query tools and provide them to users.
• Interpret routine and non-routine data and analyze results using analytical techniques and provide ongoing reports. Identify, analyze, and interpret trends or patterns in more complex data sets.
• Assist in the completion of daily production tasks as necessary, including, but not limited to, eligibility processing, claim and cycle reporting, and operational reporting. Monitor eligibility data flows to ensure accurate and timely processing. Provide troubleshooting support to resolve incidents.
• Partner with management and team members to align to established business and information needs. Support corporate initiatives and projects related to data requests and analytical products. Submit routine and non-routine reports to internal staff and executive team as requested.
• Validate results to ensure data integrity of the reports and/or files produced. Assist in the development and refinement of validation methodologies and criteria.
• Work with internal customers on custom data reporting, dashboards, and file requests, assisting with definition of requirements under the guidance of management. Develop moderate queries, conduct testing, develop and enhance dashboards, and execute any import/export processes. Establish and document report data formatting, delivery methods, and maintenance procedures.
• Support moderate to complex external implementations, assisting in data exchange processes, and contributing to the development of data mapping specifications for custom file layouts. Develop and test eligibility data files, claim files, and custom extracts or reports. Define profiles and document procedures. May participate and support in calls with external individuals.
• Provide training to internal users on reporting tools and provide ongoing assistance to both internal users and external partners. Work with external partners and system vendors to coordinate data file transfers.
• Provide guidance on the work of other lower-level professionals or manage processes and programs. Exercise limited discretion to vary from established procedures when performing structured work assignments.
• Build knowledge of the organization, its processes and customers. Analyze possible solutions using standard procedures to resolve a range of straightforward problems. Receive a moderate level of guidance and direction. Problems faced are difficult and sometimes complex.
• Complete other duties as assigned.

Qualifications:

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, and/or Mathematics preferred; or equivalent combination of education and experience.
• Minimum of three years of previous related experience such as authoring SQL queries and using report writing tools with SSRS experience.
• Prior healthcare/life sciences claim data reporting and analysis. ( preferred)
• Adaptable to change and able to work independently and as part of a team.
• Solid knowledge of 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.
• Proficient with Microsoft SQL, SSMS, SSIS, and SSRS
• Clear and concise communication with strong written and verbal communication skills.
• Ability to interact with all levels of internal and external business partners.
• Manage and prioritize work effectively with some supervision.
• Solid knowledge of encryption and secure data handling
• Apply software development lifecycle knowledge
• Dashboarding experience (Power BI preferred)
• Working knowledge of data governance and security practices in HIPAA-regulated environment

Why Serve You Rx?

Serve You Rx is a full-service pharmacy benefit manager (PBM) with unquestionable flexibility and an unwavering commitment to doing what's best for its clients. With a fervent focus on those it serves, including insurance brokers, consultants, third-party administrators, and their clients, Serve You Rx delivers exceptional service and tailored, cost-effective benefit solutions. Independent and privately held for nearly 40 years, Serve You Rx can implement new groups in 30 days or less and say "yes" to a wide variety of viable solutions. Known for its adaptability, quality, and client-centricity, Serve You Rx aims to be a benchmark for better client service.

The company offers generous benefits to include: medical (HMO and PPO), dental, vision, 401k, HSA, identity theft and legal coverage, pet insurance, paid parental leave, and 18 days of paid time off in your first year.

EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.

This position is currently accepting applications.

Follow us See who works here: