Information Technology

Employment TYPE

Contract

LOCATION

Sacramento, California

DATE POSTED

June 2, 2020

INDUSTRY

Information Technology

POSITION(S)

2

SALARY

Negotiable

Job# J675

Data Modeling

About The Opportunity

Note: Local and GC or Citizen candidates preferred.

Job Description

    The scope of this project encompasses the following tasks:
  • 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
  • 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 Cal PERS data modeling/database standards.
  • 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
  • Assist developer teams with answering business-related and data model questions and reviewing SQL to ensure correctness
  • Review daily Database Change Requests for data model structure and CalPERS standards
  • Validate CalPERS business information flow and business rules against dimensional/conceptual/logical/physical models utilizing existing documentation such as use cases and business requirements
  • Work closely with CalPERS BI and Data Modeling teams to develop/design dimensional l models to address different functional business areas reporting needs, such as retirement and health benefits.
  • Administer changes to data models using All fusion\'s 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
  • Mentor CalPERS data modelers on best practices and data modeling tools including All Fusion\'s Erwin and Model Manager
  • Attend project, staff, and management meetings as required

Required Skills

  • Ten (10) years of experience with relational, modeling of complex systems
  • Ten (10) years of pension, health care, actuarial industry experience
  • Seven (7) years of work experience using Erwin Data Modeling Tool.
  • Five (5) years of star schema modeling experience
  • General Software development experience.

Duration

12 Months

Please Contact me to discuss the hiring process!

Sumit Gupta

Sr. Executive Recruiter
Contact: (310) 929-8421 Ext: 104
Email: sumit.gupta@staffactory.com

Hi! My name is Sumit Gupta. I treat all my consultants in a manner that they feel comfortable while working with me on any position they are applying for. Although, the motive is to find the best match for my consultants. But I make sure that I suggest them the right job matching their profile and work history by interacting with them in detail and follow-up with them at each and every level of the hiring process.