Sr Data Analyst

6 hours ago

Lake Zurich, IL, United States Fresenius Kabi USA, LLC Full time
Job Summary The Sr. Data Analyst focuses on designing and implementing data-driven solutions to enhance efficiency and accuracy within the Customer Financial Services (CFS) department. Responsibilities include developing metrics, KPIs, and dashboards using tools like Power BI, Power Query, and Snowflake to provide actionable insights for senior leadership. The position emphasizes establishing and maintaining data governance standards to ensure data quality, integrity, and consistency across processes. Collaboration with cross-functional teams such as Chargeback, Credit & Collections, Customer Master, and Rebate groups is essential to deliver meaningful reports and support strategic initiatives. Additionally, the role drives alignment with Commercial Excellence to maintain customer data quality and reporting best practices.

Salary Range: 80,000 -98,000 per year
* Position is eligible to participate in a bonus plan with a target of 6% of the base salary (include only if applicable to the grade level)
* Final pay determinations will depend on various factors, including, but not limited to experience level, education, knowledge, skills, and abilities.
* Our benefits and programs are comprehensive and thoughtfully crafted to ensure our colleagues live healthy lives and have support when it matters most. Benefits offered include a 401(k) plan with company contributions, paid vacation, holiday and personal days, employee assistance program, and health benefits to include medical, prescription drug, dental and vision coverage.

Applicants must be authorized to work for ANY employer in the United States. Fresenius Kabi is unable to sponsor or take over sponsorship of an employment visa either now or in the future. Responsibilities

The Sr Data Analyst will design Metrics & Reporting for the Customer Financial Services (CFS) department utilizing a range of tools (Power Query, Power Bl, Access, Excel, etc.). Design & Track KPl's across the CFS department and provide feedback & insight to the Senior Director. Build and maintain Dashboards for the CFS group that provide insight from a management level and allow management to identify actionable items.

Build Reporting Models that reduce time spent analyzing and building, increases group efficiency and ensures data accuracy.

Identify trends/anomalies in the data collected to understand the source of data inaccuracies. Assist value mapping and designing new or improving old inefficient processes Collaborate with the Chargeback, Credit & Collections, Customer Master & Rebate managers to provide meaningful reports and project assistance.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Communicate clearly and effectively with team members.

Provide insight to Charge back & Rebate groups with data mining and understanding of current trends.

Assist and maintain models within wholesaler monitoring program. Assist in the efforts to establish data governance standards, ensure data quality and integrity, and optimize processes for maintaining customer information.

Collaborate with cross-functional teams to define data requirements, establish data quality metrics, and implement data management best practices. Alignment with Commercial Excellence on Customer Master data integrity and reporting.

All employees are responsible for ensuring the compliance to company documents, programs and activities related to the Health, Safety, Environment, Energy, and Quality Management Systems, as per your roles and responsibilities.

Requirements

  • Bachelor's degree in finance, Mathematics, Computer Science, or 3-5 years of related work experience
  • 5-8 years of Finance, Chargeback, Credit & Collections, Master Data or Rebate experience required.
  • Expert in Excel/Power Query/Access required
  • Working SQL knowledge and experience working with relational databases, query authoring (SOL) as well as working familiarity with a variety of databases required.
  • Comfortable learning and utilizing new tools (Python, Power Bl, Qlik etc.)
  • Data governance knowledge
  • Knowledgeable with Financial Statements, Chargebacks, Rebates & Model N required
  • Chargeback & Rebate background in the Pharmaceutical Industry desired
  • SAP experience desired
  • The ability to work in a complex and changing environment with minimal supervision, make independent decisions and work within a team environment.
  • Ability to initiate complex analysis, manage details, and provide strategic perspective.
Additional Information

We offer an excellent salary and benefits package including medical, dental and vision coverage, as well as life insurance, disability,401K with company contribution, andwellness program.

Fresenius Kabi is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, citizenship, immigration status, disabilities, or protected veteran status.

  • Sr Rebates Analyst

    3 days ago

    Lake Zurich, IL, United States Fresenius Kabi USA, LLC Full time

    Job Summary The Sr. Rebate Analyst is responsible for providing analytical support primarily to the Finance, Sales, National Accounts & Commercial Contracting and Analysis groups and assigned Primary GPO, National Account and Managed Care customers. This includes contract sales analysis and reporting, rebates and administrative fee analysis and payments,...

  • Sr Rebates Analyst

    6 hours ago

    Lake Zurich, IL, United States Fresenius Kabi Full time

    Job Summary The Sr. Rebate Analyst is responsible for providing analytical support primarily to the Finance, Sales, National Accounts & Commercial Contracting and Analysis groups and assigned Primary GPO, National Account and Managed Care customers. This includes contract sales analysis and reporting, rebates and administrative fee analysis and payments,...

  • Sr. Analyst, Contract Marketing

    2 weeks ago

    Lake Zurich, IL, United States Fresenius Kabi USA, LLC Full time

    Job Summary The Senior Analyst (Membership) is responsible for all membership and class of trade activities. Extracts, analyzes, and interprets data from an array of systems to address compliance issues. Internal liaison between Finance, customer service, data services, and Contract Operations. The Sr. Analyst also prepares and summarizes commercial and...

  • Sr. Analyst, Contract Marketing

    1 week ago

    Lake Zurich, IL, United States Fresenius Kabi USA, LLC Full time

    Job Summary The Senior Analyst (Membership) is responsible for all membership and class of trade activities. Extracts, analyzes, and interprets data from an array of systems to address compliance issues. Internal liaison between Finance, customer service, data services, and Contract Operations. The Sr. Analyst also prepares and summarizes commercial and...

  • Sr. Analyst, Contract Marketing

    8 hours ago

    Lake Zurich, IL, United States Fresenius Kabi USA, LLC Full time

    Job Summary The Senior Analyst (Membership) is responsible for all membership and class of trade activities. Extracts, analyzes, and interprets data from an array of systems to address compliance issues. Internal liaison between Finance, customer service, data services, and Contract Operations. The Sr. Analyst also prepares and summarizes commercial and...

  • Sr. Analyst, Contract Marketing

    2 weeks ago

    Lake Zurich, IL, United States Fresenius Kabi Full time

    Job Summary The Senior Analyst (Membership) is responsible for all membership and class of trade activities. Extracts, analyzes, and interprets data from an array of systems to address compliance issues. Internal liaison between Finance, customer service, data services, and Contract Operations. The Sr. Analyst also prepares and summarizes commercial and...

  • Sr. Analyst, Contract Marketing

    1 week ago

    Lake Zurich, IL, United States Fresenius Kabi Full time

    Job Summary The Senior Analyst (Membership) is responsible for all membership and class of trade activities. Extracts, analyzes, and interprets data from an array of systems to address compliance issues. Internal liaison between Finance, customer service, data services, and Contract Operations. The Sr. Analyst also prepares and summarizes commercial and...

  • Sr Analyst, Serialization

    7 days ago

    Lake Zurich, IL, United States Fresenius Kabi Full time

    Job Summary The Senior Serialization Analyst is a key role within Supply Chain that will be responsible for monitoring and maintaining internal and external metrics associated with serialization compliance. They perform data-driven analysis and use that information to identify trends and proactively communicate to both internal and external stakeholders...

  • Sr Analyst, Serialization

    12 hours ago

    Lake Zurich, IL, United States Fresenius Kabi Full time

    Job Summary The Senior Serialization Analyst is a key role within Supply Chain that will be responsible for monitoring and maintaining internal and external metrics associated with serialization compliance. They perform data-driven analysis and use that information to identify trends and proactively communicate to both internal and external stakeholders...

  • Sr. Treasury Analyst

    2 days ago

    Lake Zurich, IL, United States ACCO Brands Full time

    Achieve. Create. Collaborate. Organize. Essential brands. Innovative products. Smart investment. Winning team. This is what you will find at ACCO Brands. We are passionate about building a culture that is committed to the success of our employees. If you are looking for an organization that offers rewarding opportunities and is dedicated to team orientation,...