Health Insurance Experience System Development Lifecycle SDLC Project Management F   Requirement id 106190 Job title Developer Job location in Sacramento, CA Skills required Analytical Modeling, Oracle Tools, SQL, Health Insurance Experience System Devel Open Date 28-Apr-2020 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Analytical Modeling, Oracle Tools, SQL, Health Insurance Experience System Devel Note: Email Submission Note: This engagement is for NEW work. Note: Number of Hours: 2000 Note: No More Than 2 Candidates/Per Vendor Submission Deadline: 5/5/2020 5:00 PM PST Start Date: 7/1/2020 End Date: 6/30/2021 Client: California Public Employees Retirement System (CalPERS) Description: C. Project Scope/Tasks The scope of this project encompasses the following tasks: The consultant(s) will assist CalPERS Technology Information and Business Advancement section; including information architects, business architects, security administrators, data modelers, data administrators, data managers, data reporters and team members in understanding the current data from the myCalPERS system and enterprise data warehouse and how it impacts their work moving forward into the future business needs of CalPERS. Using SQL queries with advanced functions and large, complex data models, the consultant(s) will perform data extracting, transforming and validating. The consultant(s) will also develop dimensional data models, develop semantic data layers, or transformational solutions for the Data & Analytics team. The consultant(s) will be required to work under the direction the CalPERS Enterprise Analytics & Data Services Manager and closely with other ITSB technical managers and team members. In addition, the consultants will provide mentoring to CalPERS staff. The scope of this project encompasses the following tasks: 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 Work closely with CalPERS Data & Analytics team (DnA) and develop SQL to provide data extracts and to validate data for these extracts for Public Records Act requests, Employer Data Requests and internal business data requests Validate CalPERS business information flow and business rules against dimensional/conceptual/logical/physical models utilizing existing documentation such as use cases and business requirements Work closely with CalPERS teams to develop/design dimensional models and sematic layers to address different functional business areas reporting needs, such as retirement and health benefits. Provide feedback to the CalPERS data validation team and ensure that they are capturing the correct and complete requirements Review CalPERS data validation team data findings and provide feedback and fix transformation logic as necessary Mentor CalPERS data engineers and DnA team members on best practices Attend project, staff, and management meetings as required Record work hours daily in required time tracking tools Submit monthly status report with invoices   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 106190 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), Analytical Modeling job openings in Sacramento, CA Jobs List CalPERS (BI) Data Engineering -SP Create date: 05-Jun-2017 Submission Instructions : 6/9/2017 12:00 PM 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 support for the organizations.... (This job is for - Business Intelligence Jobs in CA Sacramento Engineer - (in Sacramento, CA)) Data Engineering - Sr Technical Specialist - SP Create date: 30-Apr-2015 [ NOTE : SUBMISSION DEADLINE - 5/05/2015 05:00 PM] [ NOTE : PROJECT START DATE - 7/01/2015 END DATE - 12/31/2015 ] [Client : Technology Innovation and Strategic Services (TISS) ] *Description: The California Public Employees Retirement System (CalPERS) Technology Innovation and Strat.... (This job is for - job Jobs in CA Sacramento Developer - (in Sacramento, CA))         (Developer: Analytical Modeling, Oracle Tools, SQL, Health Insurance Experience System Devel in Sacramento, CA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)