Workday HR Data Model Design - DATA MODELER (SQLDBM)

$2-8 USD / hour

Posted 1 minute ago

•

Ends in 6 days

$2-8 USD / hour

I’m building a brand-new relational database that will mirror the full breadth of our Workday HRMS environment, and I need the entire data model—from high-level concepts to deploy-ready DDL—planned out in one cohesive effort. The scope covers every core HR area we rely on: • Worker profiles, jobs, and organization structure • Recruiting, onboarding, and employee changes • Payroll, benefits, time, and leave Here’s what I expect: 1. Conceptual, logical, and physical models that line up with Workday’s object structure yet remain platform-agnostic for future growth. 2. All diagrams and metadata authored directly in SQLDBM Cloud (experience here will speed us up tremendously). 3. A final export that includes ER diagrams, an editable SQLDBM project file, and clean, executable DDL scripts. Acceptance will be based on referential integrity, naming consistency, normalization to at least 3NF where appropriate, and clear documentation of every entity and relationship. If you’ve delivered green-field data models before—especially in HR or Workday contexts—let’s get this designed right the first time.

Project ID: 40820079

About the project

12 proposals

Open for bidding

Remote project

Active 1 sec ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

12 freelancers are bidding on average $13 USD/hour for this job

User Avatar
Flag of PAKISTAN

Hi There, Ready right now I'm ready for Conceptual, logical, and physical models that line up with Workday’s object structure. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer

User Avatar
Flag of PHILIPPINES

Hello, Your project requires the design of a comprehensive relational database to reflect your Workday HRMS environment, focusing on core HR areas like worker profiles and payroll. I can create a cohesive data model that aligns with Workday's structure while ensuring future scalability. With extensive experience in database design using SQLDBM, I recommend developing conceptual, logical, and physical models that adhere to normalization standards. This will ensure data integrity and consistency throughout the database. I will implement the data model in SQLDBM, ensuring all diagrams and metadata meet your specifications. The timeline can be discussed further, but I estimate around 4-6 weeks for completion, depending on your feedback and revisions. Could you confirm if any specific compliance or reporting requirements need to be included in the model? Please feel free to reach out to me. I look forward to working with you. Best regards, Billy Bryan

User Avatar
Flag of BAHRAIN

Hello! I'd be glad to help design your complete Workday-aligned HR relational data model, covering worker profiles, jobs, organizational structures, recruiting, onboarding, payroll, benefits, time, and leave. You need a cohesive design that reflects Workday's HR structure while remaining platform-agnostic, scalable, and ready for implementation. I understand that this requires more than creating ER diagrams. The conceptual, logical, and physical layers must remain consistent, with properly defined keys, relationships, constraints, and normalized entities. My recommendation is to establish a strong core worker and organization model first, then connect the remaining HR domains through consistent relationships. I'll begin by mapping the business entities and their relationships, then develop the logical model and physical schema directly in SQLDBM Cloud. I'll apply 3NF where appropriate, define primary and foreign keys, document metadata, and generate clean executable DDL scripts. Finally, I'll validate referential integrity, naming consistency, and the complete model before delivering all requested files. I'd welcome the opportunity to design this foundation carefully and make future expansion straightforward. Let's discuss your Workday data scope and preferred database platform. Looking forward to working with you!

User Avatar
Flag of UNITED STATES

Hi, designing a full Workday HRMS data model that covers worker profiles, recruiting, payroll, and benefits with consistent naming and normalization fits well with my experience building complex data pipelines and ETL for regulated financial systems at Fannie Mae. I also delivered end-to-end data models and metadata documentation in cloud tools for Spintel’s large, multi-stage AWS pipeline. Here’s how I’d handle it: 1) ensure referential integrity and normalization by carefully mapping Workday objects to a platform-agnostic schema checked with automated tests; 2) use SQLDBM Cloud for all diagrams and metadata, applying best practices to streamline collaboration and updates; 3) generate clean, deployable DDL scripts alongside detailed documentation for every entity and relationship. I estimate around four to six weeks with milestones for conceptual design, logical and physical modeling, and final delivery. I can start now. Julia

User Avatar
Flag of MEXICO

[WORKDAY DATA STRUCTURE] The main challenge is modelling Workday's broad HR structure without creating unnecessary complexity or tightly coupling the database to one platform. I'd approach this by defining the core entities and relationships first, then developing the logical and physical models in SQLDBM. Worker records, employment history, jobs, organizational structures, recruiting, payroll, benefits, time, and leave need consistent relationships and clear separation of responsibilities. I'll pay particular attention to historical employee changes, effective dates, primary and foreign keys, and normalization so the model remains maintainable as your HR environment grows. The deliverables can include the conceptual, logical, and physical diagrams, documented metadata, editable SQLDBM project, and executable DDL scripts. Before estimating the full workload, I'd like to clarify the expected Workday data coverage and source structure. Best regards, Fernando

User Avatar
Flag of UNITED STATES

Dear [Client's Name], I hope this message finds you well. I am excited about the opportunity to work on designing a comprehensive data model for your Workday HRMS environment. Understanding the need for a seamless and scalable relational database that mirrors every core HR area, I am confident in my ability to deliver a robust solution that aligns with your strategic goals. With extensive experience in data modeling, particularly in HR contexts, and a strong proficiency in SQLDBM Cloud, I am well-equipped to create conceptual, logical, and physical models that faithfully represent Workday's object structure. My approach will ensure the models are platform-agnostic, providing the flexibility needed for future scalability. I will focus on establishing clear referential integrity and naming consistency while ensuring normalization to at least the third normal form where appropriate. My commitment to thorough documentation will facilitate easy understanding and maintenance of the database. The final deliverables will include detailed ER diagrams, an editable SQLDBM project file, and executable DDL scripts, ensuring you're equipped with a deploy-ready data model. Having previously delivered green-field data models, I bring a wealth of knowledge and a proven track record of success in similar projects. I am eager to apply this experience to your project, ensuring that we get the design right from the outset. Thank you for considering my proposal. I look forward to the possibility of collaborating and contributing to the success of your project. Best regards, Dominique

User Avatar
Flag of SERBIA

HELLO, "Workday Data Model Design" - you need a complete, consistent HR data architecture covering the full employee lifecycle, not disconnected ER diagrams. I'll develop the conceptual, logical, and physical models directly in SQLDBM Cloud, covering worker profiles, jobs, organizational structures, recruiting, onboarding, payroll, benefits, time, and leave. I'll map relationships to Workday's object structure while keeping the schema platform-agnostic and normalized to 3NF where appropriate. I'll also define primary and foreign keys, naming conventions, entity metadata, and executable DDL so the final model is both documented and deployment-ready. I'll pay particular attention to effective-dated employee records and historical changes, which are essential in HR data modeling. Do you have existing Workday entity definitions or sample exports to use as the reference for the model? I appreciate your consideration and look forward to discussing the data architecture. THANKS

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅