SAS EBI/SAS Administration Opportunity, San Francisco, CA
Candidate will be onsite for a minimum of a six weeks with possible remote work after that. We are looking for a candidate to fill a position in San Francisco, CA. This is for a 3-6 month opportunity. Rate : $70/hr DESCRIPTION: The role is SAS EBI with SAS Administration and Data Integration using SAS Code, naming PROC SQL. The EBI reports are basically all OLAP cube being created using OLAP Studio and being surfaced within EG and AMO. Eventually they will want to move this over to IMS, WRS and the Portal, but for now it will stay in EG and SAS Addin for Micorsoft Office (Excel specifically). All the data resides in a MYSQL database and they are using Access to MYSQL to get at the data. Data is pulled from MYSQL into SAS tables using SAS coding, specifically PROC SQL. For this engagement explicit pass-through to MYSQL will be important to ensure that the RDBMS is doing most of the work for the query. Below is a more detailed bullet pointed list of skillsets. The environment is a single tier LINUX installation. All data is located within MYSQL databases and they use ACCESS/MYSQL to pull extracts and refreshes of OLAP Base Tables. From the OLAP base tables OLAP Cube Studio is being used to create the cubes. REQUIRED SKILLS: • OLAP Studio o Dimensions, Hierarchies o Measures o Computed Members o Aggregations o ARM Logging and performance tuning o ROLAP as well as OLAP • Data Integration through coding (No DI Studio) o Ability to efficiently write MYSQL pass-through coding to ensure RDBMS-side processing. o Create wide base table with appropriate numerical and character variables that can be rolled up within a cube structure with dimensions and hierarchies. • Knowledge of EG (cubes will be viewed by EG) • Knowledge of AMO (cubes will be viewed in SAS AMO/Excel) • Web Report Studio (Eventual need) • Information Map Studio (Eventual need) • Information Delivery Portal (Eventual need) • SAS Management Console o Users/groups o ACTs o SAS Folders o OLAP Member Level Permissions / Authorizations o Security architecture • SAS Roles and Capabilities for both EG and AMO Essential duties & responsibilities: The BI Product Manager/Analyst will be the primary owner of customer’s SAS implementation and will be responsible for executing customer’s SAS project roadmap and supporting customer in its adoption of SAS in making data-driven decisions with its online and offline data. ROADMAP, REPORTING AND ANALYSIS Develop and monitor monthly and weekly standardized reports, publish analysis, lead cross-departmental analysis meetings and execution of actionable insights Develop and maintain well-structured data sources and cubes Develop the capacity to merge online activity with offline business results (closed loop reporting) Manage the BI roadmap through the capture, prioritization, and execution of Customer's reporting projects and SAS infrastructure enhancements Project manage and lead reporting projects, coordinate efforts of external resources when needed Meet and partner with stakeholders – Product, Compliance, Marketing, Bus Dev, Fraud, Customer Operations - in defining and designing reusable reports and data models that meet business objectives Collaborate with stakeholders on analysis projects which could range from deep dives on standardized reports to specific and customized ad hoc requests Function as a trusted advisor to stakeholders GOVERNANCE Support governance by defining process, standards, and documentation for Customer’s SAS implementation Ensure a clean, high quality, well-documented SAS implementation, lead calibration efforts to explain any discrepancies Author functional specs to define Customer KPIs, reporting initiatives, and reporting needs, develop project plans, build out reports to the specification, draft technical spec if appropriate, and update implementation documentation accordingly Elevate the organization’s analytics aptitude by providing analytics education and training on tools and methodologies, enable self-serve access where appropriate Skill requirements: Project management experience with both business stakeholders and technical partners Excellent written and verbal communication skills Experience with setting the vision and managing, prioritizing and executing a roadmap Experience with SAS and data architecture Experience with writing and maintaining functional and technical specifications and implementation documentation, ability to design reports to solve business problems Strong attention to detail with the drive to ensure accurate results Fluent in SAS Enterprise Guide, familiarity with new functionality released in EG 4.3 a big plus Fluent in SQL, experience with Base SAS Experience with the administration and configuration of SAS Metadata and the configuration of email and reporting options Self-motivated with the ability to work independently, but able to solicit and incorporate input from others when needed Education requirements: • MS or BS in computer science or related field or equivalent knowledge and experience Thanks, Archana Kulkarni (Archie) MetaSense, Inc. NJ Minority Certified Company 100 Technology Way, Suite 320 Mt. Laurel, NJ 08054 856-873-9950 (Ext.130) 856-282-7272 (Cell) Fax: (856) 475-0555 arc...@metasenseusa.com www.metasenseusa.com <http://www.metasenseusa.com/> MetaSense Inc. is a Professional Services, Staff Augmentation, Web Design, Call Center, BPO Company with offices located in Mt. Laurel, NJ. MetaSense specializes in the delivery of cost effective, high-value Information Technology and Business Solutions since its inception in 1999. P Go Green! Print this email only when necessary. -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to sapbrains@googlegroups.com To unsubscribe from this group, send email to sapbrains-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en
