Mercalis · 3 days ago
Data & Reporting Analyst
Wonder how qualified you are to the job?
Maximize your interview chances
Pharmaceutical Manufacturing
Insider Connection @Mercalis
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
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
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)
Preferred
Knowledge of the pharmaceutical industry, health care, insurance, direct marketing, or finance is highly desirable.
Mentoring emerging leaders and people development is preferred.
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
Company
Mercalis
Mercalis is an integrated life sciences commercialization partner that provides comprehensive solutions that span the entire healthcare value chain.