Data & Reporting Analyst - Morrisville, North Carolina, United States - Mercalis

Description

Overview:
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 and provides 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, increase access to medications, and help patients receive life-saving treatments.

As a Data and Reporting Analyst, you will join our team on a journey to help eliminate barriers for patients, increase their access to medications, and help them receive lifesaving treatments, while working in an environment that nurtures you.

The Reporting & Analytics team provides ongoing support and insight to external clients, as well as to the internal operational leadership team.

As a member of this team, the Data & Reporting Analyst will provide expertise on the capture of data, the translation of it into information/reports, and the transmission of this knowledge into actionable decisions which further the goals of our clients.

The 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.

Responsibilities:

• Data & reporting expertise

o Maintain up-to-date familiarity with Mercalis' data sources/source systems.

o Assist program staff in the understanding & use of self-service reporting tools, and the use and interpretation of Mercalis data.

o 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.

o Work with programming environments (SQL, Excel, MicroStrategy, free-form SQL), Mercalis' CRM platforms, and other applicable software or BI tools.

• Advanced custom reporting

o Manage requirements gathering, specifications development, design and build of custom production-level reports for program ops, management, & client use.

o Make & own deliverable commitments (substance, format, and dev time), and provide timely communications regarding status &/or delivery challenges.

When conflicts arise, negotiate agreement on a path forward.

o Communicate clearly on requested deliverables, provide timelines and recommendations based on best practices, and re-prioritize work as needed to align with client/program needs.

o Adhere to all corporate policies and procedures governing access to and distribution of PII and other confidential data

• Systems & process improvement

o Identify opportunities to develop & implement solutions that streamline operations of frequent tasks.

o Document deliverables & other work products centrally for others' use to enable continued timely and effective client support during time away from work (planned or unplanned).

o Identify, define, and coordinate with other departments on opportunities to connect our data and reporting in new and innovative ways to improve Mercalis' suite of products and services.

• Perform additional duties as assigned by manager.

Qualifications:
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 foster effective collaboration and discussions with in-/external clients and teams.

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 query optimization techniques.

Medium-Advanced use of Excel for reporting & discovery (identify trends, find & interpret issues)

Knowledge of the pharmaceutical industry, health care, insurance, direct marketing, or finance is highly desirable.

Why work for Mercalis?

Diversity, Equity, Inclusion & Belonging are paramount to our culture and success. Our dedication to DEI&B is both organic and intentional

Our Mission is rewarding and fulfilling (Patient Access to Life-Saving/Improving/Extending Medications/Treatments)

We employ the best Talent and Tools from the Patient Access Industry (We are the Industry Leader)

We monitor the market to ensure we offer competitive salaries and benefits.

401K w/ 5% matching; day-1 vestment period

15 days PTO

7 Holidays + 2 Floating Days

Health/Dental/Vision/Life; Coverage Day-1

Gym Reimbursement

Volunteer Hours

*This is not an exhaustive list of benefits.

*Benefits are subject to change.

Some positions require onsite presence and/or structured hours/shifts.