Business Intelligence Developer
About the role
The Business Intelligence (BI) Developer on Stanley Martin Homes' Enterprise Data & Analytics Platform (EDAP) team plays a critical role in driving data-informed decision-making across the organization. We are seeking a highly analytical and detail-oriented Business Intelligence Developer to join our growing Data & Analytics practice.
Responsibilities
- Report Development
- Assist with the development and maintenance of BI dashboards and reports using enterprise BI tools (Power BI and/or Looker).
- Curate data experiences that are intuitive, interactive, and aligned with business decisions.
- Prepare summaries and presentations for leadership and cross-functional stakeholders.
- Participate in user-acceptance testing (UAT) for new reports, datasets, and metric definitions.
- Enable self-service analytics while maintaining governance and metric integrity.
- Governance & Collaboration
- Partner with stakeholders across business units to understand reporting needs and translate them into data solutions.
- Follow established governance, naming conventions, and documentation standards.
- Standardize KPIs and ensure consistent metric definitions across tools and teams.
- Simplify complex analytical findings into clear, actionable recommendations for both technical and non-technical audiences.
- Help ensure data quality by performing validation checks and working with analysts to resolve issues.
- Data Modeling & SQL Development
- Optimize data models and queries to improve report performance and refresh reliability.
- Identify friction in reporting workflows and propose scalable automation solutions.
- Develop and troubleshoot SQL queries, stored procedures, and views to support reporting and analytics needs.
- Optimize data structures for reporting performance and scalability.
- Support the creation of semantic models, dataset definitions, and standardized metrics under the direction of senior developers.
- AI-Enhanced Analytics & Innovation
- Leverage AI tools to accelerate segmentation analysis, insight generation, and reporting workflows.
- Explore predictive scoring, customer clustering, and behavioral modeling opportunities.
- Assist in evaluating emerging AI capabilities for marketing optimization.
- Support conversational BI and AI-assisted reporting experiments.
- Stay informed about emerging BI and AI tools and participate in continuous learning.
Requirements
- Education: Bachelor's degree in Data Science, Information Systems, Data Analytics, Business, or a related field; equivalent experience considered.
- Experience: 2+ years of experience in BI development or business analytics (internships and coursework welcome).
- Skills: Strong SQL skills and a solid understanding of relational databases, including aggregations and window functions. Basic experience with one or more BI tools (e.g., Power BI, Looker, Tableau). Familiarity with data visualization best practices and dashboard design concepts. Ability to translate analytical findings into business recommendations. Strong communication skills and comfort presenting to non-technical audiences. Strong analytical mindset with attention to detail and data accuracy. Willingness to work in a hybrid environment (3 days per week onsite).
Qualifications
- Familiarity with dimensional modeling fundamentals and data warehousing concepts.
- Exposure to AI-enabled analytics, predictive modeling, or customer scoring.
- Experience working with Git, Jira/Trello, or similar version control and project management tools.
- Basic scripting knowledge (Python/R) for automation or data prep.
- Industry background in residential real estate, construction, consumer behavior, or digital marketing.
Benefits
Access to competitively priced, high-quality health care options through Aetna, MetLife and EyeMed, along with employer-paid Short Term and Long Term disability, basic life and AD&D insurance (including employee-paid life, Legal Resources, and Aflac supplemental options)
Plan for the future by investing in a 401(K), with up to $5K employer match, invest even more with our Health Savings Account (HSA)
Put your family first with benefits, including 3 weeks of paid parental leave and a Flexible Spending Account (FSA) for dependent care
12 weeks of paid maternity leave through our Short-Term Disability Plan
Receive well-rounded wellness benefits, including free and low-cost mental health resources and support services through our Employee Assistance Program
Continue your education with tuition and certification reimbursement
Rest and relax with 15 days of vacation (increases with tenure) and 6 days of paid sick leave
Protect yourself from identity theft or travel mishaps with our no-cost coverage
Receive great discounts on buying a Stanley Martin home and discounts with our partners in mortgage and title services as well as cell phone service through Verizon
Get access to your paycheck early with an advanced pay option through Dayforce Wallet
Support local charities that are important to you through our Giving Back Program; with up to $250 match, 8 hours leave and more