Data Analyst
Denver, CO
YES Communities, founded in 2008, owns and operates manufactured housing communities with locations across the United States. YES takes a new approach to manufactured home communities and works to build and maintain an environment in each community that reflects their positive YES attitude.
We’re seeking a highly motivated and detail-oriented Data Analyst to join our Financial Planning & Analysis (FP&A) team. This role is critical to advancing our Business Intelligence initiatives by transforming complex data into actionable insights that drive strategic decisions across the organization.
As a Data Analyst, you will support data transformation and visualization efforts by developing ETL processes, uncovering insights, and building dashboards that highlight key business metrics. Working closely with our team, you will provide subject-matter expertise across our operating platform, visualization tools, and data warehouse framework. The ideal candidate is skilled in data analytics and dashboard development, communicates complex data concepts clearly, and brings a thoughtful, structured approach to problem-solving.
What You’ll Do
- Leverage SQL to aggregate and process large data sets across multiple data sources, including custom views and stored procedures.
- Design and implement Incorta dashboards to visualize key business metrics and company-wide reporting.
- Build, validate, and maintain ETL pipelines across platforms – identify appropriate data sources, write scripts, develop visualizations, and iterate as needed.
- Translate complex technical concepts to non-technical business users in a clear, concise manner.
- Partner with the FP&A team and cross-functional stakeholders to deliver insights that drive strategic planning, operational efficiency, and financial performance.
- Maintain and improve documentation for data sources, structures, and processes.
- Support ad hoc analyses and special projects as assigned.
Qualifications
- Bachelor’s degree in Data Analytics, Computer Science, Business Analytics, or related field (required).
- Advanced proficiency in SQL Server, including scripting, aggregation functions, and query optimization techniques.
- Experience or familiarity with database modeling and database management best practices.
- Proficiency in Python and/or PySpark scripting.
- Experience with BI Analytics tools such as Tableau, Incorta, or other BI platforms.
- Knowledge of Microsoft Power Platform or PostgreSQL is a plus.
- Strong written and verbal communication skills, with exceptional attention to detail.
- Proven ability to independently learn and apply new tools, technologies, and processes.
- Self-motivated and adaptable, with the ability to manage multiple priorities in a dynamic, fast-paced environment.