*Role: Sr. Level Data Modeler* *Location: Salt Lake City, Utah*
*Duration: 12 Months, extendable* *Rate: $75/HR C2C * *Top 3 Skills:* *1. Enterprise Data Modeling * *2. Experience Building Operation Data Stores* *3. Modeling tools such as ERWIN or ER Studio* *Background and Expertise Required To Accomplish The Job:* * Required: - 6+ years of total IT experience - 2+ years’ experience with specific responsibility for modeling business intelligence within data warehouse or operational data store environments* - Expert data modeling skills (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts) - Expert knowledge in SQL - Expert knowledge of relational and dimensional database design concepts - Good understanding of both database and system performance tuning - Good understanding of how Change Data Capture (CDC) can be leveraged efficiently load data into an ODS. - Good understanding of the MPP databases with their related utilities and tools - Familiarity with industry standard modeling tools. E/R Studio is a plus - Good understanding in Unix programming (Korn Shell, C Shell, Bourne Shell, etc.) and the underlying operating system is a plus - Good understanding of database security management - Good facilitation skills to engage subject matter experts - Good background in database design and lifecycle management - Knowledge of database loading methods - Knowledge of one or more of the leading database platforms ( i.e. Oracle, Netezza and Teradata are preferred) - Knowledge of all phases of the system development life cycle - Strong problem resolution skills - Strong testing and debugging skills - Strong communication and interpersonal skills - Demonstrated ability to take ownership & responsibility for development and maintenance projects *Job Responsibilities:* Perform Business Requirement Analysis: » Interact with Business Analysts to obtain data and functional requirements » Interact with business users and find out the reporting needs » Conduct interviews, brain storming discussions with project team to get additional requirements » Gather accurate data by performing data and functional analysis. Perform Development of data models: » Create and document conceptual, logical and physical data models. » Communicate physical database designs to Data Warehouse Administrators. Reports: » Generate data model reports and diagrams. Review: » Review the data models with business and technical teams. Creation of database: » Create SQL code from data model and coordinate with DBAs to create database. » Insure that data models and databases are in synch. Support & Maintenance: » Assist developers, ETL, BI team and end users to understand the data model. » Maintain change log for each data model. » Establish and enforce overall modeling standards, guidelines, best practices, techniques and approaches. » Assist with the development of project estimates, plans, and schedules. » Communicate effectively with business and IT staff across functional departments » Evolves models to meet new and changing business requirements » Participate in data integration, information management programs and projects » Translate client user requirements into technical architecture vision and implementation plans. » Performs other duties, as assigned. *Regards,* *Rahman, * *Sr Resource Recruiter* *rahm...@usmsystems.com <rahm...@usmsystems.com>* *703 246 1849* -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
