Data Analyst (AI)
About The Position
Reef Capital is seeking an AI-forward analytics professional to translate business questions into trusted answers for teams across real estate, hospitality, investments, and membership. The analyst will define important metrics and independently build dashboards and analyses in Reef Analytics, Reef’s internal analytics application. AI agents and coding tools such as Claude Code and Cursor are intended to be primary development partners. The role owns work from initial request through delivery, including ambiguous requests and the polished, white-glove experience expected by stakeholders and executives. The position partners with stakeholders to clarify needs, define metrics, model and validate data, develop dashboards and reports, uncover insights, and support data governance. It also works closely with the Data Engineer on data discrepancies, integrations, and pipeline improvements, and uses GitHub pull requests and Jira to manage and deliver work.
Requirements
- Bachelor’s degree in Data Analytics, Business Intelligence, Computer Science, Statistics, Information Systems, or a related field.
- At least 3 years of experience in data analysis, business intelligence, or a similar role.
- Strong business acumen and ability to translate complex data into clear, actionable insights for non-technical stakeholders.
- Experience building dashboards in Power BI, Tableau, Looker, or a similar BI tool, with a strong grasp of data visualization and dashboard design.
- Solid knowledge of SQL for querying and manipulating data.
- Familiarity with enterprise applications such as Salesforce, Microsoft 365, and HubSpot, and data platforms such as Snowflake, AWS S3, or Microsoft Fabric data lakes.
- Experience with data modeling, creating data dictionaries, and defining business metrics.
- Excellent communication skills for presenting findings to technical and business audiences.
- Strong problem-solving and analytical thinking skills, with attention to detail.
- Ability to manage multiple priorities and collaborate effectively in a cross-functional environment.
- Familiarity with project management basics such as Kanban, Agile/Scrum, or Waterfall, and tools such as Jira.
Nice To Haves
- Experience with data engineering tasks.
- Experience with Snowflake SQL.
- Experience with FinOps or spend analysis, including cloud, software, or AI usage costs.
- Experience directly supporting an executive.
- Hands-on experience with ETL processes and tools such as Power Query, SQL-based transformations, or integration platforms.
- Experience building with Claude Code, Cursor, or similar AI coding tools.
Responsibilities
- Partner with stakeholders, including executives, to gather and clarify business questions and translate them into defined metrics and analytical solutions.
- Own complex or ambiguous data requests by asking clarifying questions, filling information gaps, and delivering finished solutions.
- Deliver polished, easy-to-use work with clear communication and follow-through.
- Analyze business processes to identify metrics, KPIs, and opportunities for data-driven improvement.
- Define data elements and maintain data dictionaries, glossaries, and metadata.
- Design logical and conceptual data models for reporting, analytics, and dashboards.
- Validate and test dashboard data for accuracy and consistency, and work with the Data Engineer to resolve discrepancies at their source.
- Build and maintain dashboards in Reef Analytics, using AI coding tools such as Claude Code or Cursor as development partners.
- Review and correct AI-generated code and queries, and handle tasks that require human judgment.
- Apply data visualization and dashboard design best practices.
- Ship work through Git and GitHub pull requests with code review.
- Create governed self-service reporting solutions, ad-hoc reports, and automated recurring reports.
- Conduct exploratory data analysis to identify insights, trends, patterns, and anomalies.
- Provide actionable recommendations based on data findings.
- Monitor dashboard usage and performance and iterate based on user feedback.
- Support data governance, including documentation of data lineage, security classifications, and best practices.
- Partner with the Data Engineer on integrations and pipeline enhancements that improve data availability.
- Train and support end-users on dashboard tools and data interpretation.
- Scope, break down, and track work in Jira using clear tickets, acceptance criteria, and priorities for people and AI agents.
- Manage stakeholder requests by setting expectations, sequencing work, and communicating progress through delivery.
- Turn ambiguous requests into well-defined specifications for AI agents and verify the results.
Benefits
- 401(k) plan with company match.
- Health plan with HSA match.
- Flexible paid time off.
- Daily company lunches.
- Cell phone service allowance.
- Discounts at company-owned resorts and golf courses.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
