2,347 Reporting Tools jobs in the United States

Our Company

PharMerica

Overview

The Data & Reporting Analyst position is responsible for leveraging data and analytics to support client strategy and partnership department operations in order to facilitate conversation on how best to support and report on various performance of the account management teams.

This is not a remote position. Applicants must reside in or be commutable to Louisville, KY.

This is a Hybrid schedule, working from your home office and Headquarters.

We offer:Competitive payHealth, dental, vision and life insurance benefitsCompany paid STD and LTDEmployee Discount Program401kPaid-time offTuition reimbursementNon-retail/Closed-door environment

Short Term Incentive Bonus

If your passion is service excellence and top-quality care come join our team and apply today!

*Position will be posted for a minimum of 7 business days

Responsibilities

• Works with the Client Strategy and Partnership teams to provide key monthly performance metrics on various measures aligned to Company priorities on a recurring and adhoc basis.

• Develops monthly process(es) to create performance reports in timely manner in conjunction with data availability

• Effectively coordinates and communicates reporting activities and documents all processes; and helps maintain procedures for organization

• Helps design reports, dashboards, and scorecards using tools such as Microsoft Excel or Power BI

• Establishes KPIs to measure the effectiveness of business decisions

• Performs data analysis on retention and renewal performance, group purchasing partner pipeline management and rebate preparation, quarterly AM team retention performance and other client performance metrics

• Reviews strategic account portfolio and identifies ways to represent business portfolio and opportunity focus

• Generates Excel Reports from Microsoft Dynamics CRM to Optimize KPI information on Renewal/Retention and Loss Data as part of Monthly Cadence

• Prepares AM Team’s Quarterly Bonuses Incentive

• Ensures membership list accuracy and GPO reporting process milestones achieved quarterly

• Tracks overall progress of Strategic Account plan execution for growth

• Creates presentations and reports based on recommendations and findings

• Maintains department headcount report and roster changes for leadership

• Communicates directly with Director, Client Strategy and SVP, Client Strategy and Partnerships in development of reports, as well as testing for data accuracy and reliability

• Responds to data requests in a timely and efficient manner with the highest level of quality

• Seeks customer satisfaction on all endeavors

• Additional responsibilities may be required

• Conducts job responsibilities in accordance with the standards set out in the Company’s Code of Business Conduct and Ethics, its policies and procedures, the Corporate Compliance Agreement, applicable federal and state laws, and applicable professional standards

Qualifications

• Bachelor’s Degree in Business Administration, Computer Science/CIS, or related fields. A combination of education and work experience will be taken into consideration

• Experience in data analysis (Education will be consideration). Strong analytical and critical thinking skill

• Excellent verbal and written communication skills

• Strong interpersonal skills to work effectively with internal and external customers

• Demonstrated ability to handle multiple tasks simultaneously and to prioritize accordingly

• Proven ability to work with a high degree of accuracy and attention to detail

• Proficient in all Microsoft office products including Excel, PowerBI, Access, PowerPoint, and Word

• Experience working with SAS, COGNOS, SQL, Server Manager, or other database management software is plus

• Self-starter with a commitment to continuous process improvements and improved service levels

About our Line of Business

PharMerica, an affiliate of BrightSpring Health Services, is a full-service pharmacy solution providing value beyond medication. PharMerica is the long-term care pharmacy services provider of choice for senior living communities, skilled nursing facilities, public health organizations, and post-acute care organizations. PharMerica is one of the nation's largest pharmacy companies, offering unmatched company culture, employee development, and advancement opportunities. For more information, please visit Follow us onFacebook ( ,LinkedIn ( , andX ( .

Salary Range

USD $50,000.00 - $5,000.00 / Year

ALERT: We are aware of a scam whereby imposters are posing as employees from our company. Beware of anyone requesting financial or personal information. We take pride in creating a best-in-class candidate experience. During the recruitment process, no recruiter or employee will request financial or personal information (Social Security Number, credit card, driver’s license, bank information, or payment for work equipment, etc.) from you via text or email. If you are suspicious of a job posting or job-related email mentioning our company, please contact us at .

Click here ( for additional FAQ information.

Job LocationsUS-KY-LOUISVILLE

ID 2025-164980

Line of Business PharMerica

Position Type Full-Time

Pay Min USD $5 ,000.00/Yr.

Pay Max USD 55,000.00/Yr.

Data & Reporting Analyst

Expected Salary Range: $70,000-$80,000

Why take a Data & Reporting Analyst role with Cedar Insurance?

• This is a brand-new, critical role where you'll shape data reporting and analysis from the ground up
• Be instrumental in streamlining manual processes and enhancing data capabilities
• Join a dynamic, growing insurance company embracing new leadership and exciting changes

What will the Data & Reporting Analyst do?

• Develop and automate reports and dashboards for various business functions
• Perform data reconciliations and manipulate large datasets to ensure accuracy
• Extract, upload, and format data from various systems for internal use and regulatory submissions
• Collaborate with internal teams and external consultants to deliver effective data solutions
• Identify opportunities for process improvement through automation and data handling
• Utilize advanced Excel for data manipulation and formatting, with potential for SQL queries

What the company needs in a Data & Reporting Analyst:

• Proven experience in report writing and data manipulation
• Advanced Excel skills, including efficient data manipulation and formatting
• Strong understanding of data best practices and ability to work independently
• Excellent communication skills to articulate technical concepts to non-technical teams
• Bonus Points: Knowledge of insurance industry practices (especially data calls), experience with SQL queries, familiarity with reporting tools (Crystal Reports, Power BI ), and experience with cloud-based systems

What are the benefits of taking a Data & Reporting Analyst role?

• Be a foundational part of a newly created role with significant impact on company growth
• Enjoy the flexibility and autonomy of a fully remote work environment
• Work with a small, collaborative team where your contributions are highly valued
• Gain valuable insurance industry experience and contribute to essential reporting functions
• Work directly with leadership and make a direct impact on business operations

JOB SUMMARY & OBJECTIVES
The Data Reporting Analyst is responsible for the creation and distribution of regularly scheduled financial reports (e.g. billing, revenue, and statistical) within the Firm. This includes both scheduled and ad hoc reporting, with the goal of increased transparency and usability throughout the Firm. The Financial Reporting Analyst will be required to work across all levels of Firm personnel and collaborate across administrative groups (within Accounting and outside of the department).

ESSENTIAL JOB DUTIES & RESPONSIBILITIES
• Design and distribute monthly, quarterly and annual billing related financial reports centering on, but not limited to, billing, revenue, and various financial statistics.
• Assist management with the creation and distribution of report requests as needed.
• Ability to manage a large volume of reporting requests and reporting schedules.
• Develop and modify reports using 3E, Microsoft SSRS Report Builder, Ideate Dashboard, Microsoft Power BI Desktop, and other reporting software.
• Assist with periodic reporting to Firm management for use in the annual compensation review processes.
• Design and distribute ad hoc and subscription based reporting for the Billing and Collection department, partner, clients and other stakeholders as requested
• Review presentation and functionality of reports and make recommendations for improvement.
• Assist with special projects, system upgrades, and testing as needed.
• Ability to think critically and adapt existing tools to solve problems
• Perform other duties as assigned.

EDUCATION
REQUIRED
• Bachelor's degree required
PREFERRED
• Degree in Finance or Accounting preferred

SKILLS AND EXPERIENCE
REQUIRED
• 3 to 5 years of financial reporting experience in legal or related field required
• Experience with Microsoft SSRS Report builder, SQL, Microsoft Power BI Desktop and/or other financial dashboards
• Ability to effectively present information visually, verbally and in writing, tailored to a specific audience
• Basic math skills: add, subtract, multiply, and divide
• Working knowledge of MS Excel and other commonly used office software
PREFERRED
• Experience with 3E or other legal billing systems preferred

PHYSICAL DEMANDS (REQUIRED TO PERFORM ESSENTIAL JOB FUNCTIONS)
Sedentary work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
• Sitting: Remaining in the seated position, particularly for sustained periods of time
• Walking: Moving about on foot to accomplish tasks, particularly for long distances or moving from one work site to another
• Climbing: Ascending or descending ladders, stairs, ramps using feet and legs or hands and arms
• Lifting: Raising objects from a lower to a higher position or moving objects horizontally
• Carrying: Transporting an object, usually holding it in the hands or arms, or on the shoulder
• Pulling/Pushing: Using upper extremities to exert steady force upon an object so that the object moves toward or away from the force
• Bending/Stooping/Kneeling/Crouching: Bending body downward and forward by bending legs and spine, or by bending legs at knees
• Reaching: Extending hand(s) and arm(s) in any direction

WORK ENVIRONMENT
The worker is not substantially exposed to adverse environmental conditions as in typical office or administrative work (normal light, air and space in the work environment)

Salary Information

NY Only: The estimated base salary range for this position is $100,000 to $120,000 at the time of posting.

The actual salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location in which the applicant lives and/or from which they will be performing the job. This role is exempt meaning it is not overtime pay eligible.

Privacy Notice

For information about how Simpson Thacher & Bartlett LLP collects and processes your personal information, please refer to our Privacy Notice available at

Simpson Thacher & Bartlett is committed to a collegial work environment in which all individuals are treated with respect and dignity. The Firm prohibits discrimination or harassment based upon race, color, religion, gender, gender identity or expression, age, national origin, citizenship status, disability, marital or partnership status, sexual orientation, veteran's status or any other legally protected status. This Policy pertains to every aspect of an individual's relationship with the Firm, including but not limited to recruitment, hiring, compensation, benefits, training and development, promotion, transfer, discipline, termination, and all other privileges, terms and conditions of employment.

#LI-Hybrid

• Develop, maintain, and optimize dashboards and reports using Google PXL and Looker.
• Partner with stakeholders across business units to understand reporting needs and translate them into scalable data solutions.
• Design, implement, and manage ETL pipelines using Google Dataflow to ensure data accuracy and timeliness.
• Identify trends, patterns, and insights from large datasets to support business objectives.
• Ensure data integrity and perform validation checks across data sources and reports.
• Support ad-hoc reporting and deep-dive analysis as needed by teams.
• Continuously improve reporting processes, tools, and documentation.

• Bachelor's degree in Data Science, Computer Science, Mathematics, Statistics, or a related field.
• 3+ years of experience in data analytics or business intelligence.
• Proven experience working with Google PXL (Preferred), Looker, and dashboard development.
• Proficiency in SQL and working with large data sets.
• Experience building and managing data pipelines using Google Dataflow.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to communicate technical findings to non-technical stakeholders clearly and effectively.

• Works with the Client Strategy and Partnership teams to provide key monthly performance metrics on various measures aligned to Company priorities on a recurring and adhoc basis.
• Develops monthly process(es) to create performance reports in timely manner in conjunction with data availability
• Effectively coordinates and communicates reporting activities and documents all processes; and helps maintain procedures for organization
• Helps design reports, dashboards, and scorecards using tools such as Microsoft Excel or Power BI
• Establishes KPIs to measure the effectiveness of business decisions
• Performs data analysis on retention and renewal performance, group purchasing partner pipeline management and rebate preparation, quarterly AM team retention performance and other client performance metrics
• Reviews strategic account portfolio and identifies ways to represent business portfolio and opportunity focus
• Generates Excel Reports from Microsoft Dynamics CRM to Optimize KPI information on Renewal/Retention and Loss Data as part of Monthly Cadence
• Prepares AM Team's Quarterly Bonuses Incentive
• Ensures membership list accuracy and GPO reporting process milestones achieved quarterly
• Tracks overall progress of Strategic Account plan execution for growth
  • Creates presentations and reports based on recommendations and findings
• Maintains department headcount report and roster changes for leadership
• Communicates directly with Director, Client Strategy and SVP, Client Strategy and Partnerships in development of reports, as well as testing for data accuracy and reliability
• Responds to data requests in a timely and efficient manner with the highest level of quality
• Seeks customer satisfaction on all endeavors
• Additional responsibilities may be required
• Conducts job responsibilities in accordance with the standards set out in the Company's Code of Business Conduct and Ethics, its policies and procedures, the Corporate Compliance Agreement, applicable federal and state laws, and applicable professional standards

• Bachelor's Degree in Business Administration, Computer Science/CIS, or related fields. A combination of education and work experience will be taken into consideration
• Experience in data analysis (Education will be consideration). Strong analytical and critical thinking skill
• Excellent verbal and written communication skills
• Strong interpersonal skills to work effectively with internal and external customers
• Demonstrated ability to handle multiple tasks simultaneously and to prioritize accordingly
• Proven ability to work with a high degree of accuracy and attention to detail
• Proficient in all Microsoft office products including Excel, PowerBI, Access, PowerPoint, and Word
• Experience working with SAS, COGNOS, SQL, Server Manager, or other database management software is plus
• Self-starter with a commitment to continuous process improvements and improved service levels

• Assist in the migration of legacy Microsoft Access databases to SQL Server, including data modeling, transformation, and validation.
• Develop and maintain reports using Tableau, Crystal Reports, and Microsoft Access.
• Write and optimize SQL queries, stored procedures, and scripts for data extraction and transformation.
• Use SAS, SQL, and/or Python for advanced data manipulation and automation tasks.
• Provide production support for existing reporting and data solutions, ensuring data accuracy and timely delivery.
• Collaborate with business analysts and product owners to understand reporting needs and deliver actionable insights.
• Document processes, data flows, and technical specifications.

• Bachelors degree with a minimum of 2 years of experience as a data analyst or SQL/reporting developer.
• Experience with Microsoft Access, including forms, queries, and VBA.
• Experienced using SAS, Python, and/or SQL for complex data transformation.
• Experience developing reports and BI tools with SSRS, Crystal Reports, and Tableau.
• Strong analytical and troubleshooting skills.
• Ability to work effectively in a team environment and communicate with both technical and non-technical stakeholders.
• Experience supporting production environments and resolving data/reporting issues.

• Experience working in Agile/Scrum environments.
• Background in banking, finance, or commercial lending operations.
• Familiarity with loan servicing systems, financial data, or regulatory reporting.
• Experience with ETL processes and data warehousing concepts.

We're currently searching for a report developer with outstanding programming skills and a strong analytical mindset to help set our client up for success. Your responsibilities will include creating, testing, documenting, and maintaining new and existing systems for our projects in accordance with needs and specifications.

You'll be heavily involved in the conception phase with our department heads to get a feel for the exact requirements and expectations. The ideal candidate will provide accurate and timely completion of projects with minimal supervision.

This role offers a competitive salary, while the preference is to be hybrid in the Columbus area, but they are open to remote for the right individual.

KEY DUTIES AND RESPONSIBILITIES:

• Design, develop and maintain database and data warehousing systems
• Developing and implementing software tasks in accordance with our standards and methodologies
• Participate in knowledge-sharing and department meetings
• Complete projects in a timely and efficient manner
• Collaborate with departments, management, and peers to encourage and foster a highly cooperative environment
• Provide technical mentoring to peers as necessary
• Collaborate with data architect, team members, stakeholders, and project managers

• Bachelor's degree in computer science, engineering, or related field
• 3 years' experience in ETL and Data Management/Data Integration
• 3 years' experience in Power BI Report/Dashboard development or similar
• 3 years' experience in a back-end developer position
• 3 years of relational database experience
• 3 years of technical documentation
• 3 years SQL optimization skills
• Good demonstrable data visualization skills
• Excellent teamwork and interpersonal skills
• Excellent time management and organizational skills
• General understanding of networking and infrastructure
• Working knowledge of Windows OS and iOS
• Excellent technical documentation skills

• 5 years' experience as a report developer
• 5 years in all programming and framework experience
• Large scale, multi-site operations experience

• California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here .
• Virginia residents may access our state specific policies here .
• Residents of all other states may access our policies here .
• Canadian residents may access our policies in English here and in French here .
• Residents of countries governed by GDPR may access our policies here .

• the individual's skill sets, experience and training;
• licensure and certification requirements;
• office location and other geographic considerations;
• other business and organizational needs.

• Technical Skills : Proficiency in Oracle backend, Cognos, Snowflake, ThoughtSpot, and Excel. Minimal scripting experience required.
• Experience : Proven track record in migrating BI platforms, particularly from Cognos to ThoughtSpot.
• Communication : Excellent conversational skills, capable of engaging with various stakeholders.
• Availability : Able to start interviews next week and continue through April. Must be available for blocked interview slots on April 9th (11-1pm) and April 10th (2-4pm).

Mercalis is an integrated life sciences commercialization partner that provides comprehensive solutions that span the entire healthcare value chain. Backed by proven industry expertise and results-driven technology, Mercalis helps navigate the complex life sciences marketplace by providing commercialization solutions to accelerate value and enhance patient lives.

Mercalis fosters a culture that encourages individuality and provides opportunities for creativity, growth, and success while fostering a team environment. We are a diversity-driven organization with an inclusive approach to delivering patient-centric solutions that, eliminate barriers for patients, and increase patient access to life altering medications.

The Reporting & Analytics team provides ongoing support and insight to external clients, as well as to the internal operational leadership team.  The Data & Reporting Analyst must be able to review and analyze data, present conclusions in a logical and clear manner, and work effectively as part of a team, will provide and capture data and translate into information and reports and the transmission of this knowledge into actionable decisions. 

• Data & reporting expertise
  • Maintain up-to-date familiarity with Mercalis’ data sources/source systems
  • Serve as Subject Matter Expert to provide recommendations and expertise for data & reporting capabilities to assigned programs and/or clients
  • Investigate data anomalies (identified through own or users’ activities), communicate detailed findings to the appropriate person or group, and act as a valued partner in solution finding
  • Work with programming environments, SQL, MS Excel, MicroStrategy, free-form SQL, Mercalis’ CRM platforms, and other applicable software or BI tools
• Advanced custom reporting
  • Manage requirements gathering, specifications development, design and build of custom production-level reports for program ops, management, & client use
  • Make & own deliverable commitments (substance, format, and dev time), and provide timely communications re: status &/or delivery challenges. When conflicts arise, negotiate agreement on a path forward
  • Communicate clearly on requested deliverables, provide timelines and recommendations based on best practices, and prioritize work by accounts as necessary
  • Adhere to all corporate policies and procedures governing access to and distribution of PII and other confidential data
• Systems & process improvement
  • Identify opportunities to develop & implement solutions that streamline operations of frequent tasks
  • Identify, define, and coordinate with other departments to connect our data and reporting in new and innovative ways to improve Mercalis’ suite of products and services
• Leadership
  • Provide leadership and training to other team members on fundamental data mining and report creation techniques and applications
  • Assist program staff in the understanding & use of self-service reporting tools, and the use and interpretation of Mercalis data
  • Be curious, unafraid to ask questions, and seek to expand your own knowledge of new tools, Mercalis services+. We’re always growing and want you to be, too

• Bachelor’s degree in Math, Statistics, Economics, Finance, Computer Science, Engineering, or similar discipline.
• Must have 2+ years of client-facing experience.
• Experience interpreting data and presenting meaningful, client-ready business insights.
• Experience in data extraction, manipulation, analysis, reporting, and use of data visualization tools.
• Understanding of dimensional data modeling concepts and data warehousing.
• Excellent verbal and written communication skills.
• Ability to elicit and fine-tune requirements and respond to/manage changes.
• Solid technical writing skills. Ability to clearly and completely articulate work to be done and describe tasks using proper terminology.
• Mid-level proficiency in SQL programming and common query optimization techniques.
• Med-Advanced use of Excel for reporting & discovery (identify trends, interpret issues, find disparities)
• Knowledge of the pharmaceutical industry, health care, insurance, direct marketing, or finance is highly desirable.
• Mentoring emerging leaders and people development is

#LI-Remote

#LI-AM1