In office
Not Available
About the job
Who is Epcon? A trusted home builder for over 40 years.
Experience a more Livable Lifestyle. At Epcon Communities, our mission is to build homes, neighborhoods, and lifestyles that provide one remarkable experience. We have delivered on that promise since 1986 by integrating smart, innovative designs with the most desirable of modern amenities. Today, more than 30,000 families and individuals call an Epcon community “home,” which makes Epcon one of the top lifestyle-rich home developers in the country year after year.
Your Next Opportunity: Business Intelligence Analyst
The Business Intelligence Analyst serves as the primary data and analytics lead for the Marketing and Sales departments, responsible for company-wide reporting, data governance, KPI strategy, and business intelligence development.
This role owns the integrity, structure, and analysis of marketing and sales data across 25+ communities spanning multiple markets, providing executive-level reporting used by all levels of Leadership. The BI Analyst develops and maintains the official source of truth for traffic, lead, conversion, sales, and ROI reporting while proactively identifying trends, risks, and opportunities to drive business performance.
This position operates with a high degree of autonomy and technical expertise, managing CRM logic, source attribution frameworks, reporting automation, and cross-functional data standardization initiatives.
ESSENTIAL TASKS, DUTIES & RESPONSIBILITIES
Business Intelligence & Reporting
- Develop, maintain, and optimize executive dashboards and reporting infrastructure in Tableau and Looker Studio
- Design and distribute weekly, monthly, and quarterly performance reports covering traffic, lead generation, conversion rates, sales, trends, and ROI
- Serve as the official source of truth for Marketing and Sales performance metrics
- Define, document, and govern key marketing and sales KPIs
- Build and maintain production-level SQL queries, views, and data structures using MySQL and Amazon Athena
- Proactively identify performance trends and provide data-driven insights to leadership
Data Governance & Systems Ownership
- Own and manage CRM database logic (Lasso) and marketing data definitions
- Maintain source attribution logic and ensure consistency across reporting systems
- Resolve discrepancies between CRM, ERP (MarkSystems), GA4, and financial systems
- Standardize reporting structures across Marketing, Sales, Finance, and IT
- Validate and reconcile data used for executive and operational decision-making
Advanced Analytics & Forecasting
- Analyze lead funnels, conversion behavior, and sales performance across markets
- Forecast lead volume and performance trends to support staffing and operational planning
- Produce ROI analysis comparing marketing spend to performance outcomes
- Conduct segmentation and market-level performance analysis
- Support franchisee analytics initiatives as needed
Automation & Process Optimization
- Design and implement automation solutions using SQL, Tableau, VBA, or Python
- Replace manual reporting processes with scalable, automated reporting systems
- Develop scheduled data processes and reporting efficiencies
- Continuously improve data workflows to support future company growth
Cross-Functional Collaboration
- Partner with Marketing, Sales, Finance, IT, and executive leadership to align reporting standards
- Present insights and findings to leadership as needed
- Support strategic planning initiatives with data-driven analysis
- Provide technical guidance to team members and interns when applicable
JOB REQUIREMENTS
Education & Experience:
- Bachelor’s degree in Marketing, Business, Data Analytics, or related field
- 4+ years of progressive experience in marketing analytics, business intelligence, or data analysis
Technical Skills
- Advanced proficiency in:
- SQL (MySQL, Amazon Athena)
- Tableau (including LOD expressions and published data sources)
- Looker Studio
- Microsoft Excel (advanced functions, automation)
- CRM systems (Lasso or comparable platform)
- ERP data environments (MarkSystems or comparable system)
- Google Analytics 4
- VBA and basic Python scripting for automation
Core Competencies
- Company-wide analytical perspective
- Data governance and integrity management
- Executive communication and reporting
- Cross-functional collaboration
- Process automation and systems optimization
- Self-direction and high autonomy
- Strategic problem-solving
Epcon Communities offers a generous benefit package including:
- Health benefits including medical, dental, & vision coverage
- Company-provided life and accidental death and dismemberment insurance
- Company-provided short- and long-term disability
- 401(k) plan including company match
- Paid time off including vacation, sick and holidays
- Convenient Dublin location with free parking on-site.
Epcon Communities Services, LLC is an Equal Opportunity Employer.
