Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Data Quality Data Fixes SQL Experience Specialist
(Jobs in Sacramento, CA)
 
Requirement id 92045
Job title Specialist
Job location in Sacramento, CA
Skills required Relational Modeling, Healthcare Experience, Erwin Data Modelling Tool, Data Quality Data Fixes SQL Experience
Open Date 06-May-2019
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, Data Quality Data Fixes SQL Experience

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

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

Client: California Public Employees Retirement System (CalPERS)

Description:

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. 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
KNOWLEDGE TRANSFER

Contractor will document all work products relating to the development and maintenance of data models including, but not exclusively, requirements, specifications/layouts, design, operations, user contacts and methodology.

MINIMUM QUALIFICATIONS

Refer to RFP 2014-7354, Section IV, Vertical xx for minimum qualifications required for this engagement.

• At least ten (10) years of experience with relational modeling of complex systems
• At least ten (10) years of pension, health care, actuarial industry experience
• At least seven (7) years of work experience using Erwin Data Modeling Tool
• At least five (5) years of star schema modeling experience

DESIRED QUALIFICATIONS

• Years of Data Analysis, Data Quality, Data Fixes, SQL experience
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 92045 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 2019-0179 Data Modeling-Sr Technical Specialist -SP
Create date: 04-May-2020
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 .... (This job is for - 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, Data Quality Data Fixes SQL Experience 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