*send resumes to sk...@otsi-usa.com <sk...@otsi-usa.com>* *SQL Server Analysis (SSAS) – OLAP Cubes.*
*Lees Summit, MO.* *12 months contract +* *GC & Citizens Preferred * *Duties and Responsibilities:* · Design, develop, and scheduled deployment of mid-size to large cubes · Provide production support and OLAP maintenance (optimize performance, data integrity, capacity, reliability) · Review MDX from a logical and performance perspective and rewrite from scratch, if necessary · Ability to meet deadlines in a fast paced environment required · Works independently and as a part of a team · Delivery of client focused products (data, reporting and analytics). This includes working with the rest of the technology team to plan product functionality and product releases and product support · Analyze business requirements and translates those into scalable SSAS solutions · Interfaces with end-users who are utilizing PowerPivot, PowerView, PerformancePoint, ReportBuilder, Visual Studio to generate actionable data through dashboards, canned or ad-hoc reports and data mining/analysis. · Installs/upgrades/configures SSAS servers, security, cube refresh schedules, solution deployment, backing up and restoring SSAS databases/cubes. · Works with management team to ensure data security and develop automated, dynamic security implementation routines · Adheres to change management process to resolve application defects or to implement development enhancements and deployments. · Meets with decision makers, subject matter experts, developers/architects and end users to define business requirements and BI goals. *Experience* · Requires a Bachelor’s degree in Computer Systems or related field, additional years of qualifying work experience or relevant technical certification may be considered in lieu of education. · Requires five years of work experience in database administration or systems development, that includes 3 years of MSAS design, development, and deployment experience working with mid-size to large cubes · Hands-on experience with OLAP tuning and partitioning · Must have experience with physical implementation of moderately complex logical OLAP designs. · Excellent understanding of OLAP best practices · Strong analytical skills · Advanced MDX and DAX · Familiarity with fundamental data warehousing concepts *Kind Regards* *Soumya Kota* |Object Technology Solutions, Inc. (OTSI) | 6363 College Blvd., Suite 230 | Overland Park, Kansas 66211 Office: 913-345-9080 Ext 317 | Fax: 913-273-0012 | | sk...@otsi-usa.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.