Business Intelligence Data Modeler

Overview

Client Name: Wisconsin Department of Children and Families (DCF)

Location: Madison, WI

Duration: 6+ months

NOTE: WI residency required. Must be WI resident or willing to relocate at your own expense. Mostly remote but may require onsite presence with sufficient notice. We can accept H1b, H4, TN and other valid work visas for IT. However we cannot accept OPT or CPT visas at this time.

Our client is 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). The candidate will have both application and data warehouse database modeling experience.

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

• Excellent organization, analytical, and communication skills

• 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