Data Modeling Lead
Cleveland, OH, US • Posted 4 hours ago • Updated 4 hours ago

Smartwork IT Services
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- SQL Server
- data modeling
- Databricks
- Informatica
- ER Studio
- Kimball
- dimensional modeling
- OracleExadata
- Tibco Data Virtualization
- Data Model Design & Documentation
Summary
Title: Data Modeling Lead
Remote: Yes
When the Consultant/Resource travels to the client location, the expenses will be paid
DESCRIBE A DAY IN THE LIFE OF THIS ROLE:
The Data Modeler will design, develop, and maintain data models that support analytics and business intelligence initiatives. This role leverages the Kimball methodology for dimensional modeling, implements a star schema architecture, and utilizes ER Studio for data modeling and documentation. The Data Modeler collaborates with business stakeholders, data engineers, and analytics teams to ensure data structures are optimized for reporting, data science, integration, and scalability. Solves unique and complex Data Modeling problems impacting a domain, with a keen understanding of touchpoints with adjacent areas and relationships to business process.
DETAILED REQUIREMENTS:
Dimensional Modeling (Kimball Methodology):
Apply Kimball methodology to translate business requirements into dimensional models, focusing on user-friendly, business-driven views of data in ER Studio.
Design and maintain star schemas, ensuring optimal query performance and ease of use for analytics and Data Science.
Identify and define fact tables, dimension tables, surrogate keys, and conformed dimensions for cross-functional analysis.
Data Model Design & Documentation:
Develop conceptual, logical, and physical data models using ER Studio.
Reverse engineer existing databases and create entity-relationship diagrams (ERDs) to document data structures and relationships.
Maintain metadata, data dictionaries, and business process flow documents for all models
Translate business requirements and data constraints into robust dimensional models that supporting actionable insights and business friendly scalable analytics
Collaboration & Stakeholder Engagement:
Work closely with business analysts, data owners, data producers, data engineers, data governance analysts and subject matter experts to fully understand objectives, decision making processes, gathering requirements and validating models.
Engage with technical experts to assess the realities of source system data via high-level profiling and data validation for feasibility and integrity
Participate in sprint planning, backlog reviews, and hand-offs with data engineering and governance teams.
Collaborate with other data modelers to create consistency in conformed dimensions across all analytics data.
Data Quality & Governance:
Ensure models adhere to data governance, security, and compliance standards.
Validate data flows, enforce best practices, and review new requirements and changes to data pipelines.
Support data quality initiatives and audit table requirements.
Tool & Platform Expertise:
Use ER Studio for model creation, documentation, and version control.
Reimagine current state models on platforms such as Oracle, SQL Server, Informatica, Spotfire and Tibco TDV as needed.
Knowledge of Databricks Medalion Architecture a benefit
REQUIRED SKILLS:
- Bachelor's degree in Computer Science, Information Systems, or related field.
- 7+ years of experience in data modeling for analytics or data warehousing with strong expertise in Kimball methodology, dimensional modeling, and star schema design.
- Proficiency with ER Studio or similar data modeling tools.
- 3+ years of Data Engineering experience with relational databases (Oracle Exadata, SQL Server, Informatica, Tibco Data Virtualization, Databricks or similar tools).
- Solid understanding of data governance, metadata management, and data quality principles.
- Excellent communication and collaboration skills.
NICE TO HAVE SKILLS:
- Experience with agile methodologies and sprint-based project delivery.
- Familiarity with business intelligence platforms and reporting tools.
- Ability to translate complex business requirements into scalable data models.
- Knowledge of data integration, ETL/ELT pipelines, and master data management.
- Dice Id: 91131384
- Position Id: 2026-4060
- Posted 4 hours ago
Company Info
About Smartwork IT Services
At SWITS Digital Private Limited, we are driven by innovation, integrity, and a commitment to empowering businesses through technology. As a fast-growing company, we specialize in designing and developing cutting-edge products and services tailored to meet the unique needs of our clients.
Who We Are
Innovators at Heart: We thrive on turning ideas into impactful solutions that drive tangible results.
Tech Visionaries: Our expertise spans web application development, AI-driven solutions, and digital transformation.
Client-Focused: Building long-lasting partnerships by delivering personalized, high-quality services.
What We Do
Develop innovative products like SWITS ATS, SWITS HRMS, SWITS JOBS, and SWITS VMS, revolutionizing industries such as recruitment, human resources, and vendor management.
Provide scalable, efficient, and secure web applications that simplify business processes and foster growth.
Our Vision
To redefine industry standards by crafting digital solutions that not only meet today’s challenges but also anticipate tomorrow’s opportunities.
Why Choose Us
Agile Development: Fast and adaptable processes for delivering exceptional results.
Customer-Centric Approach: We prioritize understanding and meeting client objectives.
End-to-End Support: From ideation to execution and beyond, we’re with you at every step.
Join us on our journey to shape a smarter, more connected future. Let us bring your vision to life!
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs