Data Warehouse Data Modeler Specialist


Columbus, OH

Industry: IT Consulting/Services


11 - 15 years

Posted 250 days ago

  by    Andrew Scott

This job is no longer available.

Job Title: Data Warehouse Data Modeler Specialist

Job Location : Columbus OH

Interview mode: Initial interviews will be conducted over the phone, selected candidates will advance to mandatory onsite interviews


Awarded candidate must undergo and pass a 10-Panel drug screen and complete a thorough background check at the Supplier?s expense. This will include previous work addresses for the last (10) years excluding high school. Confirmation of higher education credentials also required.


Skills/Knowledge :

Most importantly the candidate must be proficient in data modeling/designing dimensional/star-schema data structures including fact tables. To be proficient the candidate should have consistently spent 5 or more years analyzing, designing and modeling star-schema database designs using a data modeling tool/Model Mart repository in a data warehouse environment. 


?         Minimum 10 years Experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehousing environments

?         Minimum 10 years Experience with design, development and support of normalized data structures (commonly referred to as Inmon)

?         Minimum 7years Experience developing Data Warehouse databases using Oracle RDBMS platform and tools

?         Minimum 5years Experience with Kimball (Dimensional Modeling) and Inmon methodologies

?         5years 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 5years Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another Minimum 5years Experience with Data Warehouse tools and techniques (ETL tools, STAR schemas, etc.)

?         Minimum 5years Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design. ? Minimum 5years 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)

?         Minimum 5years Software development experience with Oracle RDBMS11g/12c, DB2, and/or Vertica

?         Minimum 5years Software development experience with SQL

?         Minimum 3years Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint, Visio, Clarity)

?         Minimum 1years Experience performing peer reviews ? Minimum 4years Ability to effectively communicate with business and IT staff

?         Minimum 1years Ability to quickly adapt to changes, enhancements, and new technologies

?         Minimum 2years 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



?         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.