Data Warehouse Architect

Octagon Talent Solutions is hiring a Data Warehouse Architect / Data Modeler in the Fort Lauderdale area to help shape our client company’s next-generation analytics foundation. In this hands-on role, you’ll architect a hybrid Databricks + Microsoft Fabric ecosystem, designing the data models that power decision-making, guiding lakehouse/warehouse structure, and partnering with data engineers to keep the platform scalable, trusted, and ready for an exciting future in the energy industry!

Responsibilities:

• Own end-to-end data modeling for our client company’s modern data platform (conceptual, logical, and physical models)
• Design scalable dimensional models (star/snowflake), canonical entities, and conformed dimensions to enable consistent reporting across domains
• Partner with data engineers to implement models in a lakehouse context (Delta/Medallion patterns) across Databricks and Fabric
• Define data contracts and modeling standards that improve consistency, quality, and downstream usability
• Collaborate with stakeholders to translate requirements into clear data definitions, metrics, and model structures
• Support pipeline design by providing modeling guidance for ingestion, transformation, and curated layers
• Create and maintain documentation (data dictionaries, lineage, model diagrams) and ensure models remain understandable and maintainable
• Contribute to performance and cost optimization (partitioning strategies, model design choices, query patterns)
• Support modernization efforts as the company introduces Fabric components alongside existing Databricks investments
• Collaborate on initiatives that enable agentic/AI use cases through clean, well-described data structures

Required Qualifications

• 7+ years of experience in data modeling / data warehousing / analytics engineering (or equivalent)
• Proven expertise in dimensional modeling and data warehouse best practices
• Hands-on experience with Databricks and Delta Lake concepts
• Experience with Microsoft Fabric (or strong readiness to operate in Fabric), including lakehouse/warehouse concepts
• Experience building/maintaining models that support enterprise reporting and analytics
• Strong SQL skills and ability to reason about query performance and warehouse design
• Experience with orchestration and integration patterns using Azure Data Factory (ADF)
• Ability to communicate clearly with technical and non-technical stakeholders (definitions, tradeoffs, and standards)

Preferred Qualifications

• Experience in Azure-native data stacks (ADLS, ADF, Synapse, Purview, etc.)
• Experience designing governance-oriented modeling standards (quality checks, naming conventions, metric definitions)
• Experience with data observability and/or data quality tooling
• Experience enabling self-service analytics and semantic layer practices
• Familiarity with AI/ML data readiness and feature/curation patterns

Work Authorization

• Must be a U.S. citizen or U.S. permanent resident (Green Card holder). No H-1B sponsorship is possible for this role.