Reporting Analyst

ProCare Rx; United States; On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health benefits

Paid vacation

Wellness program

401(k) with match

Employee Assistance Program

Referral program

Job summary

ProCare Rx is seeking a data-driven Reporting/BI Analyst to develop and maintain company-wide reports, dashboards, and data extracts from reporting databases. You will translate business needs into technical specifications, collaborate with stakeholders, and ensure data integrity across analytics solutions.

You will work on ETL processes, data warehousing support, and automation of recurring reports while training end-users on reporting tools and best practices.

Qualifications

• Bachelor’s degree in MIS, CIS, Data Analytics, CS, Systems Analysis and Design, or related field.
• Strong working knowledge of data analytics, including ability to understand business questions, interpret data, identify trends and relationships, and translate analytical needs into effective reporting or data solutions.
• Demonstrated ability to understand reporting and analytics requirements and determine how data, systems, queries, tools, and processes should work together to produce accurate and useful results.
• Strong working knowledge of the Microsoft Office Suite, including Word, Excel, and PowerPoint.
• Experience with MS-SQL and accomplished as a query writer preferred.
• Experience with SSIS and MySQL preferred.
• Experience with Python, Power BI, or similar programming, analytics, visualization, or business intelligence tools preferred.
• Working knowledge of BI tools preferred; knowledge of QlikView beneficial but not required.
• Experience developing dashboards, reports, data extracts, automated reporting processes, or other data-driven solutions preferred.
• Pharmacy knowledge or Healthcare industry background very helpful.
• Strong problem-solving, analytical, communication, and organizational skills with the ability to work effectively with both technical and non-technical stakeholders.

Responsibilities

• Creates and supports company-wide reporting from reporting databases.
• Applies data analytics concepts to understand business questions and develop reporting solutions.
• Translates business requirements into technical specifications, data requirements, and dashboards.
• Gathers requirements with end users and stakeholders to ensure correct outputs and validation.
• Imports, exports, aggregates, transforms, and processes data company-wide.
• Designs, develops, and maintains reports, dashboards, and data extracts using BI tools.
• Supports data warehousing and data integration projects.
• Defines Inputs, Processes, and Outputs with reporting customers for specific activities.
• Documents reports, dashboards, data processes, calculations, and business rules.
• Standardizes reports across the company for consistency and data integrity.
• Maintains on-time running, monitoring, and distribution of reports and data files.
• Optimizes slow-running reports and data processes.
• Develops ETL functions and data integration processes supporting reporting systems.
• Automates execution, distribution, and monitoring of large data processes.
• Uses scripting/automation to improve reporting efficiency.
• Provides end-user training on report-writing and BI tools.

Skills

Data analytics concepts

Requirements gathering

End-user training

Multi-project management

Education

Bachelor’s degree in MIS, CIS, Data Analytics, CS, Systems Analysis and Design, or related field

Tools

MS-SQL

SSIS

MySQL

Python

Power BI

QlikView

JReports

MPower

Job description

PRINCIPAL RESPONSIBLITIES include but are not limited to the following:

• Serves as a key member of the report applications development team responsible for the creation, documentation, and support of company-wide core/standardized, ad hoc, scheduled, and analytical reporting from the company’s reporting databases.


• Applies data analytics concepts to understand business questions, identify meaningful data relationships and trends, and develop reporting or analytical solutions that support business decision-making.


• Translates business requirements and reporting needs into technical specifications, data requirements, queries, calculations, dashboards, and other practical analytics solutions.


• Works closely with end users, business stakeholders, analysts, and developers to gather requirements, define expected outputs, and ensure proper testing and validation of reporting and analytical solutions.


• Responsible for importing, exporting, aggregating, transforming, and processing data company-wide.


• Designs, develops, and maintains reports, dashboards, data extracts, and analytical tools using appropriate reporting and business intelligence technologies.


• Assists analysts and developers with the design, development, and maintenance of data warehousing and data integration projects.


• Meets with internal and external reporting customers to define the Inputs, Process, and Outputs related to specific reporting activities or events.


• Documents created reports, dashboards, data processes, calculations, business rules, and changes to existing reporting solutions.


• Standardizes reports and analytical outputs company-wide to promote consistency, accuracy, usability, and data integrity.


• Is responsible for the on-time running, monitoring, and distribution of reports and extracted data files.


• Optimizes or fine-tunes slow-running reports, queries, dashboards, and data processes.


• Designs, implements, and maintains Extracting, Transforming, and Loading (ETL) functions and other data integration processes supporting reporting systems.


• Develops solutions to automate the execution, distribution, and monitoring of large volumes of reports and recurring data processes.


• Uses programming, scripting, or automation techniques when appropriate to improve reporting efficiency, data processing, and analytical capabilities.


• Provides end-user training on report-writing, reporting, analytics, and business intelligence tools and supports users in ad hoc report creation.


• Troubleshoots problems in reporting systems, data processes, dashboards, and analytical solutions and works with appropriate technical resources to resolve issues.


• Has the ability to multi-task and work on several projects at once while effectively managing priorities, deadlines, and competing business requirements.

RREQUIREMENTS

• Bachelor’s degree in Management Information Systems, Computer Information Systems, Data Analytics, Computer Science, Systems Analysis and Design, or a related field; or equivalent work experience.


• Strong working knowledge of data analytics, including the ability to understand business questions, interpret data, identify trends and relationships, and translate analytical needs into effective reporting or data solutions.


• Demonstrated ability to understand reporting and analytics requirements and determine how data, systems, queries, tools, and processes should work together to produce accurate and useful results.


• Strong working knowledge of the Microsoft Office Suite, including Word, Excel, and PowerPoint.


• Experience with MS-SQL and accomplished as a query writer preferred.


• Experience with SSIS and MySQL preferred.


• Experience with Python, Power BI, or similar programming, analytics, visualization, or business intelligence tools preferred.


• Working knowledge of business intelligence (BI) tools preferred. Experience with QlikView is preferred, but not required.


• Experience with JReports, MPower, or other business reporting and analytics tools preferred.


• Experience developing dashboards, reports, data extracts, automated reporting processes, or other data-driven solutions preferred.


• Pharmacy knowledge or Healthcare industry background very helpful.


• Strong problem-solving, analytical, communication, and organizational skills with the ability to work effectively with both technical and non-technical stakeholders.

PHYSCIAL DEMANDS

Requires sitting, standing, and occasional light to medium lifting. The position also requires extended periods of computer use and the ability to work with multiple data, reporting, and business applications.

The Perks of Joining Our Team:

We believe in taking care of our team. You'll enjoy a comprehensive benefits package designed to support your well-being and financial future:

• Comprehensive Health Benefits: Medical, Dental, Vision, Short-Term/Long-Term Disability Insurance, Life insurance.


• Time to Recharge: Paid vacation and holiday pay.


• Focus on Your Wellness: We offer a robust Employee Wellness Program.


• Invest in Your Future: 401(k) with a company match.


• Support System: Employee Assistance Program provides confidential support and counseling.


• Get Rewarded for Referring Great People: Employee referral program.

ProCare Rx will never ask for a financial commitment from an applicant as part of our recruitment process. All interviews are conducted in-person OR through video conference invitations from official company emails. For inquiries, please contact our official recruitment team at [e-mail].

ProCare Rx is an Equal Opportunity Employer

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.