Business Intel Data Modeler II
Job in
Madison, Dane County, Wisconsin, 53703, USA
Listed on 2026-07-24
Listing for:
Novalink Solutions
Full Time
position Listed on 2026-07-24
Job specializations:
-
IT/Tech
Database Administrator, Data Engineering, Data Analyst, Data Warehousing
Job Description & How to Apply Below
Business Intel Data Modeler II
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.
List any special qualifications & years of experience:
- 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
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×