Sr. Data Modeler

Sr. Data Modeler - Contract - Richmond, VA - $50.00 - $55.00/hr.

The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.

Applicants must be legally authorized to work in the United States. Sponsorship not available.

Our client is seeking a Sr. Data Modeler in Richmond, VA.

Role Description

The Analytics Data Modeler plays a vital role in transforming raw data into meaningful business insights. This professional is responsible for designing, developing, and maintaining robust data models that empower organizations to make informed decisions based on accurate and accessible information. Working at the intersection of business needs, data architecture, and advanced analytics, the Analytics Data Modeler ensures that data flows seamlessly and can be leveraged to derive actionable intelligence.

Data Modeling and Design: Develop conceptual, logical, and physical data models for business intelligence, analytics, and reporting solutions. Transform requirements into scalable, flexible, and efficient data structures that can support advanced analytics.
Requirement Analysis: Collaborate with business analysts, stakeholders, and subject matter experts to gather and interpret requirements for new data initiatives. Translate business questions into data models that can answer these questions.
Data Integration: Work closely with data engineers to integrate data from multiple sources, ensuring consistency, accuracy, and reliability. Map data flows and document relationships between datasets.
Database Architecture: Design and optimize database schemas using the medallion architecture which includes relational, star schema and denormalized data sets for BI and ML data consumers.
Metadata Management: Team with the data governance team so detailed documentation on data definitions, data lineage, and data quality statistics are available to data consumers.
Data Quality Assurance: Establish master data management data modeling so the history of how customer, provider and other party data is consolidated into a single version of the truth. transformation.
Collaboration and Communication: Serve as a bridge between technical teams and business units, clearly communicating the value and limitations of various data sources and structures.
Continuous Improvement: Stay abreast of emerging trends in data modeling, analytics platforms, and big data technologies. Recommend enhancements to existing data models and approaches.
Performance Optimization: Monitor and optimize data models for query performance and scalability. Troubleshoot and resolve performance bottlenecks in collaboration with database administrators.
Governance and Compliance: Ensure that data models and processes adhere to regulatory standards and organizational policies regarding privacy, access, and security.
Participating in meetings with business stakeholders to understand analytical needs and challenges.
Designing and documenting data models, including entity relationships, keys, indexes, and constraints.
Collaborating with data engineers and architects to create data pipelines and integrate new data sources into the data models.
Identifying attributes and data structures needed to take changes in data values due to data repairs or data quality remediation so users can understand why the values are different from the source system.
Testing and validating data structures to ensure they meet organizational requirements.
Creating and updating metadata repositories and data dictionaries.
Ensuring compliance with data governance and privacy standards.

Skills & Requirements

Bachelor's degree in Computer Science, Information Systems, Data Science, Mathematics, or related field. Master's degree preferred.
Minimum 3 years of experience in data modeling in a Lakehouse analytics environment.
Experience in insurance industry which can be P&C, Life, or healthcare.
Proficiency in a data modeling tool such as ER Studio.
Solid understanding of DataBricks Delta tables and Postgres database platforms.
Experience with big data technologies and platforms (e.g., DataBricks, Spark, AWS, Azure).
Expert level in DDL and SQL development
Experience with data governance, quality frameworks, and metadata management, and how this connects to data modeling practices and needs.
Strong analytical, problem-solving, and critical thinking skills needed for data modeling
Excellent communication and interpersonal abilities.
Understanding of PII and PHI data and how they are governed and secured
Experience working on an agile team using agile tools, and associated practices.
Knowledge of business intelligence tools (e.g., Power BI, Spotfire).
Data taxonomies in insurance down to two or three levels
Knowledge of typical data quality issues with insurance data
Knowledge of cloud data management, data lakes, and ETL (Extract, Transform, Load) processes.
Ability to work independently and collaboratively in a cross-functional team environment.
Strong attention to detail and commitment to data accuracy.
Lakehouse
Structured approach like medallion architecture (bronze, silver, gold, platinum) -
Databricks
understand how big data tables work
DDL - data definition language
SQL
Some understanding of data quality, metadata - understand where the data is coming

Benefits/Other Compensation

This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).

Why Hays?

You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.

Nervous about an upcoming interview? Unsure how to write a new resume?

Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.

Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.

In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .

Drug testing may be required; please contact a recruiter for more information.

#LI-DNI