Data Modeler

Galent; Torrance (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

Galent is seeking an experienced Data Modeler to design scalable, business-aligned data models for enterprise platforms. You will translate requirements into conceptual, logical and physical models, collaborating with data architects, engineers, ETL, and BI teams.

You will define metadata standards, contribute to governance, and ensure models support data quality and analytics needs across onshore stakeholders.

Qualifications

• Experience designing enterprise data models across conceptual, logical and physical layers.
• Strong understanding of relational and dimensional modeling and data warehousing concepts.
• Ability to translate business requirements into data structures and metadata.

Responsibilities

• Work with business and technology stakeholders to understand data requirements.
• Develop and maintain conceptual, logical and physical data models.
• Translate requirements into entities, attributes, relationships and hierarchies.
• Design normalized and dimensional models (star/snowflake) for analytics and ops.
• Define data dictionaries, metadata standards and modeling docs.
• Perform data analysis, source-to-target mapping and impact analysis.
• Collaborate with Data Architects, Data Engineers, ETL and BI teams.
• Support data integration initiatives and governance compliance.
• Identify data quality issues and recommend solutions.
• Participate in design reviews and document modeling changes.

Skills

Enterprise data modeling

Data modeling lifecycle

Star & Snowflake schemas

SQL and DB concepts

ERwin/ERStudio/PowerDesigner

ETL/ELT data warehousing

Metadata governance

Analytical problem-solving

Stakeholder communication

Requirement discussions with onshore

Tools

ERwin

ERStudio

PowerDesigner

Job description

We are looking for an experienced Data Modeler to design scalable and business aligned data models for enterprise data platforms. The candidate will work closely with business stakeholders data architects engineering teams and application teams to translate business requirements into effective conceptual logical and physical data models.

Key Responsibilities

• Work directly with onshore business and technology stakeholders to understand data requirements and business processes.
• Develop and maintain Conceptual Logical and Physical Data Models.
• Translate business requirements into appropriate entities attributes relationships hierarchies and data structures.
• Design normalized and dimensional data models based on analytical and operational requirements.
• Define and maintain data dictionaries metadata naming standards and modeling documentation.
• Perform data analysis source to target mapping and impact analysis for new requirements and enhancements.
• Work closely with Data Architects Data Engineers ETL teams BI teams and application teams.
• Support data integration initiatives involving multiple source and target systems.
• Identify data quality consistency redundancy and standardization issues and recommend appropriate solutions.
• Participate in design reviews and ensure data models comply with enterprise architecture and governance standards.
• Support model versioning change management and documentation throughout the project lifecycle.
• Communicate design decisions dependencies risks and issues effectively to technical and business stakeholders.

Required Skills

• Strong experience in enterprise data modeling.
• Handson experience with conceptual logical and physical data modeling.
• Strong understanding of relational and dimensional modeling including Star and Snowflake schemas.
• Good knowledge of database concepts SQL normalization denormalization keys relationships and constraints.
• Experience with modeling tools such as ERwin ERStudio Power Designer or equivalent.
• Understanding of data warehousing ETLELT data integration and analytics ecosystems.
• Knowledge of metadata management data lineage master reference data and data governance concepts.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Ability to independently conduct requirement discussions and design walkthroughs with onshore stakeholders.

Preferred Skills

• Experience with cloud data platforms such as Snowflake Databricks AWS Azure or similar platforms.
• Exposure to modern data lake Lakehouse architectures.
• Experience working in Agile delivery environments.
• Domain experience in automotive manufacturing financial services or other large enterprise environments would be an advantage.
• Act as the primary data modeling interface with business and technology stakeholders.
• Lead requirement clarification and data modeling discussions.
• Coordinate effectively with offshore engineering and development teams.
• Drive timely resolution of data modeling dependencies and design clarifications.Present models and recommendations clearly to both technical and nontechnical stakeholders
• Provide your feedback on BizChat.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf