Data Modeling Tools BI Data Integration Specialist Application Design Relational M   Requirement id 68908 Job title Specialist Job location in Sacramento, CA Skills required Data Modeling, Healthcare Experience, PL/SQL, Data Modeling Tools BI Data Integration Open Date 06-Apr-2018 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Specialist: Data Modeling, Healthcare Experience, PL/SQL, Data Modeling Tools BI Data Integration Notes: CalPERS is seeking 2 resources (1,850 hours each) (MAXIMUM 2 RESPONSE PER VENDOR) Submission deadline: 4/12/2018 5.00 PM Start date: 7/1/2018 End date: 6/30/2019 Client: CalPERS Description: The contractor should submit their resources under the vertical and classification in which they have a contract award and where their resource best meets the minimum qualifications. 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 Standard Agreement Number: 2015-XXXX Exhibit 1 Page 3 of 8 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 with relational modeling of complex systems • At least five (5) years maintaining data models using data modeling tools (Erwin and Model Manager preferred) • At least ten (10) years of pension and health care industry experience • At least five (5) years experience with complex PL/SQL • At least five (5) years experience performing tasks pertaining to the analysis, design, development, testing, and implementation of data conversions, reports, data audits and data fixes. • At least two (5) years experience with dimensional modeling of an enterprise data warehouse • At least three (5) years of said experience must have been on a project(s) with a budget of at least $15 million   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 68908 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), Data Modeling job openings in Sacramento, CA Jobs List CalPERS DB LOE 2023-0562 Senior Test Specialist -SP Create date: 06-Apr-2023 Bid URL: https://mail.google.com/mail/u/1/#inbox/WhctKKXwsmLnxQdpQgBcHwkCldBjjjBDFtkChKtmNrmJvhRTfbgKWtRKlXJFWljrccRbzqV Note: Email Submission Note: Senior Test Specialist Submission Deadline: 4/19/2023 5:00 PM Start Date: 7/3/2023 End Date: 7/2/2024 Client: California Public Employees Retirement Sys.... (This job is for - job Jobs in CA Sacramento Specialist - (in Sacramento, CA))    Data Modeling job openings in other states Jobs List VDOT Program Manager - Business Data Management (728400) Create date: 01-Feb-2024 Hybrid Start date :01/29/2024 End Date : 06/30/2024 Submission deadline : 2/6/2024 Client Info : VDOT Description : ------------------------------------------------------ **Long-Term position requires occasional onsite at 1401 East Broad Street, Richmond VA to be determined by mgr Data Architect Business Analyst Jobs in VA Richmond Manager - (in Richmond, VA)) Business Intel Data Modeler III - 125057 Create date: 01-Dec-2023 Start date : 01/15/2024 End date : 06/30/2024 Submission deadline : Friday, December 8th at 4:00PM CST. Client info : DCF Note : * INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be .... (This job is for - job Jobs in WI Madison Modeler - (in Madison, WI)) Data Warehouse Architect 3 - 124057 Create date: 03-Nov-2023 Start date : 11/28/2023 End Date : 06/30/2024 Submission deadline : 11/10/23 at 10am EST Client Info : MSP Note : * Interview Process: Interviews will be held in person - candidates must be able to attend an in-person interview. * Duration: Through 6/30/2024 - Extension likely ETL Jobs in MI Dimondale Architect - (in Dimondale, MI)) NJAOC SC 1-PEGA SSA (717131) Create date: 02-Aug-2023 Start date :08/20/2023 End Date :09/27/2023 Submission deadline :8/7/2023 Client Info :Judiciary Note: Hybrid Description : Position is remote or hybrid depending on candidates location.. Local candidates will be asked to come into the office for meetings each month. This will b.... (This job is for - Pega Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJAOC Senior Consultant 1-PEGA SSA- UI/UX (714353) Create date: 27-Jul-2023 Hybrid Start date :07/30/2023 End Date :06/29/2024 Submission deadline :8/2/2023 Client Info :Judiciary Description : ------------------------------------------------------ Note:This is a Hybrid role requiring 2 Days / Week Onsite with the team. MINIMUM of 5 years Post PEGA.... (This job is for - Pega Jobs in NJ Trenton Consultant - (in Trenton, NJ))    Data Modeling job openings in CA Jobs List Sr. Data Architect - 55987 Create date: 21-Nov-2019 We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen. JOB DESCRIPTION Responsible to plan, design, develop and maintain the data architecture, data models and standards for various Data Integration projects in RSD. Ensure new features and subject areas are modeled to integrate with existing structures and.... (This job is for - ERwin AWS Jobs in CA NewportBeach Architect - (in Newport Beach, CA)) Mobile Software Developer - 55316 Create date: 06-Nov-2019 Candidate must be our W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Candidates RTR form should be only on the name of APEX Systems Job Description : Software Developer 6-9 month contract with ability to extend Redwood City, CA job Jobs in CA RedwoodCity Developer - (in Redwood City, CA)) Insights Analyst - 54211 Create date: 17-Oct-2019 Candidate must be our W2 Employee Notes : - 6+ years of reporting, analytics or data modeling - 4 years Python / R - A quantitative background (more mathematics, economics, business driven) - NLP, Text Analytics Description: Were looking for talented people who will put our cust.... (This job is for - ReportingPython Jobs in CA SanFrancisco Analyst - (in San Francisco, CA)) IT - Applications Development Consultant Specialized - 48865 Create date: 20-Jun-2019 Description: Working with an agile development team with approximately 5-7 resources consisting of software engineers, PO and a Scrum Master Responsibilities for this position: · Responsible for end to end application development including Frontend, Backend, Batch, DevOps and Data Modelling in a cloud environment .... (This job is for - DevOpsAgile Jobs in CA SantaAna Consultant - (in Santa Ana, CA)) Information Architect - 41496 Create date: 18-Dec-2018 Job Description : Project Specific Tasks/Deliverables: Design high performing, scalable, Enterprise Data Warehouse, using both Kimball & Inmon methodologies in conjunction with utilization of a multi-platform, modern architecture approach. Collaborate with the stakeholders and build solutions that support their reporting, analytics,.... (This job is for - OLAP Jobs in CA SanJose Architect - (in San Jose, CA)) (Specialist: Data Modeling, Healthcare Experience, PL/SQL, Data Modeling Tools BI Data Integration in Sacramento, CA)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)