Enterprise Data and Integration Director

Green Brick Partners•Plano, TX

4d•Hybrid

About The Position

The Enterprise Data and Integration Director will own Microsoft Fabric as the organization’s core data platform and integration layer, modernizing legacy reporting and data movement patterns in a lean team environment. The Director will serve as both architect and lead engineer, initially supported by one Data Analyst. Success requires strong prioritization, hands-on execution of critical work, and disciplined use of vendor partners. This position is accountable for building a scalable, governed, and high-performing data environment while moving the organization toward Power BI-led analytics and modern integration practices.

Requirements

Bachelor’s degree in computer science, Information Systems, or equivalent.
8+ years of experience in data engineering, BI, and enterprise integration.
Expert-level SQL skills, including stored procedure refactoring and query optimization.
Strong experience with SSIS and SSRS, including modernization and migration efforts.
Strong Azure experience across infrastructure, security, identity, and networking fundamentals.
Proven success in a lean, hands-on leadership role.
Ability to work onsite at least 3 to 4 days per week.

Nice To Haves

Deep experience with Microsoft Fabric, including Warehouse or Lakehouse, Data Factory, and Dataflows Gen2.
Strong Power BI expertise, including data modeling, DAX, performance tuning, and governance.
Experience building governed self-service analytics in a resource-constrained environment.
Experience establishing CI/CD for data platforms using Azure DevOps or GitHub.
Experience integrating third-party platforms and resolving duplicated data sources.
Familiarity with Builder Metrix or similar platforms.

Responsibilities

Modernize integrations into Fabric: transition SSIS packages and direct SQL integrations to Fabric pipelines, dataflows, and API-based patterns.
Refactor stored procedures supporting approximately 180 reports so legacy SQL operates efficiently against Fabric Warehouse.
Transition SSRS workloads to SQL Server in Azure while rationalizing and reducing report sprawl.
Modernize reporting by prioritizing SSRS-to-Power BI migrations and establishing governed semantic models and reusable datasets.
Deliver initial executive dashboards and operational reporting.
Establish Fabric governance, including environment structure, monitoring, standards, and UAT-to-production promotion workflows.
Integrate Builder Metrix into Fabric, deduplicating and normalizing overlapping datasets.
Create a sustainable delivery model using a small internal team and targeted vendor support, including backlog management, QA standards, and release discipline.
Serve as the primary technical owner of the Fabric data platform.
Design and implement complex data solutions, including SQL refactoring, Fabric Warehouse modeling, and pipeline orchestration.
Balance strategic planning with hands-on execution in a lean team environment.
Lead a small, high-impact team, initially consisting of one Data Analyst.
Define clear responsibilities across architecture, engineering, reporting support, data validation, and lightweight development.
Prioritize work to maximize impact with limited resources.
Build a roadmap that sequences modernization efforts without exceeding capacity.
Lead the transition from SSRS-heavy reporting to a Power BI-centered analytics environment.
Build curated datasets and semantic models that support governed self-service analytics.
Standardize reporting definitions to reduce duplication and improve consistency.
Deliver executive dashboards and operational insights.
Own integrations across enterprise systems into Fabric.
Standardize ingestion patterns to improve reliability, observability, and scalability.
Design API-first and pipeline-driven architectures where appropriate.
Manage third-party partners as a force multiplier rather than dependency.
Define clear scopes, deliverables, and quality standards for vendor partners.
Review technical outputs and ensure alignment with internal standards.
Maintain accountability for vendor-delivered work.
Implement environment structure, access controls, and naming standards.
Establish CI/CD and UAT-to-production promotion workflows.
Monitor platform performance, cost, and reliability.
Make strategic decisions in regard to setup, implementation, configuration, administration, and overall health of the entire IT infrastructure.
Have buying power in regard to hardware, software, and services to maintain the infrastructure.