← Back to Jobs
Remote
Technology
Business Intelligence Data Modeler II
Universal Consulting Partners Inc.Madison, WI🇺🇸United StatesPosted 22 Jul 2026
Quick Overview
Work Type
Remote
Level
Mid Senior
Job Description
This is a data modeler position who will be responsible for documenting several key business areas and concepts through the reverse engineering of models as well as the analysis and creation of key metadata points (definitions, etc.). While this is being posted as a Business Intelligence Data Modeler, DCF is looking for someone with both application and data warehouse database modeling experience.
Detailed Job Description: This is a data modeler position who will be responsible for documenting several key business areas and concepts through the reverse engineering of models as well as the analysis and creation of key metadata points (definitions, etc.). While this is being posted as a Business Intelligence Data Modeler, DCF is looking for someone with both application and data warehouse database modeling experience.
The individual in this position will:
- Develop conceptual, logical, and physical data models for DCF 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.
- Assessment of data quality within database architecture.
** The project is currently funded through 12/31/26 with the potential for an extension.”
Experience with Human Services is desirable.
Qualification | Experience |
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 |
Project Details:
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.
Top Required skills:
- 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)
Preferred Skill:
- Experience with human services
INTERVIEW NOTES: PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidate''''s bid upon confirming the interview. Please see DCF Realtime Photo Requirement & Instructions document in the Attachments section of this posting for details.
- Interviews will be set up shortly after the posting close date.
- MUST provide three (3) business references for the interview. (One reference must be a supervisory level.)
IMPORTANT NOTES:
- Candidate MUST be physically located in the United States. International candidates/phone numbers will not be accepted.
- Candidate must follow ALL DCF work rules
- Candidate must be available to perform all work during the Central Standard Time (CST) business hours 9:00 am – 3 pm (or CST hours as defined by the hiring manager)
- Candidates will be required to provide their own equipment for this position (See job description for required specifications.)
Interview Process:
- via Zoom/Teams.
Onsite, hybrid or remote:
- WI residency required. Must be WI 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.
Contract Duration:
- The project is currently funded through 12/31/26 with the potential for an extension.
Project Details:
- 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. While this is being posted as a Business Intelligence Data Modeler, DCF is looking for someone with both application and data warehouse database modeling experience.
Will this position have access to FTI (Federal Tax Information)?
- No
On Call hours required?
- No
Will the position require any weekend coverage? (IE: weekend maintenance)
- No
Is this position Remote, Hybrid**, or In Person?
**For Hybrid, please provide breakdown of Remote % and Onsite % (required):
**For Hybrid, please provide breakdown of Remote % and Onsite % (required):
- Remote
Does this position require the candidate to provide a mobile device for use to use as part of this position (ie: iPad/iPhone/Android)? Yes If so, please explain: Needs mobile device for multi-authentication method
Other Notes to Suppliers:
- Selected candidate will be required to provide personal equipment for remote work. Technical specifications of hardware are:
Home Internet Service: Minimum 20 Mbit down and 5 Mbit up. Capability to plug in network (cat 5a or better) cable to the computer.
Windows Computers
- Operating System: Any currently supported version of Windows 11
- Memory: Minimum 8 GB, Preferred 16 GB+
- Processor (CPU): 64-bit
- Graphics card that supports Direct3D 11 Video
- Installation of the latest Omnissa Horizon Client
Apple Computers
- Operating System: MacOS: Any currently supported version of MacOS 13 or higher
- Memory: Minimum 8 GB, preferred 16 GB+
- Processor (CPU): Any 64-bit Intel-based Mac or ARM M-based Mac
- Installation of the latest Omnissa Horizon Client
It is required to have full audio/video conferencing capabilities (camera and headset).
It is expected that you will update and maintain your hardware to always be compatible with the most current version of the Omnissa Horizon Client
- ALL candidates must be located within the United States. ALL contact information must also be domestic. Absolutely no work outside of the US is allowed.
- Selected candidate will not be assigned specific work-space however, may be required to report in person as needed with minimal notice.
- An in-person interview may be required before a final hire is made. The hiring manager has discretion to allow phone or video interviews at any point during the process.
- Please provide three (3) business references for the interview.
- The selected candidate will be required to sign all onboarding documents as part of the onboarding process. Candidate will also be required to complete any security training as directed by the division, department, or agency.
- The selected candidate will be required to complete a criminal background check and any fingerprinting as required by the position.
- This position is budgeted for 1960 hours annually. Hours will be prorated the first year based on start date.
- DCF does not sponsor work visas, either at the time of hire or at any later date
- Suppliers must disclose any/all levels of sub-contracting and their respective supplier name(s).
- Selected candidate must provide copies of any/all certifications as part of the hiring process.
Please note the qualifications for this position per the contract:
Data modeler capabilities with 4-5 years of experience. Requires moderate skill sets and developing proficiency within discipline. Conducts tasks and assignments as directed. Works with moderate supervision with some latitude for independent judgment. Career-Development position within field. Requires moderate skill sets and developing proficiency within discipline. Conducts tasks and assignments as directed. Works with moderate supervision with some latitude for independent judgment. Typically requires four to five years of experience or equivalent education.
Skills
Oracle
PL/SQL
SQL
SQL Server
Android
Similar jobs
Associate Network Engineer - New Grad - Susquehanna International Group
Susquehanna International Group · Bala-Cynwyd, United States
Just nowSoftware Developer Productivity Engineer | HPC | Experienced Hire - Susquehanna International Group
Susquehanna International Group · Bala-Cynwyd, United States
Just nowEducation Coordinator - Susquehanna International Group
Susquehanna International Group · Bala-Cynwyd, United States
Just nowAssociate Network Engineer | Network Services | Experienced Hire - Susquehanna International Group
Susquehanna International Group · Bala-Cynwyd, United States
Just nowMachine Learning Researcher - Susquehanna International Group
Susquehanna International Group · Bala-Cynwyd, United States
Just nowIdentity Management Analyst - New Grad - Susquehanna International Group
Susquehanna International Group · Bala-Cynwyd, United States
Just now