Strategic Systems is a staffing and recruiting company.
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
Four-year college degree in Computer Science or similar form of study
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