Business Analyst at Real Chemistry

We are redirecting you to the source. If you are not redirected in 3 seconds, please click here.

Business Analyst at Real Chemistry. . Location: 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.. Real Chemistry is seeking a hands-on Business Analyst to build and maintain the technical foundations that power our sales operations and analytics—datasets, automations, and dashboards. You’ll spend most of your time working in Excel and Power BI to ingest, clean, reconcile, and publish trustworthy data for operational use. This role emphasizes tool proficiency, data quality, and repeatable processes to ensure the accuracy of pipelines, models, and dashboards. Join us and transform raw data into the backbone of operational excellence, driving efficiency and growth across the organization.. . What you’ll do:. . . Excel Modeling: . Build robust Excel models using INDEX/MATCH or XLOOKUP, SUMIFS, nested IFs, arrays, PivotTables, and Power Query/Power Pivot for data shaping and aggregations. Create data-validation rules, named ranges, and traceability tabs for auditability; optional VBA for repetitive tasks.. . Power BI Development: . Build and publish datasets and Power BI dashboards; implement refresh schedules and usage monitoring. Create, maintain, and document DAX formulas, calculated columns, and measures in Power BI to support accurate metrics, KPIs, and dynamic visualizations. Design interactive charts and visualizations (e.g., bar, line, KPI cards, slicers) to support decision-making across teams.. . Data Integration and Management: . Extract and combine data from Salesforce (CRM), NetSuite (ERP), and other operational systems via exports or connectors; maintain scheduled refreshes and file drops. Normalize and validate incoming files; implement schema, datatype, and null/duplicate checks; log and remediate exceptions. Maintain data dictionaries and source-of-truth mappings to ensure workflows are reproducible.. . Quality Assurance: . Implement systematic QA: row counts, variance vs. prior loads, and reconciliation back to system-of-record. Proactively identify and resolve data issues to ensure stakeholders have access to accurate, trusted data.. . . 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 adaptable, resilient, and OK with adjusting your scope, responsibilities, and focus as we grow. When things change, so do we. We’re always evolving.. . You are proactive, driven, and resourceful with strong prioritization skills and a desire to dive into the data.. . You are highly organized self-starter, able to work independently and under tight deadlines.. . . What you should have: . . . 1–2 years of experience (internships/co-ops count) in business analytics, data operations, or sales ops; or equivalent practical experience.. . Advanced Excel skills (including Power Pivot, formulas, and pivots); strong attention to detail and comfort with large, messy datasets.. . Experience building Power BI dashboards end-to-end (from data preparation through publishing).. . Practical habits around QA, documentation, and reproducibility (including data dictionaries, calculation catalogs, and runbooks).. . Clear written communication skills for documentation and handoffs.. . Experience with automation tools like Power Query, Power Automate, or Python to streamline processes, reduce manual steps, and enhance data handling efficiency is a plus.. . .  . . Pay Range:. $50,000 - $60,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: . www.realchemistrybenefits.com. .. . Working with Real HART: Since the pandemic, we have adapted to how our people told us they want to work. We have . office locations.  in cities in the US, UK, and Europe with many employees and clients that serve as hubs where and when they need us..  . For employees who are within an hour of one of our offices, we expect attendance in the office two days per week, either at a Real Chemistry office or onsite with clients. We are also actively opening new office locations, so if one opens near you, our Real HART policy will apply. We are not looking for attendance for the sake of attendance but believe that the opportunity to coordinate in-office team meetings, 1:1 meetings with managers, taking advantage of on-site learning, and connecting with client partners is a critical to delivering on our purpose of making healthcare what it should be..  . Outside of these offices, we have regions, where people work remotely but come together quarterly for collaboration, culture and learning opportunities. We call this our Real Hybrid and Regional Teams (Real HART) approach. Real Chemistry believes we are best together – and our workplace strategy fosters connection and collaboration in person – but also supports flexibility for our people.. . 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 bring from their personal lived experience and professional expertise, to make our team the best in the industry. We encourage motivated and qualified applicants to apply without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity/expression, ethnic or national origin, age, physical or mental disability, genetic information, marital information, or any other characteristic protected by federal, state, or local employment discrimination laws where Real Chemistry operates. Should you require accommodations throughout the interview process please let your recruiter know.. . *Notice: Real Chemistry and its affiliates' names are being misused by scammers through messaging services, fake websites, and apps. Do not share personal or financial information or make payments to any unverified sources claiming to be connected to Real Chemistry. We are working to stop these unauthorized activities and protect our community. Read more . here. .