Sr. Data and Reporting Analyst

Mercalis•,

About The Position

The Reporting & Analytics team provides ongoing support and insight to external clients, as well as to the internal operational leadership team. The Senior 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. The Sr. Analyst may play a role in mentoring emerging leaders at Valeris.

Requirements

Bachelor’s degree in Math, Statistics, Economics, Finance, Computer Science, Engineering, or similar discipline
Must have 4+ 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
Extensive use of SQL/SQL Server for reporting, problem solving, & investigative work, and query optimization
Med-Advanced use of Excel for reporting & discovery (identify trends, interpret issues, find disparities)

Nice To Haves

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

Responsibilities

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
Maintain up-to-date familiarity with Valeris’ 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, Valeris’ CRM platforms, and other applicable software or BI tools
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 Valeris’ suite of products and services.
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 Valeris’ data
Be curious, unafraid to ask questions, and seek to expand your own knowledge of new tools, Valeris’ services+. We’re always growing and want you to be, too
Perform additional duties as assigned by Manager
On time adherence to training deadlines for all corporate policies and procedures governing access to confidential data
Ensure all SOPs are followed with consistency
Conducts miscellaneous tasks or projects as assigned

Benefits

Medical, dental, and vision plans, including HSA- and FSA-eligible options, with Valeris contributing toward premium costs
Additional health support, including telehealth and Employee Assistance Program (EAP) services
Company match on Health Savings Account contributions
Free Basic Life and AD&D coverage equal to your annual earnings, with a minimum of $50,000 and a maximum of $300,000
Company-paid Short-Term Disability coverage, with the option to purchase Long-Term Disability
401(k) Retirement Savings Plan with 100% match on the first 5% you contribute, with immediate vesting
Paid Time Off (PTO) and Sick Leave to support work-life balance
Team members receive nine paid holidays plus two floating holidays
Opportunities for advancement in a company that supports personal and professional growth
A challenging, stimulating work environment that encourages new ideas
Work for a company that values diversity and makes deliberate efforts to create an inclusive workplace
A mission-driven, inclusive culture where your work makes a meaningful impact