Always Connecting, Always Evolving.
TECHEAD is seeking qualified applicants for the following Contract position – Senior Data Modeler / Richmond VA – (JOB-22166). If you are looking for a new opportunity and this position looks to be a fit, please apply to see the TECHEAD difference that has made us successful for 30+ years!
You can find more about our team and values by checking us out at TECHEAD.com or on Glassdoor
Job Description:
Senior Data Modeler
Contract: 8 Months
REMOTE
Responsibilities:
• 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.
Must Have Requirements:
- Minimum 3 years of experience in data modeling in a Lakehouse analytics environment.
- Deep familiarity with modern data modeling techniques, database management, and analytics platforms.
- 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.
Preferred Skills:
• 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.
Day-to-Day Activities:
• 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.
• Training and providing support and guidance to analysts and business users on data usage and best practices.
• Working with business users to understand current business practices, processes, and data to understand how the data should be modeled. Reviewing data models with business users for feedback and sign off.
• Ensuring compliance with data governance and privacy standards.
Required Education:
• Bachelor’s degree in Computer Science, Information Systems, Data Science, Mathematics, or related field. Master’s degree preferred.
TECHEAD’s mission is to make our on-site associates successful by placing them in the right environment so they can grow and prosper. How we treat and respond to our clients and employees is a reflection of who we are and makes us stand out from the rest. Keeping our business focused on building and maintaining relationships with our employees and clients is the key to our success. We won’t strive for anything less.
TECHEAD provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
For more information on TECHEAD please visit www.techead.com.
No second parties will be accepted.
