Common Sail Investment Group · 1 month ago
Data Analyst - Pricing
Brighton, MI
Full-time
Onsite
New Grad, Entry LevelCommonSail Investment Group is seeking a Data Analyst to support their Pricing and revenue strategy function. The role involves gathering, analyzing, and reporting pricing and revenue data, contributing to the company’s pricing strategy by identifying patterns and opportunities within the data.
Management Consulting
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
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
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
Learn to support specific portfolios or regions with pricing and revenue data
Build working knowledge of assigned communities and market conditions
Eventually own reporting and analytics responsibilities for specific business areas
Qualification
Required
Bachelor's degree in Business, Finance, Economics, Statistics, Data Science, or related field
Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, data modeling, etc.)
Strong analytical and problem-solving skills
Excellent attention to detail and follow-through
Ability to handle multiple data sources and organize reporting workflows
Eagerness to learn the senior living industry and its pricing drivers
Preferred
Experience with any of the following systems: Salesforce, Yardi, Power BI, NIC Maps, Engrain, PCC
Exposure to data visualization or BI tools (e.g., Power BI, Tableau)
Basic experience with SQL, Python, or other programming languages a strong plus
Understanding of pricing or revenue analysis concepts a plus
Prior internship or work experience in a data-heavy or analytical role
Company
Common Sail Investment Group
Common Sail Investment Group (CSIG) is privately owned and operated holding company, based in Brighton.
Founded in 2004
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Jessica Nelson
Human Resources Business Partner
John C. Fitzpatrick
Partner
Company data provided by crunchbase