Business Analyst Boston - Massachusetts; Carmel - Indiana; Chicago - Illinois; Lambertville Remote

At Real Chemistry, making the world a healthier place isn’t just an aspiration—it’s our everyday reality. Our drive to transform healthcare is informed by our blend of deep scientific expertise, human‑centred creativity, and AI‑driven insights, fostering a unique environment where innovation thrives and our people are impact‑obsessed. As a global agency, we provide a full suite of services across healthcare communications and marketing to our clients, including top players in the pharmaceutical and biotech industries.

Our #Lifeat Real Chem  culture is rooted in our people—we believe we are best together and are committed to excellence for both our clients and colleagues. Whether you’re a seasoned professional or just starting your career, if you share our passion for healthcare and connection, we invite you to explore our opportunities.

Discover your purpose. Embrace innovation. Experience #Lifeat Real Chem .

Business Analyst

Job Description:

Real Chemistry is seeking a curious, technically skilled Business Analyst to help turn complex commercial data into clear, trusted insights that guide business decisions. As part of Revenue Analytics, you will support the reporting and analytical foundations used to understand pipeline health, bookings performance, win rates, conversion, forecasting, and other go‑to‑market priorities. This is a hands‑on role for someone who enjoys solving problems, improving how work gets done, and using Excel, AI‑enabled tools, and data visualization to make information more accurate, accessible, and actionable.

You will gain broad exposure to revenue processes and cross‑functional stakeholders while building practical expertise in analytics, automation, data quality, and business storytelling.

What you'll do:

• Revenue Analytics and KPI Reporting: Support recurring and ad hoc analysis of pipeline health, bookings performance, win rates, conversion, forecasting, target attainment, and other go‑to‑market KPIs. Translate business questions into accurate analytical outputs and concise takeaways that help stakeholders understand performance, opportunities, and areas requiring follow‑up.
• Excel‑Based Analysis and Modeling: Build and maintain reliable Excel models and reporting tools using advanced formulas such as XLOOKUP or INDEX/MATCH, SUMIFS, nested IFs, arrays, Pivot Tables, Power Query, and Power Pivot. Structure workbooks for usability, traceability, and repeatability, and use automation capabilities where appropriate to reduce manual effort.
• AI‑Enabled Analytics and Process Improvement: Use Microsoft Copilot, CoWork, and other approved AI‑enabled tools to accelerate data analysis, reporting, documentation, quality checks, and repeatable workflows. Apply sound judgment when validating AI‑generated outputs and help identify practical opportunities to improve speed, consistency, and scalability.
• Data Integration and Management: Extract, combine, clean, and normalize data from Salesforce, Net Suite, and other operational systems through exports, connectors, and recurring file‑based processes. Perform schema, datatype, null, duplicate, and exception checks, and maintain clear source mappings and data dictionaries so workflows are reproducible.
• Quality Assurance and Data Stewardship: Reconcile analytical outputs to systems of record, review variances, and proactively identify, document, and help resolve data issues. Support consistent use of metric definitions, calculation logic, and reporting standards so stakeholders can rely on the information provided.
• Stakeholder Partnership and Communication: Partner with Revenue Analytics and cross‑functional teams to clarify reporting needs, document requirements and processes, and provide clear handoffs. Communicate findings,…