Business Intel Data Modeler II
V-Soft Consulting Inc.
Madison, United States of America
yesterday
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Madison, United States of America
Tech stack
Data analysis
Profiling
Databases
Data Profiling
Data Structures
Data Warehousing
IBM DB2
Database Design
Metadata
Meta-Data Management
Microsoft SQL Server
Oracle
Oracle SQL Developer
Oracle Warehouse Builder
Reverse Engineering
SQL Databases
Physical Data Models
Requirements
- Conceptual, Logical & Physical Data Modeling - 5+ years
- Database Design & Database Object Creation - 5+ years
- ERwin Data Modeling Tool - 5+ years
- Oracle PL/SQL Development - 6+ years
- SQL Scripting (Create & Review) - 5+ years
- Reverse Engineering Data Structures & Metadata Development - 5+ years
- Metadata Documentation & Metadata Tools - 5+ years
- Data Analysis, Data Quality Assessment & Profiling - 5+ years
- Oracle 11g / DB2 / SQL Server - 5+ years
- Oracle Data Dictionary Views - 4+ years
- Excellent Analytical, Organizational & Communication Skills
- Preferred: Experience with Human Services domain
Knowledge and Skills:
- Design and maintain conceptual, logical, and physical data models for both application and data warehouse environments.
- Develop and maintain database objects and perform database design activities.
- Use ERwin for data modeling and documentation.
- Reverse engineer existing databases and develop metadata documentation.
- Write, optimize, and review Oracle PL/SQL and SQL scripts.
- Perform data profiling, quality assessment, and metadata management.
- Work with Oracle 11g, DB2, and SQL Server databases.
- Utilize Oracle data dictionary views for analysis and documentation.
About the company
V-Soft Consulting is currently hiring for a Business Intel Data Modeler II for our premier client in Madison, Wisconsin., V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.
As a valued V-Soft Consultant, you're eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.