Date Posted: 07/21/2026
Hiring Organization: Rose International
Position Number: 504475
Industry: Government/Staffing
Job Title: Senior Data Modeler Oracle PL SQL & ERwin
Job Location: Madison, WI, USA, 53703
Work Model: Hybrid
Work Model Details: 90% remote 10% onsite as needed
Shift: 8:00 AM - 5:00 PM
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 13
Min Hourly Rate($): 50.00
Max Hourly Rate($): 52.00
Must Have Skills/Attributes: Data Modeler, Data Warehouse, Oracle
Experience Desired: Advanced knowledge of conceptual, logical and physical data modeling concepts (5 yrs); Experience in ERWIN data modeling software (5 yrs); Experience in reverse-engineering data structures and metadata development (5 yrs); Advanced experience in Oracle PL/SQL (6 yrs); Conceptual, Logical and Physical Data Modeling (5 yrs); Create database objects (5 yrs); Creating and reviewing SQL scripting (5 yrs)
**C2C is not available**
Job Description
Wisconsin residency is required. Must be Wisconsin resident or willing to relocate within 30 days of start date at own expense. 90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite work is not likely, but candidate should be prepared to come onsite if required.
Required Skills and Experience:
• Advanced knowledge of conceptual, logical and physical data modeling concepts; looking for BOTH APPLICATION and data warehouse database modeling experience (5+ Years)
• Experience in ERWIN data modeling software (5+ Years)
• Experience in reverse-engineering data structures and metadata development (5+ Years)
• Advanced experience in Oracle PL/SQL (6+ Years)
• Conceptual, Logical and Physical Data Modeling (5+ Years)
• Create database objects (5+ Years)
• Database design (5+ Years)
• Erwin Data Modeling Software (5 Years)
• Excellent organization, analytical, and communication skills (5 Years)
• Data analysis (5 Years)
• Creating and reviewing SQL scripting (5 Years)
• Knowledge of Oracle PL/SQL (6 Years)
• Metadata tools (5 Years)
• Oracle 11g/DB2/SQL Server (5 Years)
• Oracle data dictionary views (4 Years)
• Metadata documentation experience (5 Years)
• Data quality assessment and profiling (5 Years)
Preferred Skills and Experience:
• Experience with human services
Responsibilities:
• Develop conceptual, logical, and physical data models for client data architecture
• Ensure that all relevant aspects of data model (granularity, etc.) are considered
• Analyze the logical and physical database models and guarantee models are in accordance with standards
• Document and define key metadata around database architecture
• Translate technical aspects of data modeling (facts, dimensions, “snowflaking”, etc.) into language that non-technical users can understand
• Work with both technologists as well as non-technical users with ease and approachability
• Make recommendations on data maintenance tactics for slowly changing dimensions, data roll-off / archival planning, etc
• Design models optimized for both storage (warehouse) and query / retrieval (end user marts)
• Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues
• Position will be responsible for documenting key metadata on current production application databases
• Position will work independently to assess and create key metadata documentation with guidance from senior Data Architect
• Conducts tasks and assignments as directed
• Works with moderate supervision with some latitude for independent judgment
• Career-Development position within field
• Conducts tasks and assignments as directed
• Works with moderate supervision with some latitude for independent judgment
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
I believe the best thing that Rose HR has going for it is the incredible responsiveness. Everyone is very quick to reply to any concerns, and contacts the contracted employees very quickly and efficiently.
Kevin, Consultant
I had a very positive experience working for Rose. The entire process is very efficient and easy.
Joanne, Consultant
Working for Rose International was the most pleasant assignment I have ever had. They were always on top of situations when necessary, and very helpful. I was very proud to be an employee of Rose International, and would recommend anyone to try to work with them.
Melvon, Consultant
It was great working for Rose International. Everyone was extremely helpful.
Rosann, Consultant
My on-boarding with Rose was outstanding. The packets of information, the process, and great attention to detail each person gave me allowed me to get started quickly.I appreciated each person's friendly and helpful attitude.
Diana, Consultant
EMPLOYEE COMMENTS