Data Modeler

Robotic Process Automation LLC; Chicago (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

Robotic Technologies Automation is seeking an experienced Data Modeler to design and maintain comprehensive data models, ensuring alignment with business requirements and governance standards. The role combines data architecture mastery with PMP-certified project management to drive data initiatives across teams.

The ideal candidate will develop ERDs, data dictionaries, and metadata, while coordinating with data engineers, analysts, and stakeholders to deliver scalable and compliant solutions in

Qualifications

• Experience designing and maintaining conceptual, logical, and physical data models.
• Strong knowledge of data governance, quality, and metadata management.
• Experience translating business requirements into scalable data architectures.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models.
• Analyze business requirements and translate into data models and database structures.
• Develop ERDs, data dictionaries, and metadata documentation.
• Collaborate with analysts, architects, engineers, developers, and stakeholders.
• Define data standards, naming conventions, and modeling best practices.
• Profile and map data, normalize and denormalize as needed.
• Support data warehouse, data lake, and ETL/ELT initiatives.
• Ensure data integrity, performance, and governance compliance.
• Identify data quality issues and recommend solutions.
• Manage project schedules, risks, and stakeholder communications.
• Lead project meetings and track milestones.

Skills

Data modeling

Data architecture

Project management

Education

PMP Certification

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.