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
1. Data Analysis & Reporting
2. 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
3. Develop and maintain Excel-based reports and tools to support pricing decisions and revenue analysis
4. Identify trends, anomalies, and opportunities across rent, fee, and occupancy data
5. Build early-stage predictive models to help forecast performance and guide pricing strategy
Discrepancy Identification & Root Cause Analysis
6. Analyze inconsistencies across datasets and systems
7. Investigate and resolve discrepancies by working closely with other departments (e.g., Sales, Finance, IT)
8. Proactively flag data quality issues and suggest process improvements
System Collaboration & Cross-Functional Support
9. 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
10. Collaborate with internal teams to ensure smooth flow of information and report reliability
Portfolio / Regional Support (Growth Opportunity)
11. Learn to support specific portfolios or regions with pricing and revenue data
12. Build working knowledge of assigned communities and market conditions
13. Eventually own reporting and analytics responsibilities for specific business areas
Qualifications
Required:
14. Bachelor’s degree in Business, Finance, Economics, Statistics, Data Science, or related field
15. Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, data modeling, etc.)
16. Strong analytical and problem-solving skills
17. Excellent attention to detail and follow-through
18. Ability to handle multiple data sources and organize reporting workflows
19. Eagerness to learn the senior living industry and its pricing drivers
Preferred
20. Experience with any of the following systems: Salesforce, Yardi, Power BI, NIC Maps, Engrain, PCC
21. Exposure to data visualization or BI tools (e.g., Power BI, Tableau)
22. Basic experience with SQL, Python, or other programming languages a strong plus
23. Understanding of pricing or revenue analysis concepts a plus
24. Prior internship or work experience in a data-heavy or analytical role
Key Competencies
25. Inquisitive & Analytical: Naturally curious with a drive to understand why the data says what it says
26. Data-Driven: Thrives in Excel and enjoys working with numbers, charts, and trends
27. Problem-Solver: Enjoys tracking down data issues and recommending solutions
28. Collaborative Communicator: Able to work across departments and systems with a customer-service mindset
29. Detail-Oriented: Accurately handles large datasets and ensures report precision
30. Self-Starter: Takes ownership of projects and asks smart questions to learn faster