Data Analyst - Pricing

Data Analyst - Pricing

CommonSail Investment Group

Brighton, Michigan

Position Summary

The Data Analyst plays a critical role in supporting our Pricing and revenue strategy function.

This is a high-impact, hands-on role that focuses on gathering, analyzing, and reporting pricing and revenue data from multiple systems and platforms. This role is a key contributor to the company’s pricing strategy by identifying patterns, discrepancies, and opportunities within our data.

This position is ideal for someone who is passionate about solving business problems through data, thrives in Excel, and wants to grow in a fast-paced, purpose-driven organization.

Key Responsibilities

• Data Analysis & Reporting
• Aggregate, clean, and analyze data from multiple sources including:
  • Salesforce (CRM)
  • Yardi (Property Management System)
  • Power BI dashboards
  • Engrain, PCC, NIC Maps, and other internal systems
• Develop and maintain Excel-based reports and tools to support pricing decisions and revenue analysis
• Identify trends, anomalies, and opportunities across rent, fee, and occupancy data
• Build early-stage predictive models to help forecast performance and guide pricing strategy

Discrepancy Identification & Root Cause Analysis

• Analyze inconsistencies across datasets and systems
• Investigate and resolve discrepancies by working closely with other departments (e.g., Sales, Finance, IT)
• Proactively flag data quality issues and suggest process improvements

System Collaboration & Cross-Functional Support

• Serve as the primary point of contact between the pricing team and the Applications/IT Team
  • Help troubleshoot data feeds, system connections, and report errors
  • Provide business context for application development needs
• Collaborate with internal teams to ensure smooth flow of information and report reliability

Portfolio / Regional Support (Growth Opportunity)

• Learn to support specific portfolios or regions with pricing and revenue data
• Build working knowledge of assigned comm