Job Summary
The Business Intelligence Developer II is responsible for the design, development, optimization, and governance of business intelligence and reporting initiatives across the organization. This role architects scalable reporting and analytics environments, develops data models and reporting frameworks, and partners with business and technology stakeholders to deliver actionable insights that improve decision-making and operational performance.
Essential Job Functions
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.
Monitor and optimize BI environments, dashboards, queries, semantic models, data pipelines, and reporting systems to improve scalability, reliability, performance, automation, and end-user experience.
Ensure reporting solutions comply with data governance standards, security protocols, privacy requirements, internal controls, and data access policies related to reporting accuracy and enterprise data usage.
Provide technical guidance, mentoring, and support to business intelligence developers, analysts, and reporting users regarding reporting tools, architecture standards, SQL development, data modeling, semantic layers, and BI best practices.
Evaluate and recommend improvements to BI architecture, data pipelines, reporting frameworks, governance processes, and modern data platform capabilities to support long-term enterprise data strategy.
Conduct all business in a professional and ethical manner to serve customers and increase the goodwill and profit of the company.
Maintain regular and reliable attendance on-site at corporate office.
Additional Responsibilities
Support production issue resolution, system upgrades, testing initiatives, and implementation activities related to reporting and analytics platforms
Additional duties as assigned
Minimum Required Qualifications
1. Bachelor s degree in Information Systems, Computer Science, Data Analytics, Business Administration, Engineering, or a related field required
2. Minimum of 5 years of experience designing and supporting enterprise business intelligence, reporting, data warehousing, or analytics solutions required
3. Experience working with enterprise reporting platforms, visualization tools, relational databases, and cloud-based analytics environments required
4. Knowledge of business intelligence architecture, data warehousing concepts, data modeling methodologies, reporting frameworks, and enterprise analytics platforms
5. Ability to translate complex business requirements into scalable technical solutions, manage multiple priorities, communicate effectively with technical and non-technical stakeholders, and maintain accuracy
6. Ability to apply common sense understanding to carry out instructions furnished in written and oral form or via DRH applications
7. Ability to sit for majority of 8-hour workday; use hands and fingers to handle or feel; reach with hands and arms; talk and hear. Specific vision abilities required by this job include close vision and peripheral vision
8. The noise level is generally moderate
Other Qualifications
1. Experience developing data models, ETL/ELT processes, dashboards, semantic models, and enterprise reporting solutions in a large, multi-location organization preferred.
2. Experience supporting operational and financial reporting within the homebuilding, real estate, construction, mortgage, or related industry preferred.
3. 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 preferred.
4. Familiarity with data governance, metadata management, cataloging, lineage, and semantic understanding tools such as Collate or similar platforms preferred.
5. Experience designing scalable data pipelines, governed semantic layers, and reusable data assets that support analytics, reporting, and self-service business intelligence preferred.
6. 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 preferred.
7. Understanding of modern data architecture concepts, including cloud data warehouses, ELT patterns, orchestration, data quality, source-to-target mapping, and governed enterprise reporting preferred.
