Logo
Cynet Systems

Data Designer /Modeler

Cynet Systems, Cleveland, Ohio, us, 44101

Save Job

Job Description: Pay Range: $44/hr - $48/hr Primary Skill:

Data Modelling Experience:

5+ years Tools Must-Haves: Programming Languages: Python, SQL Cloud: AWS Data Integration: API, Databricks, Talend, Informatica Data Modeling: Erwin (or experience with another modeling tool) Databases: Oracle, SQL Server, DB2, Snowflake, Teradata, NoSQL (MongoDB, Graph) Version Control: GitHub, Liquibase Collaboration: Demonstrated skill working directly with stakeholders, business partners, SMEs, systems peers, and cross-functional teams to elicit data requirements and design data models aligned with business needs Data Modeling Design: Translating business requirements into conceptual, logical, and physical data models using tools like Erwin, ER Studio, Toad DM, PowerDesigner Data Analysis: Structured execution of data profiling, mapping, and analysis tasks Data Quality & Governance: Maintain referential integrity, follow data governance practices supporting data cataloging, taxonomy, lineage, and quality Model Design Patterns: Designing data models for relational, dimensional, and hybrid patterns for data warehouses, BI, and large data applications Model Creation & Extension: Developing new data models and extending existing ones across multiple DBMS platforms Data Integration & Extraction: Understanding and explaining complex data integration, ETL processes Performance Optimization: Identifying and resolving data model performance issues Documentation & Communication: Documenting data model designs and standards for organizational understanding and compliance Technical Skills: Fluency in Python, SQL, Unix; proficiency in generating complex SQL queries; version control of databases and metadata tools Communication Skills: Effective interaction across all organizational levels Agile Experience: Working in Agile environments using Lean, Kanban, Scrum Domain Experience: Insurance and Financial sectors highly preferred As a Data Designer, you will process, organize, structure, and present data to support business decision-making, participate in projects, analyze data, and provide insights through reports, visualizations, and other analytical tools. #J-18808-Ljbffr