Business Analyst

Real Chemistry; United States; Remote; USD 50,000 - 60,000; Full time

Job summary

A progressive data analytics firm based in the United States is seeking a hands-on Business Analyst to enhance their sales operations. The ideal candidate will leverage advanced Excel and Power BI skills to manage data and create dashboards that ensure operational accuracy. Responsibilities include building models, data integration, and performing quality assurance. Ideal for someone with 1-2 years of related experience and a keen attention to detail.

Benefits

Comprehensive benefits program

Generous time off

Corporate perks

Qualifications

• 1–2 years of experience in business analytics, data operations, or sales ops.
• Advanced Excel skills including Power Pivot, formulas, and pivots.
• Experience building Power BI dashboards end-to-end.
• Practical habits around QA and documentation.
• Clear written communication skills for documentation.

Responsibilities

• Build robust Excel models for data shaping and aggregations.
• Build and publish datasets and Power BI dashboards.
• Extract and combine data from various operational systems.
• Implement systematic QA and proactively resolve data issues.

Skills

Excel modeling

Power BI development

Data integration

Quality assurance

Tools

Power Query

Salesforce

NetSuite

Python

Job description

Overview

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 substantial time 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.

Responsibilities

• 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 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.

Qualifications

• 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 is a plus.

Compensation and Benefits

Pay Range: $50,000 - $60,000

Real Chemistry offers a comprehensive benefits program tailored to your region, including corporate perks and generous time off where applicable.

Equal Opportunity and Accessibility

Real Chemistry is an Equal Opportunity employer. We strive to build an inclusive and equitable work environment where employees feel empowered to contribute their diverse experiences and expertise. Applicants are welcome to apply without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other characteristic protected by law. If you require accommodations during the interview process, please contact your recruiter.

For any concerns about accessibility or accommodations, please contact Human Resources.