Data Warehouse Architect in Fort Lauderdale

Energy Jobline
Fort Lauderdale, United States of America
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Fort Lauderdale, United States of America

Tech stack

Query Performance
Artificial Intelligence
Business Analytics Applications
Azure
Data Dictionary
Data Infrastructure
Data Structures
Data Warehousing
Database Queries
Dimensional Modeling
DataOps
Azure
Snowflake
Microsoft Fabric
Data Lake
Databricks

Job description

  • 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

Requirements

  • 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)

Qualifications

  • Experience in Azure- 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. or U.S. permanent (Green Card holder). No H-1B sponsorship is possible for this role.

Apply for this position