Avatar for Epcon Communities
Active adult community builder with luxury neighborhoods

Business Intelligence Analyst

  • |4 years of exp
  • |Full Time
Posted: 1 week ago
Job Location
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
SQL
MySQL
Automation
VBA
Tableau
Microsoft Excel
Lasso
Amazon Athena
LOD expressions
Google Analytics 4
Looker Studio
Advanced Functions
Published Data Sources
MarkSystems

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.

About the company

Epcon Communities company logo
Active adult community builder with luxury neighborhoods51-200 Employees
Learn more about Epcon Communities image