Job Description
Job Description
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 dashboardsEngrain, PCC, NIC Maps, and other internal systemsDevelop and maintain Excel-based reports and tools to support pricing decisions and revenue analysisIdentify trends, anomalies, and opportunities across rent, fee, and occupancy dataBuild early-stage predictive models to help forecast performance and guide pricing strategyDiscrepancy Identification & Root Cause Analysis
Analyze inconsistencies across datasets and systemsInvestigate and resolve discrepancies by working closely with other departments (e.g., Sales, Finance, IT)Proactively flag data quality issues and suggest process improvementsSystem Collaboration & Cross-Functional Support
Serve as the primary point of contact between the pricing team and the Applications / IT TeamHelp troubleshoot data feeds, system connections, and report errors
Provide business context for application development needsCollaborate with internal teams to ensure smooth flow of information and report reliabilityPortfolio / Regional Support (Growth Opportunity)
Learn to support specific portfolios or regions with pricing and revenue dataBuild working knowledge of assigned communities and market conditionsEventually own reporting and analytics responsibilities for specific business areasQualifications
Required :
Bachelor’s degree in Business, Finance, Economics, Statistics, Data Science, or related fieldAdvanced proficiency in Microsoft Excel (pivot tables, VLOOKUP / XLOOKUP, data modeling, etc.)Strong analytical and problem-solving skillsExcellent attention to detail and follow-throughAbility to handle multiple data sources and organize reporting workflowsEagerness to learn the senior living industry and its pricing driversPreferred
Experience with any of the following systems : Salesforce, Yardi, Power BI, NIC Maps, Engrain, PCCExposure to data visualization or BI tools (e.g., Power BI, Tableau)Basic experience with SQL, Python, or other programming languages a strong plusUnderstanding of pricing or revenue analysis concepts a plusPrior internship or work experience in a data-heavy or analytical roleKey Competencies
Inquisitive & Analytical : Naturally curious with a drive to understand why the data says what it saysData-Driven : Thrives in Excel and enjoys working with numbers, charts, and trendsProblem-Solver : Enjoys tracking down data issues and recommending solutionsCollaborative Communicator : Able to work across departments and systems with a customer-service mindsetDetail-Oriented : Accurately handles large datasets and ensures report precisionSelf-Starter : Takes ownership of projects and asks smart questions to learn faster