*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* *[email protected] <[email protected]>* *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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
