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 Business Intelligence Developer-Data Analytics Strategy Lead Create date: 18-Dec-2024 No of Submissions: 2 Start date : 1/27/2025 End date : 01/23/2026 Submission deadline : 01/03/2025 Client info: CT DAS Note: * Position Location: Remote * Max Rate for this Position is USD 102.50 Per Hour Description: About the Role T.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) Database Analyst - Cloud Solution Analyst Create date: 12-Dec-2024 * Bill Rate: USD 75.00 Per Hour * Max Rate: USD 91.00 Per Hour No of Submissions : 1 Start date : 02/01/2025 End Date : 01/31/2026 Submission deadline : 12/17/2024 Client Info : CO CDPHE Note: * Position Location: Hybrid * Candidate Must Be Lo.... (This job is for - MS SQL Server Jobs in CO Denver Analyst - (in Denver, CO)) SOFTWARE ARCHITECT - CONSULTANT-11434-1 Create date: 29-Oct-2024 No of Submissions : 2 start date : 12/07/2024 submission deadline : 11/5/2024 client info : Department of Health and Human Services Note: Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? A) A video conference interview or in-person interview may be con.... (This job is for - JQuery Jobs in SC Columbia Architect - (in Columbia, SC)) DRC-Programmer 4/ PR 4Replacements (748107) Create date: 30-Sep-2024 No of Submissions : 2 start date :11/11/2024 End date :06/30/2025 submission deadline : 10/03/2024 client info : DRC Note: * AM: Shalaka * A more senior developer is responsible for planning, processing and performing all jobs in an efficient manner with little or no su.... (This job is for - NET FRAMEWORK Jobs in OH Columbus Consultant - (in Columbus, OH)) NC FAST Integration Engineer (743614) Create date: 19-Aug-2024 Hybrid No of Submissions : 1 start date :09/16/2024 End date :09/12/2025 submission deadline : 08/26/2024 client info : NCDHHS-NCFAST Note: * Agency Interview Type: Either Webcam Interview or In Person Description : .... (This job is for - JSON Jobs in NC Durham Engineer - (in Durham, NC))    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 ASP.Net Government Developer (Jobs in Madison, Wisconsin) Manual Consultant (Jobs in Columbus, Ohio) IT Specialist (Jobs in Columbus, Ohio) Batch CMDB Management System Administrator (Jobs in Glen Allen, Virginia) - Architect (Jobs in Richmond, Virginia) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) - Consultant (Jobs in Bismarck, North Dakota)