Business Intelligence Data Modeler - DCF

Job No: 10501WIPosition Business Intelligence Data Modeler Client Name Wisconsin Department of Children and Families (DCF) Requisition Location Madison, WI Duration 6+ months Due Date 07/28/2026 C2C Possible Yes. Rate depends on experience Interview Method Web-based with Camera OnNOTE: WI residency required. Must be WI resident or willing to relocate at your own experience. Mostly remote but can require staff to come onsite as necessary with sufficient notice.

Description

Our client looking for a BI 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). our client is looking for someone with both application and data warehouse database modeling experience.

Tasks

• Develop conceptual, logical, and physical data models for 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.

Knowledge, Skills And Abilities Required

• Excellent organization, analytical, and communication skills

Skills Required

• 5+ years - 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.
• 6+ years - Advanced experience in Oracle PL/SQL
• 5 years - Experience Data analysis
• 5 years - Experience creating and reviewing SQL scripting
• 5 years - Experience with Metadata tools
• 5 years - Experience with Oracle 11g/DB2/SQL Server
• 4 years - Experience with Oracle data dictionary views
• 5 years - Experience with Metadata documentation experience
• 5 years - Experience with data quality assessment and profiling

Skills Desired

• Experience with human services

#J-18808-Ljbffr