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
SeniorJob 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.