Business Intelligence Developer

Position Overview

The Business Intelligence Developer is responsible for the design, development, optimization, and governance of business intelligence and reporting initiatives across the organization.

Responsibilities

• Design, develop, and maintain scalable business intelligence architectures, semantic models, dashboards, scorecards, and enterprise reporting solutions that support enterprise operations, executive decision-making, and strategic initiatives.
• Architect, develop, and optimize data models, data marts, reporting structures, and governed semantic layers to improve reporting performance, data consistency, self-service analytics, and analytical capabilities across multiple business functions.
• Develop and support enterprise BI solutions using Microsoft reporting and analytics platforms, including Power BI, Power BI Report Server, SQL Server, SSAS Tabular, SQL Server Reporting Services, and related Microsoft data technologies.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, views, and reporting datasets to support analytics, enterprise reporting, performance tuning, and scalable data delivery.
• Design, implement, and maintain ETL / ELT processes, data integration workflows, automated reporting solutions, and reusable data assets utilizing enterprise data warehouse, cloud data platform, and modern data stack technologies.
• Support the adoption and integration of modern data stack platforms and tools, including Snowflake, dbt, Fivetran, data orchestration platforms, Collate, OpenTofu / Terraform, metadata management, data governance, and related cloud-based technologies.
• Collaborate with business leaders, analysts, developers, data engineering teams, and architecture teams to translate operational, financial, and reporting requirements into technical BI solutions, reporting frameworks, and governed data products.
• Develop and maintain reporting standards, metadata documentation, business definitions, data lineage, data quality expectations, and governance procedures to ensure data integrity, consistency, and semantic understanding across reporting platforms.
• Analyze large and complex data sets to identify trends, operational opportunities, performance metrics, and actionable business insights supporting executive, departmental, and cross-functional decision-making.
• Maintain regular and reliable attendance on-site at corporate office.

Required Qualifications

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Business Administration, Engineering, or a related field.
• Minimum of 5 years of experience designing and supporting enterprise business intelligence, reporting, data warehousing, or analytics solutions.
• Experience working with enterprise reporting platforms, visualization tools, relational databases, and cloud-based analytics environments.
• Knowledge of business intelligence architecture, data warehousing concepts, data modeling methodologies, reporting frameworks, and enterprise analytics platforms.
• Ability to translate complex business requirements into scalable technical solutions, manage multiple priorities, communicate effectively with technical and non-technical stakeholders, and maintain accuracy.
• Ability to apply common sense understanding to carry out instructions furnished in written and oral form or via DRH applications.

Preferred Experience

• Experience developing data models, ETL / ELT processes, dashboards, semantic models, and enterprise reporting solutions in a large, multi-location organization.
• Experience supporting operational and financial reporting within the homebuilding, real estate, construction, mortgage, or related industry.
• Experience with modern cloud data platforms and data engineering tools such as Snowflake, dbt, Fivetran, data orchestration platforms, and infrastructure-as-code tools such as OpenTofu or Terraform.
• Familiarity with data governance, metadata management, cataloging, lineage, and semantic understanding tools such as Collate or similar platforms.
• Experience designing scalable data pipelines, governed semantic layers, and reusable data assets that support analytics, reporting, and self-service business intelligence.
• Strong experience with Microsoft BI and database technologies, including Power BI, Power BI Report Server, SQL Server, SSAS Tabular, SQL Server Reporting Services, and advanced SQL development, including stored procedures, performance tuning, data modeling, and complex query development.
• Understanding of modern data architecture concepts, including cloud data warehouses, ELT patterns, orchestration, data quality, source-to-target mapping, and governed enterprise reporting.