Senior Data Analyst

Integrated Resources, Inc.
Lake Zurich, IL, United States
about 2 months ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
$93,600.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Access Microsoft Excel Databases Customer Data Management Data Governance Data Mining Relational Databases Python (Programming Language) SAP ERP Power BI Standard Sql SQL Databases
+6 more
Snowflake Powerquery Information Technology Data Analytics Qlikview Data Management

Job description

  • 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.

PRINCIPAL ACTIVITIES PERFORMED BY THE INCUMBENT

  • 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.

Requirements

Do you have experience in SQL?, Do you have a Bachelor’s degree?, * 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.

IRI-IT

Benefits & conditions

Pulled from the full job description

  • 401(k)
  • Health insurance
  • Dental insurance, * 401(k)
  • Dental insurance
  • Health insurance

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:52 min

Navigating data warehouse performance for application developers

Adnan Rahic · JS Congress

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

1:34 min

Bringing diverse skills to industrial data science roles

Katja Träumner

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

Videos

See all

Related articles

See all