Skip to main content

Data Warehouse Architect

Posted yesterday

octagon talentFort Lauderdale (FL)

SENIORITY

Lead

Apply (opens in a new tab)

About the role

Job Description: Job Description 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 FabricDefine 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 conceptsExperience with Microsoft Fabric (or strong readiness to operate in Fabric), including lakehouse/warehouse conceptsExperience 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.

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.

More like this