Data Modeler

Role: Data Modeler Location: NY/NJ (Onsite) No. of years experience: 12+years Must have Property and Casualty insurance domain experience. Job Duties and Responsibilities: Data Modeling: • Design, create, and maintain conceptual, logical, and physical data models for data warehouses, claims databases, and other data storage systems. • Work with claims stakeholders to understand business requirements and translate them into Data Modeling specifications. • Develop and maintain entity-relationship (ER) diagrams and other types of data flow representations. Data Analysis: • Analyse business requirements and current systems to ensure data model alignment. • Perform data profiling to understand claims data structures, relationships, and quality. • Identify data quality issues, inconsistencies, and gaps within data sources. Database Design and Architecture: • Collaborate with Database Administrators (DBAs) and Data Architects to design efficient, high-performance database structures. • Define database schema, indexes, relationships, and constraints to ensure data consistency and integrity. • Ensure data models adhere to industry standards and best practices. Collaboration with Business and IT Teams: • Work closely with claims business analysts, data engineers, and IT teams to define data requirements and model solutions. • Act as a bridge between technical and non-technical stakeholders to ensure proper data understanding and usage. • Translate business requirements into technical specifications for data storage and retrieval. Data Integration: • Design and implement data integration strategies to combine data from multiple sources. • Ensure seamless data flow and integration between systems, databases, and applications. • Monitor and optimize data transfer processes to enhance performance and reduce latency. Performance Optimization: • Optimize data models and queries for performance improvements in data retrieval and reporting. • Analyse and resolve performance bottlenecks in data systems or applications. Documentation and Standards: • Develop and maintain comprehensive data model documentation for future reference and troubleshooting. • Define and enforce standards for data naming conventions, data structure formats, and documentation practices. • Provide guidance on how to interpret and implement data models. Data Governance and Security: • Ensure data models comply with data governance policies, standards, and best practices. • Collaborate with the security team to implement security controls and ensure sensitive data is protected. • Support data privacy and regulatory requirements (e.g., GDPR, HIPAA). Model Review and Quality Assurance: • Conduct data model reviews and validation sessions to ensure quality and alignment with business needs. • Perform data model testing to identify issues or errors before implementation. Training and Mentorship: • Provide training and guidance to team members, such as data engineers and analysts, on how to use and maintain data models effectively. • Mentor junior data modelers and help them grow their skills in the field. Continuous Improvement: • Stay updated with new Data Modeling techniques, tools, and technologies. • Continuously improve existing data models by applying lessons learned, optimizing structures, and incorporating feedback. Skills and Qualifications: • Proficiency in Data Modeling tools (e.g., Erwin, Microsoft Visio, Oracle SQL Developer). • Strong understanding of relational and NoSQL databases (e.g., MySQL, PostgreSQL, MongoDB). • Experience with data warehousing, ETL processes, and data integration tools. • Knowledge of SQL and scripting languages for data manipulation and Modeling. • Understanding of data governance, data security, and privacy practices. • Strong analytical and problem-solving abilities.