Offer summary

Qualifications:

1+ years of relevant work experience or undergraduate internship preferred., Advanced skills in Microsoft Office, particularly Excel and PowerBI., Proficiency with Azure SQL Database and Azure Data Lake., Strong analytical skills and attention to detail..

Key responsabilities:

Design and maintain PowerBI dashboards and Excel reports with quality control measures.

Perform data entry, validation, and system maintenance for contracts.

Analyze data trends and provide insights into marketplace developments.

Act as a superuser for the contract lifecycle management tool (Salesforce) and manage SOP changes.

Job description

Organization Summary

Averon is a joint venture between CVS Health and Cardinal Health with a vision of transforming the landscape of biosimilars and simplifying the channel for specialty products. Our mission is: together, we will lower the cost of specialty products for our customers.

Position: Analyst (Contracts, Analytics and Data Management)

Reports to: Chief of Staff

Position Summary

The Analyst, (Contracts, Analytics and Data Management) position encompasses a variety of responsibilities, including supporting the entire team through activities related to contracts and data validation. The primary focus will be on contract maintenance and validation, as well as data entry, auditing, and data reconciliation. This role operates within a dynamic, collaborative, remote environment. Success in this position requires strong critical thinking skills, passion for analytics, and high degree of accuracy.

Location

Fully remote (open to candidates based nationwide) - though most ideal would be someone based within commutable distance of Oregon City, Oregon (where our office is located)

Core Responsibilities

Data Visualizations

Design, create, and maintain PowerBI dashboards and Excel as needed, implementing quality control measures.
Contribute to effective use of dashboards and visualizations that clearly convey the necessary information to the target audience.
Synthesize complex information into digestible ideas.
Communicate findings and insights through presentations and reports, primarily in PowerPoint.

Data Management

Data entry and system maintenance associated with contracts within Averon’s internal custom applications and Microsoft Azure Data Platform.
Ensure daily data feeds are loaded and validated within Azure and Power BI.
Maintain Microsoft Azure Data Platform and Power BI dashboards.
Handle ad hoc data requests and analysis for occasional needs not covered by dashboards and other tools.
Document data and how it was identified.

Data Analysis and Trends

Gather insights from Averon subject matter experts to identify root cause and solutions, and partner closely with stakeholders to drive desired results.
Perform routine reconciliations of data feeds coming to Averon from manufacturers, parent organizations, and wholesalers. This includes analyzing data variances for contract alignment as needed.
Support in analyzing and troubleshooting issues as identified with reconciliations and determine steps for resolution.
Align data from various sources into a usable format.
Provide insights into marketplace trends, including new biosimilar launches and product availability.

System Administration

Super User/System Administrator of contract lifecycle management tool (Salesforce)
Own and manage all changes to Data Validation SOPs and dashboard SOPs, communicate changes, and document all changes.

Qualifications

Education and Experience

Targeting individuals with 1+ years of work (or undergraduate internship) experience consistent with our role’s listed responsibilities (highly preferred).

Technical Skills

Advanced Microsoft Office Skills (Excel, PowerBI, MS Teams, SharePoint, etc.).
Proficiency with Azure SQL Database and Azure Data Lake.
Proficiency with Salesforce from a superuser/admin perspective (willingness to learn).

Analytical Skills

Proven ability to efficiently and effectively use analytical skills to gather insights and data from multiple platforms to support business analyses.

Soft Skills

Demonstrated ability to manage multiple workstreams.
Strong team player with solid communication skills.
Strong attention to detail and process driven.

Candidates who are back-to-work, people with disabilities, without a college degree, and Veterans are encouraged to apply.

Cardinal Health supports an inclusive workplace that values diversity of thought, experience and background. We celebrate the power of our differences to create better solutions for our customers by ensuring employees can be their authentic selves each day. Cardinal Health is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, ancestry, age, physical or mental disability, sex, sexual orientation, gender identity/expression, pregnancy, veteran status, marital status, creed, status with regard to public assistance, genetic status or any other status protected by federal, state or local law.

To read and review this privacy notice click here

Required profile