SWITS DIGITAL Private Limited · 1 day ago
Data Modeling Lead
United States
Contract
Remote
Senior Level
$70/hr - $75/hr
7+ years expSWITS DIGITAL Private Limited is seeking a Data Modeling Lead who will design, develop, and maintain data models that support analytics and business intelligence initiatives. The role involves leveraging the Kimball methodology for dimensional modeling and collaborating with various stakeholders to ensure optimized data structures for reporting and scalability.
Information Technology & Services
Responsibilities
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
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
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
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
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
Qualification
Required
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
Preferred
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
Company
SWITS DIGITAL Private Limited
At SWITS Digital Private Limited, we are driven by innovation, integrity, and a commitment to empowering businesses through technology.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase