Senior Data Analyst, Finance
Fresenius Kabi USA
full-time
Posted on:
Location Type: Office
Location: Lake Zurich • Illinois • 🇺🇸 United States
Visit company websiteSalary
💰 $90,000 - $100,000 per year
Job Level
Senior
Tech Stack
PythonSQL
About the role
- design Metrics & Reporting for the Customer Financial Services (CFS) department utilizing a range of tools (Power Query, Power BI, 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
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 BI, 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.
Benefits
- 401(k) plan with company contributions
- paid vacation
- holiday and personal days
- employee assistance program
- health benefits including medical, prescription drug, dental and vision coverage
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ExcelPower QueryPower BIAccessSQLdata governancedata analysisdata modelingdata miningroot cause analysis
Soft skills
communicationcollaborationindependent decision makingstrategic perspectivedetail management