*Title: Dimensional Data Modeler* *Location: Columbus, Ohio*
*Interview Process: Phone and F2F (Candidate must interview with 48 hours of notice)* *Duration: 12+ months* *Work Status: EAD-GC, USC and GC* *Rate: $55/hr* *Job Description: * The client is looking for a candidate with *excellent dimensional data modelling skills and VERY STRONG communication skills*, we s/he will be working closely with the business user to gather requirements. The secondary skill needed is building SSAS CUBEs and SSRS Reports. Candidates should have PROVEN work experience and able to speak to that in the interview. *Description of Duties:* 20% of Total Work Effort: Meet business users to understand and analyze their processes 25% of Total Work Effort: Analyze the data generated by the business process, define the granularity, source to target mapping of the data elements, and create Indexes and Aggregate tables for the data warehouse design and development 30% of Total Work Effort: Lead Data Modeling, System/Data Analysis, Design and Development for Data warehousing environments (the physical modelling using Erwin will be done by the database analyst from ODE). Build Logical Data models (Dimensional & Relational) using concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Our Data Warehouse system resides on an Oracle environment. 5% of Total Work Effort: Assist the ETL developer in populating the data from the transactional system to the data warehouse system. ODE uses Informatica for ETL 10% of Total Work Effort: Create CUBE using Microsoft Analysis Service -- Create dimensions, measures and measure groups. These cubes will source the data from the data warehouse system 10% of Total Work Effort: Create Microsoft SSRS/Train ODE .NET developers in SSRS report creation *Experience Requirements:* • 8-10 years' overall experience in IT • 5-7 years in data warehouse design / maintenance. • 3--5 years' experience in each position skill listed below: • Meeting business users and analyze the requirements for the dimensional purpose. • Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Modelling experience in an Oracle database environment is preferred. • Must have experience in designing dimensional data models/facts from scratch. *Highly recommended but not required skills. 1-2 years' experience in each position skill listed below:* • Building CUBE using Microsoft Analysis Service. • Building reports using Microsoft SSRS *Recommended but not required skills. 1-2 years' experience in each position skill listed below:* • Microsoft SSIS/Informatica for ETL • PL/SQL and/or T-SQL • MDX Queries *Full Legal Name * *Job Title* *Current location* *Total experience* *US Experience* *Phone* *Email * *Skype* *LinkedIn* *Visa Status* *Last 4 digits of SSN* *Resume * *Relocation* *Availability * *Date of Birth (DD/MM/YEAR)* *Year of Graduation/Masters* *Name of the University* *Highest Qualification * *Employer’s Details (If Any)* *Best Regards..**.* *Anshuman* IT Recruiter | OnSpot Serve T: 530-231-4017 Ext- 118 E: [email protected] Hangout : [email protected] 1510 Poole Blvd, Suite 302 Yuba City, CA 95993 * www. <http://www.hanac.us/>onspotserve.com <http://onspotserve.com>* [image: download] <https://www.linkedin.com/home?trk=nav_responsive_tab_home> P *Please consider the environment before printing this e-mail**.* *Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress, this email cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our emails than please reply with a “remove” in the subject line and mention all the email addresses to be removed with an email addresses which might be diverting the email to you.* -- You received this message because you are subscribed to the Google Groups "SAP BASIS" 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 https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.
