Data Scientist Insurance & Financial Services

Macpower Digital Assets Edge Private Limited

Columbus, OH

JOB DETAILS
SALARY
$56–$56 Per Hour
SKILLS
Agile Programming Methodologies, Big Data, Business Intelligence, Business Skills, Communication Skills, Cross-Functional, Data Analysis, Data Collection, Data Mapping, Data Modeling, Data Modeling Tools, Data Profiling, Data Science, Data Warehousing, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Database Optimization, Documentation, Embarcadero ER/Studio, Financial Services, Git, IBM DB2, Insurance, Interpersonal Skills, Kanban, Lean Manufacturing, Maintain Compliance, Metadata, Microsoft SQL Server, Multiplatform/Cross-Platform, NCR Teradata, NoSQL, Oracle Database, Performance Modeling, Python Programming/Scripting Language, Quest Software TOAD, Requirements Management, SQL (Structured Query Language), Scrum Project Management and Software Development, Snowflake Schema, Source Code/Configuration Management (SCM), Structured Data, Sybase PowerDesigner, Team Player, Unix Operating Systems, erwin Data Modeler
LOCATION
Columbus, OH
POSTED
9 days ago
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. Skilled in structured execution of data analysis, data profiling, and data mapping tasks.
  • Ability to 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).
  • Experienced in designing data models for various patterns (e.g., relational, dimensional, hybrid) supporting data warehouse, BI, and big data applications.
  • Skilled in creating new data models and extending existing ones across multiple DBMS platforms (e.g., Oracle, SQL Server, DB2, Snowflake, Teradata, NoSQL).
  • Strong understanding of complex data integration and ETL processes; able to explain these clearly to both technical and non-technical stakeholders.
  • Demonstrated ability to identify and resolve data model performance issues to optimize database functionality and overall system performance.
  • Experienced in documenting and communicating 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).
  • 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.

About the Company

M

Macpower Digital Assets Edge Private Limited