Senior Business Intelligence Developer

Who is Stanley Martin Homes?

At Stanley Martin Homes, we believe your work should have a purpose. With us, it truly does.

Our success starts with our people, and we are proud to foster a culture where every team member is valued and supported. At Stanley Martin Homes, you will work alongside passionate, knowledgeable professionals who are committed to doing the right thing, delivering exceptional homebuyer experiences, and putting home buyers first.

Stanley Martin Homes is one of the largest 25 homebuilders in the United States and it has been consistently one of the fastest growing. We are proud of the people-first culture that makes it possible.

If you are ready to build a meaningful career and help families find the place they will call home, we would love to connect with you. Join our team and build a career that you will be proud of.

Explore Opportunities Today

The Senior Business Intelligence (BI) Developer owns the BI semantic layer and platform at Stanley Martin Homes—designing governed datasets and explores, implementing a shared metrics layer, and optimizing BI performance, security, and content lifecycle. This role partners closely with Data Engineering (DE) via clear data contracts/SLAs and with BI Analysts on requirements, UX, and adoption.

• Design and maintain semantic models (e.g., LookML or equivalent): dimensions, measures, aggregate tables/PDT strategies, governed explores, and reusable subject ‑ area data marts for BI.
• Implement and steward the metrics layer (definitions, tests, versioning); enforce naming conventions and change ‑ management processes.
• Platform administration and governance: content lifecycle and certifications, role-/row-level security (RLS/OLS), usage monitoring, performance tuning, and query cost control.
• Define data contracts (schemas, freshness, quality rules) with Data Engineering; log/track issues via agreed SLAs and incident workflows.
• Write advanced SQL for BI models and optimize queries against curated warehouse layers; troubleshoot performance at warehouse and BI-tool levels.
• Lead UAT for BI data sets and metrics; design business ‑ facing validation checks with Analysts; remediate defects with DE.
• Establish modeling standards and best practices; maintain architecture diagrams, runbooks, and developer playbooks.
• Mentor BI Analysts/Developers on semantic modeling, query optimization, and dashboard performance.
• Produce reference dashboards and reusable components (themes/tiles) that demonstrate best practice; partner with Analysts for broad dashboard build‑out and UX.

• Familiarity with modern ELT stacks and warehouse tooling (e.g., Fivetran, Coalesce/dbt, Snowflake/Big Query).
• Awareness of open table formats (e.g., Iceberg/Delta) and query engines; understanding of implications for BI performance and governance.
• Scripting experience (Python/R) for BI ‑ adjacent automation and testing.
• Industry exposure to residential real estate/construction or Marketing analytics.
• Familiarity with Looker’s Agentic AI workflows and Conversational API capabilities

• Education:
  
  Bachelor’s degree in Data Science, Information Systems, Data Analytics or a related field.
• Experience:
  
  5+ years in Business Intelligence or Data Analytics with 3+ years focused on BI semantic modeling (e.g., LookML/Power BI semantic model/Tabular) and governed data sets.
• Expert SQL with hands ‑ on performance diagnostics (execution plans, caching/aggregation strategies, warehouse compute scaling).
• Proven experience administering BI platforms (e.g., Looker, Power BI): security (RLS/OLS), workspace/content governance, usage monitoring.
• Strong understanding of dimensional modeling and analytics data ‑ mart design; ability to read warehouse schemas and partner effectively with Data Engineering.
• Experience with Git ‑ based workflows for BI model versioning, code review, and promotion across environments.
• Excellent communication skills; able to translate business needs into durable models and clear data contracts.
• Comfortable working in an Agile framework (e.g., Jira/Trello); strong documentation habits.
• Hybrid role; 3 days per week onsite.

• Access…