Data Modeler; LucidChart & Silver & Gold layer modelling Dimensional modeling

Job Details

Job Category: Data

Job Type: Onsite

Job Location: Atlanta Georgia

Compensation: Depends on Experience

W2: W2-Contract Only;
Kindly note that applications on a C2C basis will not be considered for this role.

Eligible Visa: GC GC-EAD H4 EAD L2S U.S. Citizen (USC)

We are seeking an experienced Data Modeler to design and implement high-quality analytical data models that support enterprise reporting, analytics, and data science use cases. The ideal candidate will have hands-on expertise in Silver and Gold layer modeling, dimensional data warehouse design, and Python automation to streamline data modeling, validation, and documentation processes.

• Design and develop Silver and Gold layer data models following medallion architecture principles.
• Create and maintain dimensional models (Star and Snowflake schemas) for enterprise data warehouses.
• Define fact and dimension tables aligned with business KPIs and analytical requirements.
• Apply best practices for slowly changing dimensions (SCDs) and historical data tracking.
• Lead end-to-end data warehouse design and modeling initiatives.
• Translate business requirements into scalable, performant data models.
• Optimize models for query performance, usability, and extensibility.
• Partner with data engineers to ensure accurate implementation of models.
• Develop Python-based automation for data model validation, reconciliation and documentation.
• Automate metadata extraction, schema comparison, and impact analysis.
• Support automated testing of data models and transformations.
• Build reusable Python utilities to improve modeling efficiency.
• Collaborate with data engineers, analysts and architects.
• Participate in design reviews and ensure alignment with enterprise data standards.
• Support data governance initiatives including data definitions, lineage, and documentation.
• Ensure consistency in naming conventions, data types, and modeling standards.

• 8–12 years of experience in data modeling and data warehousing.
• Strong hands-on experience with Silver & Gold layer modeling, dimensional modeling (Star / Snowflake schemas) and Data warehouse design;
  Python automation. Deep understanding of fact/dimension design, grain definition, and KPI modeling.
• Experience with large-scale analytical datasets.

• Microsoft Certified:
  Azure Data Engineer Associate or Azure Enterprise Data Analyst Associate.
• Experience with cloud data platforms (Azure). Exposure to CI/CD and version control for data models.
• Knowledge of metadata management and data governance tools.
• Wast management or oil and gas domain knowledge

Apply Online