Business Analyst - Commercial

Compunnel, Inc.; Pittsburgh (Allegheny County); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology firm in Pittsburgh is seeking a Business Data Analyst to support the development of an AI-powered Commercial Intelligence Platform. The role involves aligning business and data requirements, maintaining data accuracy across platforms, and developing dashboards for KPIs. Ideal candidates have over 5 years of experience in CRM data management and are proficient in Power BI, Excel, and SQL.

Qualifications

• Minimum of 5 years of experience managing CRM and commercial data.
• Advanced proficiency in Power BI, Excel, and SQL.
• Understanding of data governance and validation best practices.

Responsibilities

• Define and document business and data requirements.
• Collaborate with IT and analytics teams.
• Map and analyze business processes and data flows.
• Develop and maintain dashboards and analytical models.
• Drive data quality validation and governance processes.

Skills

CRM management

Data visualization

ETL processes

Data integration

Collaboration

Data governance

Communication

Education

Bachelor’s degree in Business Analytics

Bachelor’s degree in Data Science

Tools

Salesforce

Power BI

SQL

Databricks

AWS

Job description

We are seeking a Business Data Analyst to support the development of an AI-powered Commercial Intelligence Platform that accelerates collaboration and enables data-driven decision-making across global sales teams.

This role serves as a critical link between business stakeholders, data teams, and system SMEs, translating commercial needs into actionable data and analytics requirements while ensuring CRM, AI, and BI platforms deliver measurable value.

Key Responsibilities

• Define and document business and data requirements to align objectives with technical solutions.
• Collaborate with IT, analytics, and AI teams to maintain data accuracy and usability across platforms such as Salesforce, Power BI, and AI tools.
• Map and analyze business processes and data flows to identify inefficiencies and automation opportunities.
• Develop and maintain dashboards, KPI frameworks, and analytical models to measure adoption and impact.
• Drive data quality validation and governance processes for CRM and commercial data.
• Partner with stakeholders for solution testing, validation, and rollout to ensure smooth adoption.
• Deliver post-deployment impact assessments showcasing adoption rates and revenue growth drivers.

Required Qualifications

• 5+ years of experience managing CRM and commercial data (Salesforce preferred).
• Advanced proficiency in Power BI, Excel, and SQL for analytics and visualization.
• Strong knowledge of ETL processes, data integration, and process mapping.
• Understanding of data governance and validation best practices.
• Hands‑on experience with Databricks, AWS, and AI‑driven platforms (e.g., ChatGPT).
• Proven ability to build BI models linking operational metrics to strategic outcomes.
• Strong collaboration and stakeholder engagement skills.
• Excellent communication and storytelling abilities to convert data into actionable insights.

Preferred Qualifications

• Bachelor’s degree in Business Analytics, Data Science, Information Systems, or related field.
• 5+ years of experience as a Business Data Analyst or BI Analyst in enterprise settings.
• Familiarity with AI‑augmented analytics or GPT‑based platforms.
• Experience in sales operations, marketing analytics, and commercial strategy frameworks.