Commercial Business Intelligence Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Take ownership of the development, maintenance, and enhancement of Power BI dashboards and reporting solutions for Global Commercial Operations.

• Create scalable data models, establish relationships, formulate calculated measures, and perform advanced DAX calculations along with Power Query transformations using M.

• Oversee Power BI Service workspaces, manage semantic models, schedule refreshes, configure gateways, and implement row-level security.

• Diagnose refresh failures, resolve reporting issues, identify performance bottlenecks, and address data inconsistencies.

• Construct interactive dashboards and streamline reporting processes.

• Extract, transform, and analyze Salesforce CRM data to support commercial reporting and operational decision-making.

• Maintain seamless integrations between Salesforce, Power BI, and other enterprise data sources.

• Handle Salesforce standard and custom objects, relationships, reporting frameworks, SOQL, and APIs.

• Collaborate with Salesforce administrators and IT to enhance data quality, improve integration, and refine reporting.

• Assist with pipeline, territory, account, opportunity, and sales effectiveness reporting.

• Compose and optimize complex SQL queries for large datasets.

• Utilize Python or other programming languages for workflow automation, data transformation, and analytical support.

• Develop and sustain ETL/ELT processes, reusable datasets, scripts, and automated reporting solutions.

• Set up data validation and reconciliation processes.

• Enhance data architecture and reporting performance while documenting models, business logic, scripts, and processes.

• Create dashboards that reflect sales performance, revenue trends, territory productivity, and commercial effectiveness.

• Evaluate sales and clinical field team performance against KPIs and business objectives.

• Assist in territory alignment, segmentation, targeting, resource allocation, compensation, incentive programs, and MBOs.

• Assess pipeline performance, account penetration, productivity, and identify growth opportunities.

• Support product launches, strategic initiatives, commercial expansion, forecasting, and business planning.

• Provide accurate daily, weekly, monthly, and quarterly reporting.

• Collaborate with Commercial Operations, Sales Leadership, Finance, Marketing, and IT to translate requirements into scalable solutions.

• Identify trends, risks, and opportunities through proactive analysis.

• Create executive dashboards and presentations for leadership and stakeholders.

• Clearly communicate technical findings while maintaining data governance and reporting consistency.

⛳️ Requirements

• A Bachelor’s degree in Business Analytics, Data Analytics, Computer Science, Information Systems, Finance, Engineering, or a related quantitative discipline.

• 4–7+ years of experience in Business Intelligence, Data Analytics, Sales Operations Analytics, or a similar technical analytical position.

• Proven experience in independently developing and managing enterprise Power BI solutions.

• Familiarity with Salesforce CRM data and integrating various enterprise systems.

• Advanced skills in Microsoft Power BI, including Power BI Desktop and Service, advanced DAX, Power Query/M, semantic models, performance tuning, refreshes, gateways, and security.

• Strong SQL skills, including complex joins, aggregations, subqueries, CTEs, window functions, transformations, and query optimization.

• Intermediate to advanced knowledge of Salesforce, covering CRM data architecture, standard/custom objects, reporting, extraction, SOQL and/or APIs, and BI integration.

• Working proficiency in Python for data manipulation, scripting, process automation, and troubleshooting.

• Advanced Excel skills.

• Experience with ETL/ELT processes and data integration.

• Background in data quality, validation, governance, and technical documentation.

• Preferred: experience in medical devices, healthcare technology, pharmaceuticals, or within a complex commercial environment.

• Preferred: experience supporting field-based sales organizations, compensation, territory management, forecasting, and commercial KPIs.

• Preferred: familiarity with Microsoft Fabric, Azure SQL, Azure Data Factory, or other cloud data platforms.

• Preferred: knowledge of QAD ERP, Power Automate, and Git/version control.

• Preferred: executive reporting experience and possession of Microsoft Power BI Data Analyst Associate (PL-300) certification or equivalent.

🏝️ Benefits

• Full-Time employment.

• Equal opportunity and commitment to diversity.

• Opportunity to work on innovative medical-device technology that enhances outcomes for patients with chronic neurological conditions.