Data Modeler

Data Modeler With Data Mapping Experience

Location: [100% Remote] Duration: [1+ Year of Contract]

Job Summary: We are seeking a skilled Data Modeler with strong Data Mapping expertise to join our data engineering or analytics team. This role involves designing conceptual, logical, and physical data models and performing source-to-target data mapping across various data platforms. You will collaborate closely with data architects, business analysts, developers, and stakeholders to ensure data is accurately modeled and mapped to support business requirements and analytics.

Key Responsibilities:

• Design and develop conceptual, logical, and physical data models to support data integration, data warehousing, and analytics.
• Perform data mapping from source systems to target data models, ensuring accuracy and completeness.
• Collaborate with data architects and business analysts to gather requirements and understand data needs.
• Analyze source system data structures, including relational databases, flat files, APIs, and NoSQL sources.
• Create and maintain metadata documentation, data lineage, and data dictionaries.
• Support ETL/ELT developers with technical data mapping specifications and transformation rules.
• Ensure models comply with data governance, quality, and security standards.
• Optimize data models for performance, scalability, and reusability.
• Participate in data model reviews and ensure alignment with enterprise data standards.
• Use data modeling tools such as Erwin, ER/Studio, SAP PowerDesigner, or similar.

Required Skills and Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 4+ years of experience as a Data Modeler or Data Analyst.
• Strong experience in data mapping, source-to-target mapping (STM), and transformation logic.
• Solid understanding of relational database concepts and proficiency in SQL.
• Experience working with data warehousing, ETL/ELT processes, and data lakes.
• Proficiency with data modeling tools (Erwin, ER/Studio, PowerDesigner, etc.).
• Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and modern data ecosystems.
• Excellent communication and documentation skills.

Preferred Qualifications:

• Experience with big data technologies (e.g., Hadoop, Spark).
• Understanding of data governance frameworks and metadata management.
• Familiarity with data integration tools (e.g., Informatica, Talend, Azure Data Factory).