Data & Reporting Analyst

Freddie Mac; United States; Remote; USD 70,000 - 90,000; Full time

Job summary

A leading organization in life sciences seeks a Data & Reporting Analyst to join their Reporting & Analytics team. The ideal candidate will analyze data, generate custom reports, and influence decision-making through actionable insights. This role emphasizes collaboration, technical proficiency in SQL, data analysis, and effective communication skills while contributing to patient-centric solutions.

Benefits

401K with 5% matching

15 days PTO

Health/Dental/Vision coverage from day 1

Gym reimbursement

Volunteer hours

Qualifications

• 2+ years of client-facing experience is required.
• Experience in data extraction and reporting.
• Mid-level proficiency in SQL and Excel.

Responsibilities

• Maintain up-to-date knowledge of data sources.
• Serve as Subject Matter Expert for data reporting.
• Identify and implement improvements in data processes.

Skills

Data analysis

SQL programming

Excel

Data visualization

Education

Bachelor's degree in Math, Statistics, Economics, Finance, or related

Tools

MicroStrategy

CRM platforms

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

Responsibilities

• 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

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

Why work at Mercalis?

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