Data Modeler - Manager - Consulting - Miami​/South Florida

5 days ago Be among the first 25 applicants

Location:

Anywhere in Country

We are looking for a dynamic and experienced Manager of Data Modeling to lead our team in designing and implementing complex cloud analytics solutions with a strong focus on Databricks. The ideal candidate will possess deep technical expertise in data architecture, cloud technologies, and analytics, along with exceptional leadership and client management skills.

• Understand and analyze business requirements to translate them into technical requirements.
• Design, build, and operate scalable data architecture and modeling solutions.
• Stay up to date with the latest trends and emerging technologies to maintain a competitive edge.
• Lead the design and development of conceptual, logical, and physical data models for the Enterprise Data Warehouse (EDW) using the Kimball dimensional methodology.
• Design and implement star schemas (Fact and Dimension tables) to support enterprise analytical, Business Intelligence (BI), and reporting requirements with high performance and query efficiency.
• Define and model Slowly Changing Dimensions (SCD), emphasizing SCD Type 2, to accurately capture and preserve the full historical context of dimension attributes.
• Collate appropriate grain for fact tables and identify measurable facts (metrics) and their relationships to the surrounding dimension tables.
• Design highly denormalized dimension structures to reduce joins and simplify querying for end‑users and analytical tools.
• Collaborate with stakeholders and cross‑functional teams to understand data requirements and design appropriate data models that align with business needs.
• Create and maintain data dictionaries and metadata repositories to ensure consistency and integrity of data models.
• Identify and resolve data model performance issues to optimize database performance and enhance overall system functionality.
• Manage and provide guidance to a small team of 1‑3 resources.
• Document and communicate data model designs and standards to ensure understanding and compliance across the organization.
• Create detailed source‑to‑target mapping and data transformation specifications for ETL/ELT developers, including all SCD Type 2 logic and surrogate key generation rules.
• Stay current with industry best practices and trends in data modelling and incorporate new techniques and methodologies into our data modelling processes.
• Guide the team on implementing data modelling techniques such as Kimball’s dimensional modeling.
• Develop conceptual, logical, and physical data models to support data analysis and business intelligence.
• Utilize industry‑standard data modelling tools (e.g., Erwin, Power Designer, ER/Studio) to create and maintain conceptual, logical, and physical models, and to manage version control.
• Possess cloud knowledge and certification – Azure DP‑203 certification is preferred.

• A Bachelor's degree in STEM.
• 10+ years of hands‑on experience in data modelling.
• Strong understanding of SQL and data modelling concepts such as Kimball dimensional modelling.
• Experience with major enterprise relational database platforms or cloud data warehouses (e.g., Oracle, SQL Server, Azure Synapse).
• Solid grasp of data warehousing principles, ETL/ELT architecture, data quality management, and metadata management.
• Mastery of SCD Type 2 implementation for preserving historical data, with familiarity of other SCD types.
• Ability to analyze complex business processes and translate abstract business requirements into precise, efficient technical data models.
• Proficiency in data modelling tools such as Erwin, Visio, or Power Designer.
• Experience designing and implementing database structures and performing performance tuning and query optimization.
• Strong analytical and problem‑solving skills.
• Excellent communication and documentation skills.
• Knowledge in Hospitality Domain is mandatory.

• Strong business acumen with the ability to manage complex client relationships.
• Proven experience in managing and leading teams within a dynamic environment.
• Excellent communication and…