Note: The job is a remote job and is open to candidates in USA. Real Chemistry is a global healthcare communications and marketing agency that uses scientific expertise, creativity, and AI-driven insights to support healthcare clients. The Business Analyst will turn commercial data into trusted insights for revenue analytics, KPI reporting, forecasting, and go-to-market decisions while improving data quality, automation, documentation, and visualization. The role partners with cross-functional stakeholders and supports Excel, AI-enabled analytics, Salesforce, NetSuite, and Power BI workflows.
Responsibilities
- 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
- 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
- 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
- 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
- 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
- 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
- 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
Skills
- 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
- 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
Benefits
- Free snacks
- Generous holiday and paid time off
- Options for private medical, dental, and vision plans
- Support in saving for the future
- Mental wellness coaching and support
- Access to more than 13,000 online classes with LinkedIn Learning
- Some positions offer hybrid or remote flexibility, depending on role and location
- Employees located within a one-hour commute of a Real Chemistry office may work from a Real Chemistry office or onsite with clients two days per week
- 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
Company Overview
Company H1B Sponsorship