Data Modeler (LucidChart & Silver & Gold layer modelling Dimensional modeling)
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)
Job Description Visa Requirement: This position is open only to candidates authorized to work in the United States under the following visa categories: H4-EAD, Green Card Holder, GC-EAD, U.S. Citizen, L2s, L2-EAD. No other visa types are eligible for this role.
Job Description: 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.
Key Responsibilities:
- Experience with database modeling tools such as LucidChart”
- Experience with standard data models such as S-95
- 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.
Required Skills And Qualifications:
- 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.
Good To Have:
- 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
Your Name Your Phone Number
Your Email Address * Job id
What is your current U.S. visa or immigration status? *
SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa
Where are you currently located at? W2 or C2C
SelectW2C2C
How many years of total experience do you have? How many years of relevant experience do you have?
Do you require H1B sponsorship? * YesNo
Do you require sponsorship? *
NoYes — H-1B transferYes — Green Card sponsorshipYes — Both H-1B transfer and Green Card sponsorship
Upload Resume *
Δ
Facebook X LinkedIn WhatsApp