Data Modeler/Business Intelligence Columbus, OH - Candidate MUST Be LOCAL to OH
6-12 Months Contract *Kindly Reply on: lisa.d...@itbtalent.com <lisa.d...@itbtalent.com> * Candidate will have to interview in person. Required Skills Most importantly the candidate must be proficient in data modeling/designing dimensional/starschema 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 the AllFusion Erwin 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 Warehouseing environments Minimum 10 years Experience with design, development and support of normalized data structures (commonly referred to as Inmon) Minimum 7 years Experience developing Data Warehouse databases using Oracle RDBMS platform and tools Minimum 5 years Experience with Kimball (Dimensional Modeling) and Inmon methodologies 5 years experience with the AllFusion Erwin modeling tool (7.3, 8 and 9.0.0), 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) Minimum 5 years Software development experience with Oracle RDBMS 11g/12c, DB2, and/or Vertica Minimum 5 years Software development experience with SQL Minimum 3 years Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint, Visio, Clarity) Minimum 1 years Experience performing peer reviews Minimum 4 years Ability to effectively communicate with business and IT staff Minimum 1 years Ability to quickly adapt to changes, enhancements, and new technologies Minimum 2 years Ability to establish and maintain positive collaborative relationships with team members Minimum 2 years High energy levels and tolerance for tight deadlines and time pressures Nice to Have: Experience with Alternative Modeling (Data Vault, Anchor Modeling, Focal Point, etc.) Experience with R Experience with Data Virtualization Technologies *Regards,* *Lisa DuttDesk No # 609-935-3773 EXT 102 * * Email : lisa.d...@itbtalent.com <lisa.d...@itbtalent.com>* -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
