*Data Modeler at SACRAMENTO, California* PLEASE SEND MATCHING RESUMES TO [email protected] OR [email protected]
Data Modeler SACRAMENTO, California 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 for actuarial related work. 2. Work with other business and technical teams to design, create and enhance logical/physical data models for actuarial services but take into consideration its interconnections with retirement benefits, health benefits, financials and others. Ensure new models and changes fit in with the overall functionality of the data model and meet the CalPERS data modeling/database standards 3. Provide overview of Actuarial Valuation System 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 ACTO programmers with answering business-related and data model questions and reviewing SQL to ensure correctness 5. Validate CalPERS business information flow and business rules against dimensional/conceptual/logical/physical models utilizing existing documentation such as use cases and business requirements 6. 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 7. Mentor CalPERS data modelers on all work done related to Actuarial services including the use of the data modeling tools 8. Attend project, staff, and management meetings as required 9. Record work hours daily in required time tracking tools 10.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 (Allfusion Erwin and Model Manager preferred) At least five (5) years of actuarial data modeling experience At least five (5) 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 five (5) years experience with dimensional modeling of an enterprise data warehouse At least five (5) years of said experience must have been on a project(s) with a budget of at least $15 million Thanks & Regards Shailesh Swarky Solutions, MN [email protected] -- You received this message because you are subscribed to the Google Groups "Companies Looking for IT Out Staffing & Recruitment" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/arunsinh. For more options, visit https://groups.google.com/d/optout.
