E logo

Data Engineer - Data Modeling

eCom Solutions IncDallas, TX

Overview

Remote
On-site

Job Description

Required skills:• 5 or more years of hands-on experience in data modeling, data architecture, or database design roles.• Expert proficiency with Erwin Data Modeler (version 9.x or higher preferred) including subject areas, model templates, DDL generation, forward/reverse engineering, model versioning, and complete compare functionality.• Advanced SQL skills and deep understanding of Oracle (11g/12c/19c/21c) including SQL, PL/SQL, schema design, and performance tuning fundamentals as they relate to data model design.• Demonstrated experience building both normalized (3NF) transactional models and dimensional models (star/snowflake) for reporting and analytics.• Strong command of DDL creating and modifying tables, indexes, constraints, sequences, synonyms, and materialized views.• We are seeking a Data Modeler with deep expertise in Oracle database platforms and Erwin data modeling to design, govern, and evolve enterprise data models that support mission-critical business processes. This role is responsible for translating business and analytical requirements into robust conceptual, logical, and physical data models, and for ensuring those models are implemented consistently across our Oracle environments.

Key Responsibilities Primary responsibilities of the Data Modeler include designing, developing, and maintaining enterprise grade data models that support critical business initiatives, analytics, and operational systems

Nice to have skills:• Experience in a regulated industry (utilities, financial services, insurance, healthcare) with associated data governance and compliance requirements.• Familiarity with additional modeling or metadata tools (e.g., ER/Studio, PowerDesigner, Collibra, Alation). • Exposure to cloud data platforms (e.g., Oracle Cloud, AWS, Azure, Snowflake, Databricks) and hybrid on-prem/cloud modeling scenarios. • Working knowledge of ETL/ELT tools and data integration patterns. • Experience supporting master data management (MDM) or data governance initiatives.• Experience working with Microsoft SQL Server • Experience working with PostGres • Data vault experience • Experience with Hadoop/MongoDB

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

pay-wall

FAQs About Data Engineer - Data Modeling Jobs at eCom Solutions Inc

What is the work location for this position at eCom Solutions Inc?
This job at eCom Solutions Inc is located in Dallas, TX, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at eCom Solutions Inc?
Employer has not shared pay details for this role.
What employment applies to this position at eCom Solutions Inc?
The employer has not provided this information. This may be discussed during the hiring process.
What is the process to apply for this position at eCom Solutions Inc?
You can apply for this role at eCom Solutions Inc either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.