Data Scientist – Insurance & Financial Services

Job Summary

Demonstrated experience working directly with stakeholders, business partners, SMEs, systems peers, and cross-functional teams to gather data requirements and design data models that align with business needs.

Responsibilities

• Structured execution of data analysis, data profiling, and data mapping tasks.
• Translate current and future business requirements into conceptual, logical, and physical data model designs.
• Proficient in using standard data modeling tools (e.g., Erwin, ER/Studio, Toad Data Modeler, PowerDesigner).
• Design data models for various patterns (e.g., relational, dimensional, hybrid) supporting data warehouse, BI, and big data applications.
• Experienced in designing data models for various DBMS platforms (e.g., Oracle, SQL Server, DB2, Snowflake, Teradata, NoSQL).
• Skilled in creating new data models and extending existing ones across multiple DBMS platforms.
• Strong understanding of complex data integration and ETL processes; able to explain these clearly to both technical and non-technical stakeholders.
• Identify and resolve data model performance issues to optimize database functionality and overall system performance.
• Create documentation and communicate data model designs and standards to ensure understanding and adherence across the organization.
• Excellent communication skills, with the ability to collaborate effectively with individuals across all levels of business and technology functions.
• Fluency in Python, SQL, and Unix.
• High proficiency in writing complex SQL queries.
• Experience with version control of databases and metadata management tools (e.g., Git, Liquibase).

Requirements

• Background in the Insurance and Financial domains is highly desirable.
• Experience working in Agile environments using Lean, Kanban, and Scrum practices.

Must Have

• Proficiency with standard data modeling tools (e.g., Erwin, ER/Studio, Toad DM, PowerDesigner).
• Experience designing data models across multiple distinct patterns (relational, dimensional, hybrid) for data warehouses, BI, and big data applications.
• Ability to create new and extend existing data models across various DBMS platforms (Oracle, SQL Server, DB2, Snowflake, Teradata, NoSQL).
• Strong understanding of complex data integration and ETL processes.
• Proven ability to identify and resolve data model performance issues to enhance system functionality.
• Ability to clearly document and communicate data model standards to ensure organizational alignment.
• Strong interpersonal and communication skills to interact across all business and technical levels.
• Proficiency in Python, SQL, and Unix.
• High-level expertise in generating complex SQL queries.
• Familiarity with version control and metadata tools (e.g., Git, Liquibase).
• Domain experience in Insurance and Financial Services is highly preferred.
• Hands-on experience in Agile methodologies including Lean, Kanban, and Scrum.