About Strategic Systems

Strategic Systems is a staffing and recruiting company.

company website →

Enterprise Data Warehouse(EDW)← All Jobs

2020-01-17 | Columbus, OH | DOE | Not Applicable Contract


Description

Because facilitation is essential to modeling, expert communication skills will be required.
 Minimum 5 years’ Experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehousing environments
 Minimum 5 years’ Experience with design, development and support of normalized data structures (commonly referred to as Inmon)
 Minimum 5 years’ Experience with Kimball (Dimensional Modeling) and Inmon methodologies
 Minimum 5 years’ experience with modeling tools (e.g. CA Erwin) including Model Mart Repository advanced features (e.g. check in/out, complete compare, naming standards and reverse engineering)
 Minimum 5 years’ Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another
 Minimum 5 years’ Experience with Data Warehouse tools and techniques (ETL tools, STAR schemas, etc.)
 Minimum 5 years’ Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design
 Minimum 5 years Strong Data Modeling skills to include data quality, source systems analysis (DB2, Oracle, VSAM, etc.) business rules validation, source to target mapping design, prepare sample data example and data validation with ETL team (SCD 1, SCD 2 types tables and Fact tables)
 Ability to establish and maintain positive collaborative relationships with team members.
Nice to Have:
 Experience with Alternative Modeling (Data Vault, Anchor Modeling, Focal Point, etc.)
 Experience with Big Data (Hadoop) platforms
 Experience with Agile approaches such as Business Event Analysis and Modeling
Education Required

 Four-year college degree in Computer Science or similar form of study
Schedule:

 Normal business hours (between 8:00 AM and 5:00 PM) Monday through Friday, 40 hours a week
 All services are completed in-house. Remote work not available.
 Service location: 30 W. Spring St., Columbus, OH 43215


Share:

Apply
Your Name here
Your Email Address
Enter your message to the company explaining why you are a fit for this job
Please use Microsoft Word format


Similar Jobs: