JPS Tech Solutions · 15 hours ago
Data Modeler (LucidChart & Silver & Gold layer modelling Dimensional modeling)
Atlanta, GA
Full-time
Onsite
Senior Level, Lead/Staff
8+ years expJPS Tech Solutions is 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.
Information TechnologyIT InfrastructureSoftware Engineering
No H1B
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
Qualification
Required
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
Preferred
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
Waste management or oil and gas domain knowledge
Company
JPS Tech Solutions
JPS Tech Solutions offers software engineering, cloud, mobile development, and IT infrastructure solutions.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase