What are the responsibilities and job description for the Sr. Data Modeler position at Revel IT?
We have a direct client in Columbus, Ohio who is seeking an experienced and highly skilled Senior Data Modeler to join their data engineering team.
REMOTE!
Must be able to work on our direct payroll.
This role will be responsible for designing and implementing data models to drive analytics, reporting, and data-driven decision-making. The ideal candidate will have hands-on experience with industry-standard data modeling methodologies (Kimball, Inmon, Data Vault 2.0) and have applied them in modern data architectures, including Medallion Architecture on Databricks for Delta Live Tables (DLT). You will work closely with business stakeholders to gather requirements and create effective data flows that support enterprise-level data solutions.
Key Responsibilities
- Data Modeling : Develop, implement, and maintain high-quality data models using methodologies such as Kimball (dimensional), Inmon (3NF), and Data Vault 2.0, tailoring each approach to fit specific business use cases.
- Medallion Architecture : Design and optimize data models following the Medallion Architecture (Bronze, Silver, Gold layers) on Databricks, particularly for Delta Live Tables (DLT) to facilitate data ingestion, transformation, and consumption.
- Data Flow : Develop good understanding of existing data flows and pipelines.
- Stakeholder Engagement : Partner with business stakeholders to understand their data needs and translate business requirements into robust data models and workflows.
- Optimization and Performance : Continuously optimize models and workflows for performance, scalability, and reliability. Troubleshoot and resolve data and model-related issues to ensure efficient data processing.
- Documentation and Best Practices : Develop and maintain detailed documentation for data models, data flows, and data governance processes, promoting best practices across the data modeling function.
- Collaboration : Collaborate with data engineers, data analysts, and data scientists to integrate models seamlessly into the broader data platform, ensuring alignment with organizational data standards.
Required Qualifications
Technical Expertise :
Preferred Qualifications