Our Client is seeking an experienced and highly skilled Senior Data Modeler to join their data engineering team. 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.
location: Columbus, Ohio
job type: Contract
salary: $75 - 90 per hour
work hours: 8am to 4pm
education: Bachelors
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.
qualifications:
Required Qualifications
- Experience:
- Minimum of 10+ years in data modeling or data architecture roles, with a strong portfolio of designing and implementing data models across various methodologies (Kimball, Inmon, and Data Vault 2.0).
- 2+ years of Data Vault 2.0 experience is a must have
- Proven experience with Databricks, particularly in building and managing Delta Live Tables (DLT).
- Proficient in Medallion Architecture (Bronze, Silver, Gold layers) and how it applies to scalable, modern data warehousing solutions.
- Hands-on experience with data integration, data quality, and data transformation on cloud platforms (e.g., Azure, AWS, GCP).
- Business Acumen: Demonstrated ability to work with business stakeholders to gather requirements, translate them into data models, and design data solutions that meet their needs.
- Proficient with SQL, Python, and/or PySpark for data manipulation and modeling.
- Familiarity with ETL/ELT tools, data warehousing platforms, and data modeling tools (e.g., ERwin, Lucidchart).
- Soft Skills: Excellent communication, documentation, and interpersonal skills. Ability to work collaboratively in cross-functional teams.
- Bachelor's degree in Computer Science, Information Systems, or a related field. Advanced degrees or relevant certifications (e.g., CDMP, Databricks certification) are a plus.
- Experience with data governance and data quality frameworks.
- Familiarity with Agile methodologies and DevOps practices, including CI/CD pipelines for data engineering.
- Knowledge of BI and data visualization tools (e.g., Power BI, Tableau) for downstream reporting.
skills: Top Skills Seeking:
- Databricks with a focus on DLT Pipelines
- DataVault 2.0 Python
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
