Data Scientist

Columbus, Ohio

 Macpower Digital Assets Edge
Apply for this Job
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.
  • bility 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.
  • bility 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.
  • bility 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.
Date Posted: 14 May 2025
Apply for this Job
Show me similar jobs
Send me jobs by email