Data Modeler

Robotics Technologies; Chicago (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

Robotics Technologies LLC is seeking an experienced Data Modeler to design and maintain conceptual, logical, and physical data models, collaborate with business and technical teams, and ensure data quality, scalability, and governance.

The role requires deep expertise in data architecture, modeling, and database design, with PMP certification and solid project management experience to lead schedules, risk management, and stakeholder communications across data initiatives in a fast-paced

Qualifications

• Experience designing conceptual, logical, and physical data models.
• Strong experience with data warehousing, ETL/ELT and data integration.
• PMP certification and project management experience.
• Ability to ensure data quality and governance compliance.
• Collaborative with cross-functional teams and stakeholders.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models.
• Analyze business requirements and translate into data models and database structures.
• Develop and maintain ERDs, data dictionaries, and metadata documentation.
• Collaborate with business analysts, data architects, data engineers, and developers.
• Define data standards, naming conventions, and modeling best practices.
• Perform data profiling, mapping, normalization, and denormalization as needed.
• Support data warehouse, data lake, ETL/ELT, and data integration initiatives.
• Ensure data integrity, performance, and governance compliance.
• Identify data quality issues and propose solutions.
• Manage project schedules, milestones, risks, and communications.

Skills

Data modeling

Data architecture

Project management

ERD design

Data governance

Data profiling

Education

PMP certification

Tools

ERD tools

SQL

ETL tools

Job description

We are seeking an experienced Data Modeler with strong expertise in data architecture, data modeling, and database design, along with PMP certification and project management experience. The ideal candidate will be responsible for designing and maintaining conceptual, logical, and physical data models, collaborating with business and technical teams, and ensuring data consistency, quality, scalability, and alignment with business requirements.

Key Responsibilities:

• Design, develop, and maintain conceptual, logical, and physical data models.
• Analyze business requirements and translate them into effective data models and database structures.
• Develop and maintain Entity Relationship Diagrams (ERDs), data dictionaries, and metadata documentation.
• Collaborate with business analysts, data architects, data engineers, application developers, and project stakeholders.
• Define data standards, naming conventions, data relationships, and modeling best practices.
• Perform data profiling, data mapping, normalization, and denormalization as required.
• Support data warehouse, data lake, ETL/ELT, and data integration initiatives.
• Ensure data integrity, consistency, performance, and compliance with enterprise data governance standards.
• Identify data quality issues and recommend appropriate solutions.
• Manage project schedules, deliverables, risks, dependencies, and stakeholder communications using established project management practices.
• Lead project meetings, track milestones, and provide status reports to stakeholders.
• Coordinate cross-functional teams to ensure timely delivery of data modeling and database design activities.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.