Data Consultant

Spectraforce; North Chicago (IL); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Spectraforce is seeking a BTS MA Data Consultant – Neuroscience Portfolio to support data analytics and data stewardship for the Parkinson’s portfolio. You will review data from specialty pharmacy and external partners, monitor data quality, and translate findings into dashboards and actionable insights for internal teams and vendors.

The role collaborates with Market Access, Trade, and technology teams, leveraging SQL, Power BI, and Dataiku to deliver data-driven decisions and solutions.

Qualifications

• Bachelor’s degree with relevant analytics experience and 6 years total.
• 3+ years of SQL, Dataiku, storytelling, and dashboarding tools.
• Experience with patient-level healthcare data and data stewardship.
• Strong communication, collaboration and project leadership skills.

Responsibilities

• Review and validate data from specialty pharmacy, trade, and partners.
• Develop and maintain Power BI dashboards and visualizations.
• Use SQL and analytics tools to investigate data issues.
• Support data onboarding, data management, and process improvements.
• Translate data findings into actionable insights for stakeholders.

Skills

SQL

Dataiku

Power BI

Data storytelling

Data visualization

Advanced Excel

Stakeholder management

Communication skills

Education

Bachelor’s degree in Analytics

Tools

Power BI

Snowflake

Job description

Work Schedule: Mon – Friday, 9am – 5pm (Hybrid – On Site Tues, Wed, Thurs)

Duration: Till Dec. 31st, 2027

Job Description: BTS MA Data Consultant – Neuroscience Portfolio

As part of US Commercial organization, this role is responsible for execution of patient services and Market Access data strategy for Neuroscience portfolio. Work in cross collaboration with Commercial patient services, Commercial Analytics, Trade & Distribution, Access & Reimbursement and external partners. Work closely with a team of Project Managers, and BSAs to support the strategic and tactical needs of Market Access organization.

Key responsibilities include:

• Understand Market Access Supply chain and Access and Reimbursement business processes and gaps. Responsible for Identifying and defining solutions to address business demand.
• Establish and maintain high-quality relationships with all levels across the company and with external partners.
• Effectively manage communications and expectations with internal and external stakeholders.
• Works directly with Market Access Trade function and Patient Services to understand specific business needs.
• Monitor, analyze and communicate data trends for data quality and compliance through data analytics using PowerBI and other available tools.
• Prioritize and elevate communications with appropriate partners and teams as needed.
• Provide ad-hoc data analytics for stakeholders and general inquiries.
• Identify areas or improvement within the data flows and work with proper teams for implementation.
• Manage the Data Quality rules and report Data Compliance for all brands with Trade Marketing/ Program Solutions and Specialty Pharmacy partners.

Qualifications:

• Bachelor’s Degree with 6 years’ experience
• 3+ years of experience with SQL, Dataiku, storytelling, and dashboarding tools.
• 3+ years of experience working with patient level data like SHA PTD, IQVIA APLD and LAAD, EDI such as 867, 852, 844, 850, 810, 845, Truven, and/or Real-World Evidence.
• Hands‑on experience with Data Lake and Snowflake architecture and Bigdata tools and technologies.
• Strong understanding of data management disciplines including Data Warehousing, Data Integration, Data Visualization, Advanced Analytics, Big Data Platforms/Elastic Scale, Artificial Intelligence, and other data centric technologies.
• Experience working within Market Access, Specialty Pharmacy, and/or Supply Chain/Trade.
• Proven implementation of creative technology solutions that advanced the business.
• Exceptional interpersonal, communication and strong analytical skills. Proven ability to build trust, listen and ask effective questions.
• Proven track record of effective project leadership and positive results. Ability to self‑manage time and priorities.
• Advanced knowledge of Excel.
• In‑depth knowledge of pharmaceutical and healthcare business and good knowledge of the rapid advancement of agile, impactful, and cost‑effective solutions is preferred.

Job Summary

The role will support data analytics and data stewardship activities for the Parkinson’s disease brand portfolio, with a primary focus on reviewing data received from specialty pharmacy and other external partners. This individual will monitor incoming data for accuracy, completeness, and alignment with business expectations; analyze trends; identify abnormalities or potential concerns; and communicate findings and recommended solutions to internal teams and external partners.

This role will serve as a key connection between business stakeholders, data teams, Trade Marketing, Trade Program Solutions, brand leadership, technology teams, and external vendors. The Analyst will help translate business needs into practical data solutions, create clear dashboards and visual reports, and explain complex information in a way that supports informed business decisions.

The ideal candidate will bring strong experience with data analytics or data stewardship, SQL, Power BI, data storytelling, and healthcare or pharmaceutical data. Success in this role will require someone who is highly analytical, detail‑oriented, collaborative, and comfortable building relationships across technical and non‑technical teams.

The individual should be able to work independently, manage competing priorities, take ownership of assignments, and communicate clearly when identifying data issues or opportunities for improvement.

Key Responsibilities

• Review and validate data received from specialty pharmacy, trade, and other external partners.
• Monitor data quality, trends, and business rules to identify abnormalities, gaps, or potential concerns.
• Communicate findings, risks, and recommendations to Trade teams, brand leadership, business technology teams, and external partners.
• Develop and maintain Power BI dashboards, reports, and visualizations that clearly communicate business insights.
• Use SQL and other analytics tools to investigate data issues and answer business questions.
• Support data onboarding, data management, and improvements to data flows and processes.
• Partner with internal teams and vendors to understand business needs and develop practical solutions.
• Translate complex data and technical information into clear, actionable insights.
• Provide project support for data-related initiatives, including coordination, follow‑up, documentation, and issue resolution.
• Help ensure healthcare and pharmaceutical data is accurate, complete, timely, and aligned with business expectations.

Preferred Background

• Bachelor’s degree in Analytics, Data Science, Information Systems, Business, or a related field.
• Approximately six years of relevant professional experience.
• At least three years of experience with SQL, Power BI or similar dashboarding tools, data storytelling, and data analysis.
• Experience working with patient‑level, specialty pharmacy, pharmaceutical, Market Access, trade, claims, EDI, or real‑world data.
• Experience with data stewardship, data quality, data management, or data visualization.
• Familiarity with Dataiku, Snowflake, data lakes, or similar data platforms is beneficial.
• Experience supporting projects or process improvements is preferred but not required.
• Strong written and verbal communication skills, interpersonal skills, and attention to detail.
• Demonstrated ability to build trust, ask effective questions, work independently, manage time effectively, and take ownership of deliverables.
• This person will review healthcare data, identify and explain what is happening, help fix data problems, and create clear insights that support the Parkinson’s brand teams and business partners