IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.
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.
NOTE: 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.
Contract: 6+ months
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 – A plus to have
· Experience with human services
*** Rate depends on experience
*** Candidates authorized to work in the US are encouraged to apply. We can accept H1B, TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time.
*** Companies submitting candidates should only submit direct W2 employees for this position.
Please submit your resume by using the URL below
Never miss an opportunity! Create an alert based on the job you applied for.
