Data & Reporting Analyst

at  Mercalis

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?

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

• 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, to