Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Schema Design Software Development Experience Specialist
(Jobs in Sacramento, C
 
Requirement id 106345
Job title Specialist
Job location in Sacramento, CA
Skills required Relational Modeling, Healthcare Experience, Erwin Data Modelling Tool, Schema Design Software Development Exper
Open Date 04-May-2020
Close Date
Job type Not specified
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Specialist: Relational Modeling, Healthcare Experience, Erwin Data Modelling Tool, Schema Design Software Development Exper

Note: Email Submission
Note: This engagement is for NEW work.

Note:
Service Vertical: 4.0 Information Services
Project Role: Senior Technical Specialist
Consultant(s) needed for the Letter of Engagement: Two (2) consultants
Number of Hours: 1800 for each Consultant

Submission Deadline: 5/11/2020 5:00 PM PST
Start Date: 7/1/2020
End Date: 6/30/2021

Client: California Public Employees Retirement System (CalPERS)

Description:

The California Public Employees Retirement System (CalPERS) Technology Business Management Division (TBMD) is engaging in services with Company Name to provide data modeling services to support myCalPERS, AVSRE, Peoplesoft, Learning Management System, etc.

C. 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.
A
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 (Bl) 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 Bl 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. Mentor CalPERS data modelers on best practices and data modeling tools including AllFusions Erwin and Model Manager
10. Attend project, staff, and management meetings as required
11. Record work hours daily in required time tracking tools
12. Submit monthly status report with invoices.

Qualifications
Ten (10) years of experience with relational modelin of com lex s stems
Ten (10) years of pension, health care, actuarial indust ex erience
Seven (7) years of work experience using Erwin Data Modelin Tool.
Five (5) years of star schema modeling ex erience
General Software development experience
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 106345 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),
Relational Modeling job openings in Sacramento, CA
Jobs List

CalPERS Data Modeling - Senior Technical Specialist -SP
Create date: 06-May-2019
Note: CalPERS is seeking two (2) consultant for 1,800 HRS
Note: Maximum of 2 candidates per vendor
Note: Email Submission

Note: Vertical: 4.0 Information Services
Classification: Senior Technical Specialist
Vertical: 5.0 Application Development
Classification: Senior Technical Specialist job Jobs in CA Sacramento Specialist - (in Sacramento, CA))
 
 Relational Modeling job openings in other states
Jobs List

Database Admin Senior (6+ Yrs) - J-10-676-907
Create date: 07-Jun-2012
[**Note : Dead Line : 6/11/2012**]

[Note : Start Date : 06-11-2012
End Date : 12-30-2012]

Description :

1. BASIC PURPOSE. Give a brief statement of the overall principal purpose or function of this position.
Support the development teams, support the production systems, and be responsible for phy.... (This job is for - Oracle Jobs in NC GREENSBORO Administrator - (in Greensboro, NC))
 
 
(Specialist: Relational Modeling, Healthcare Experience, Erwin Data Modelling Tool, Schema Design Software Development Exper in Sacramento, CA)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved