PLSQL Data Conversion Reports Data Audits Data Fixes Dimensional Modeling Data War   Requirement id 61262 Job title Specialist Job location in Sacramento, CA Skills required Pension And Health Care Industry Experience, Relational Data Modeling, Data Modeling Tools, PLSQL Data Conversion Reports Data Audit Open Date 25-May-2017 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Specialist: Pension And Health Care Industry Experience, Relational Data Modeling, Data Modeling Tools, PLSQL Data Conversion Reports Data Audit Submission Deadline : 6/2/2017 10:00 am Client : California Public Employees Retirement System (CalPERS) Description : The California Public Employees Retirement System (CalPERS) Technology Business Management Division (TBMD) has requested assistance from Contractor Name to provide analytical support to develop, maintain and execute the Data Reporting Service Request process leveraging ITSBs service request/fulfillment tool, and support the administration of the Cognos Reporting tool for ad-hoc and service-metric report authors within the business areas. KNOWLEDGE TRANSFER While this is not a multi-year contract, thus not subject to the Knowledge Transfer requirements, this LOE is knowledge transfer-centric. Contractor will document all work products relating to the development and maintenance of the Cognos reports and packages including, but not exclusively, requirements, specifications/layouts, design, operations, user contacts and methodology. Contractor will draft a checklist of transition activities, timelines and methodology for the Data Reporting managers review and approval. Once approved, contractor will engage with CalPERS State staff to execute on transition activities including, not exclusively, job shadowing and hands-on training sessions. PROJECT SCOPE/TASKS The scope of this project encompasses the following tasks: 1. Participate in functional requirements gathering as needed and provide quality assurance of analysis completed by staff such as use cases, designs and design documents, or testing deliverables 2. Work with application design team to design, create and enhance logical/physical data models for different functional business areas, such as retirement benefits, health benefits, and financials. Ensure changes fit in with the overall functionality of the data model and meet the CalPERS data modeling/database standards 3. Provide overview of logical and physical data models to CalPERS staff, including information architects, business architects, security administrators, data modelers, data administrators, data managers, data reporters and Business Intelligence (BI) staff 4. Assist developer teams with answering business-related and data model questions and reviewing SQL to ensure correctness 5. Review daily Database Change Requests for data model structure and CalPERS standards 6. Validate CalPERS business information flow and business rules against dimensional/conceptual/logical/physical models utilizing existing documentation such as use cases and business requirements 7. Work closely with CalPERS BI and Data Modeling teams to develop/design dimensional models to address different functional business areas reporting needs, such as retirement and health benefits. 8. Administer changes to data models using Allfusions ERwin modeling tool; including developing and maintaining data dictionaries used to describe the data models and their support of the system and making structural changes to the data model 9. Work with CalPERS data integration team members to define rules to load and transform data into the BI star schema 10. Provide feedback to the CalPERS BI data validation team and ensure that they are capturing the correct and complete requirements 11. Review CalPERS BI data validation team data findings and provide feedback and fix transformation logic as necessary 12. Mentor CalPERS data modelers on best practices and data modeling tools including AllFusions Erwin and Model Manager 13. Attend project, staff, and management meetings as required 14. Record work hours daily in required time tracking tools 15. Submit monthly status report with invoices DESIRED QUALIFICATIONS It is desired that candidates possess the following qualifications: • At least five (5) years experience   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 61262 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),         (Specialist: Pension And Health Care Industry Experience, Relational Data Modeling, Data Modeling Tools, PLSQL Data Conversion Reports Data Audit in Sacramento, CA)

Featured Jobs IT Consultant (Jobs in Madison, Wisconsin) Written Analyst (Jobs in Madison, Wisconsin) MS Manager (Jobs in Richmond, Virginia) Help Desk SharePoint Strong Consultant (Jobs in Madison, Wisconsin) Canvas Developer (Jobs in Glen Allen, Virginia) Snowflake AWS Consultant (Jobs in Atlanta, Georgia) Quality Assurance Technical Engineer (Jobs in Madison, Wisconsin) Vendor Manager (Jobs in Des Moines, Iowa) Written Tester (Jobs in Dauphin County, Pennsylvania) AWS Tester (Jobs in Little Rock, Arkansas)