Business Analyst

Business Analyst

Boston - Massachusetts; Carmel - Indiana; Chicago - Illinois; Lambertville - New Jersey; Remote - USA

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 #LifeatRealChem 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 #LifeatRealChem.

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, PivotTables, 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, NetSuite, 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, limitations, assumptions, and data issues in a concise and practical manner.
• Data Visualization and Power BI Support: Contribute to dashboards and reporting views by preparing data, validating measures, documenting logic, and creating clear visualizations. Experience with Power BI, DAX, or dashboard publishing is valuable, but this role will primarily support and extend established reporting capabilities rather than own the full Power BI environment.

This position is a perfect fit for you if:

• Our Company values - Best Together, Impact-Obsessed, Excellence Expected, Evolve Always and Accountability with an "I" - really speak to you.
• You are analytically curious and enjoy investigating data, identifying patterns, and understanding the business context behind the numbers.
• You are proactive, resourceful, and comfortable taking ownership of detailed work while keeping the broader business objective in view.
• You are highly organized, attentive to detail, and able to manage deadlines, work independently, and ask thoughtful questions when requirements or results are unclear.
• You are adaptable and motivated to learn new tools, processes, and commercial concepts as the organization evolves.
• You are excited to use AI and automation as practical working tools while maintaining high standards for accuracy, judgment, privacy, and responsible data handling.

What you should have:

• Advanced Excel skills, including complex formulas, PivotTables, Power Query, and Power Pivot, with demonstrated comfort working with large or imperfect datasets.
• Strong analytical and problem-solving skills, including the ability to reconcile data, investigate variances, identify patterns, and develop clear, supportable conclusions.
• 1-2 years of experience, including internships or co-ops, in business analytics, data analytics, data operations, sales operations, revenue analytics, or a related field; or equivalent practical experience through coursework or a project portfolio.
• Practical habits around quality assurance, documentation, and reproducibility, such as maintaining data dictionaries, calculation logic, process documentation, or runbooks.
• Clear written and verbal communication skills, with the ability to summarize analytical findings, assumptions, and limitations for business audiences.
• Familiarity with Microsoft Copilot, CoWork, Claude, or similar AI productivity tools for analysis, research, documentation, or workflow improvement.
• Basic understanding of business KPIs and performance metrics. Exposure to sales organizations, revenue processes, Salesforce, CRM data, or commercial reporting is preferred but not required.
• Exposure to Power BI, including data preparation, DAX, dashboard development, or publishing through coursework, internships, prior roles, or a project portfolio, is a plus.

Pay Range: $55,000 - $65,000

This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on job-related, non-discriminatory factors including but not limited to work experience, skills, certifications, and geographical location. The Company reserves the right to modify this pay range at any time.

Real Chemistry is proud to be Great Place to Work® certified; check out what our people shared about our culture and workplace on our Great Places to Work Profile here.

We believe we can do our best when feeling our best, which is why we've put together a benefits program designed to give you the support you and your family need at every stage of life. Real Chemistry offers a comprehensive benefit program and perks, tailored to your region. Globally, this includes offices in our key markets with free snacks to keep you running all day long, generous holiday and paid time off, options for private medical, dental, and vison plans, and support in saving for the future. Other perks include mental wellness coaching and support and access to more than 13,000 online classes with LinkedIn Learning. Learn more about our great benefits and perks and search specific offerings in your region at:

At Real Chemistry, we believe we're at our best when we're connected. Our Real Hybrid and Regional Teams (Real HART) approach is designed to foster collaboration, learning, innovation, and meaningful relationships while providing flexibility where appropriate. Because our workforce spans multiple countries, regions, and client needs, work arrangements may vary by role and location. Some positions offer hybrid or remote flexibility, while others require regular in-office presence. For example, certain teams and regions, including some of our UK operations, have office-based requirements. Your recruiter will discuss the specific expectations for the role you're pursuing during the interview process and keep you informed throughout the hiring journey. For employees located within a one-hour commute of a Real Chemistry office, we require in-person attendance two days per week, either from a Real Chemistry office or when working onsite with clients. Employees in regions without a nearby office may work remotely and come together throughout the year for collaboration, culture-building, learning, and team connection opportunities. While these guidelines reflect our current workplace model, we understand that everyone's circumstances are unique. If you require additional flexibility, we welcome an open conversation with your recruiter and our HR team to discuss your needs and determine what may be possible.

Real Chemistry is an Equal Opportunity employer. We continually strive to build and sustain an inclusive and equitable work environment where our employees feel empowered to leverage all they