Business Intelligence InvestmentFinancial Services ETL Processes Oracle Database 11   Requirement id 107067 Job title Specialist Job location in Sacramento, CA Skills required Data Processing, Business Intelligence, Investment Management, InvestmentFinancial Services ETL Process Open Date 01-Jun-2020 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: Data Processing, Business Intelligence, Investment Management, InvestmentFinancial Services ETL Process Note: Email Submission Note: Vertical: 5.0 Application Development Project Role: Technical Specialist Consultant(s) needed for the Letter of Engagement: One (1) consultant Number of Hours: 2012 hours Submission Deadline: 6/8/2020 5:00 PM PST Start Date: 7/1/2020 End Date: 6/30/2021 Client: California Public Employees Retirement System (CalPERS) Description: Project Scope/Tasks The consultant will develop dimensional models, transformation solutions and provide data integration services. The data integrator role provides technical expertise to perform data integration services that support the data warehouse and reporting. These services include software changes and environment maintenance and operations. This consultant will assist staff with data architecture, modeling, data integration, and metadata modeling, dashboard development for the INVO Enhanced Management Reporting Solution. Reporting needs to be flexible to changes in the organizational structure of the Investment Office to react in a timely manner and to make sound business assumptions in real time. The solution is designed to leverage automation to prevent and limit the amount of manual data manipulation. Specific project releases of the INVO Enhanced Management Reporting development and support that will be developed by the consultant are (a) allocation of branch expenses to assets under management, (b) allocation of external management fees to functional groups, (c) allocation of branch expenses to positions, (d) data quality validation of external billing feeds, (e) data quality validation of State Controllers Office payroll data feeds and the reconciliation of said data with the accounting data feeds, (f) Cost Effectiveness Measurement (CEM) reporting support, (g) FITS integration and (g) maintenance of functionality and features released previously. The software to be used is Oracle Data Integrator 11g. The solution involves multiple external data feeds, rule-based data quality validation checks, master data management and machine learning. The consultant will be required to work under the direction of the CalPERS Enterprise Analytics and Data Services Manager, work closely with ITSB staff and the Investment Finance Services team. The consultant(s) will also maintain technical documentation and provide knowledge transfer to CalPERS technical staff. Minimum Qualifications Vendor must have participated in at least two (2) successful Business Intelligence and/or Analytics projects, one of which with a budget of at least $1 million Must have a minimum of five (5) years experience in electronic data processing systems study, design, and programming; at least three (3) years of said experience shall have included responsibility on a project basis for analyzing operational methods and developing computer programs to meet desired results, at least two (2) years of said experience must have been at a high level both technically and in measure of responsibility. Must have knowledge of electronic computer programming; electronic data processing equipment and its capabilities; principles and techniques of studying work processes for new or revised electronic computer applications; principles of designing methods of processing data; technical report writing; statistical methods. Must have the ability to write complex programs and develop detailed program specifications. Individuals must have participated in at least two (2) successful Business Intelligence and/or Analytics projects, one of which with a budget of at least $1 million At least five (5) years of experience in some or all areas of Pension, Investments/Investment Management or Financial Services At least three (3) years of experience performing tasks pertaining to data integration (ETL) processes to transform disparate source da   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 107067 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 Processing job openings in Sacramento, CA Jobs List CalPERS Vertical 3.0 Senior Technical Specialist/Lead -Sp Create date: 28-Sep-2017 Amendment Note : This email is inform you that the Limitation of Liability provision has been removed from the Letter of Engagement (LOE). The work associated with this LOE shall remain as two times the total Purchase Order Amount including any change orders as set forth in Section 1.11, Limitation of Liability of the contract. Submissi.... (This job is for - job Jobs in CA Sacramento Specialist - (in Sacramento, CA)) CalPERS Vertical 2.0 PM Services Senior Business Analyst -SP Create date: 21-Sep-2017 Submission Deadline : 9/28/2017 2:00 PM Client : California Public Employees Retirement System (CalPERS) Start Date : 10/1/2017 End Date : 06/30/2018 Vertical: 2.0 Program Management Services Classification: Senior Business Analyst or Business Analyst Description : MINIMUM QUALIFI.... (This job is for - job Jobs in CA Sacramento Analyst - (in Sacramento, CA)) LOE-Data Correction Effort Lead Analyst Create date: 27-Jul-2016 The Client my|CalPERS Operational Efficiency initiative has requested assistance from Contractor Name to provide the Management Support Services of a Senior Data Systems Analyst in leading a team of senior data systems analysts in the clean-up of converted CalPERS legacy data and my|CalPERS data quality issues, and the Management Support Services o.... (This job is for - job Jobs in CA Sacramento Analyst - (in Sacramento, CA)) LOE-MyCalPERS Education Center Redesign,Sr. Programmer Create date: 13-Apr-2016 The Client Education Center was initially launched in 2008 as a web-based solution to enable member and employer education through instructor-led or online curriculum. It also allows members to schedule appointments at the CalPERS Regional Office. The application allows CalPERS Staff to manage classes and appointment times, create class rosters and.... (This job is for - job Jobs in CA Sacramento Developer - (in Sacramento, CA)) Environment Support Services - System Analyst - SP Create date: 13-Apr-2015 [ NOTE : SUBMISSION DEADLINE - 4/17/2015, 5:00 PM ] [ NOTE : PROJECT START DATE - 6/1/2015 END DATE - 12/31/2015 ] [Client : Business Application Infrastructure Services Division (BAISD) ] *Description: The California Public Employees Retirement System (CalPERS) Division Business Application I.... (This job is for - job Jobs in CA Sacramento Analyst - (in Sacramento, CA))    Data Processing job openings in other states Jobs List Applications Developer - COBOL - Senior - 62525 Create date: 10-Apr-2024 Start date : 05/06/2024 End Date : 04/30/2026 Submission deadline : 04/19/2024 Client Info : NeOCIO Note : * Position Location : N/A Description : ------------------------------------------------------ This position is for a Batch COBOL Application Developer/Senior fo.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) System Administrator, Int - 61189 Create date: 31-Jul-2023 start date : 08/18/2023 End date : 06/30/2024 submission deadline : 08/11/2023 client info : TN TDA Note : * Position Location : Hybrid Description : The State of Tennessee is seeking a System Administrator to provide .... (This job is for - job Jobs in TN Nashville Administrator - (in Nashville, TN)) Applications Developer - COBOL CICS DB2 - SR - 56933 Create date: 18-Mar-2022 start date:3/28/2022 End date:03/31/2025 submission deadline:03/25/2022 client info : NeOCIO Description: This position is for a Batch COBOL Application Developer/Senior for the State of Nebraska – MMIS System. Under general direction, this position wi.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) Data Processing Operator 3 - 96690 - SP Create date: 09-Dec-2021 start date:1/17/2022 End date:06/30/2022 submission deadline:12/16/2021 4:00:00 PM client info : ITSD Description: Data Processing Operator: • Assist with the documentation, storage, retention, and destruction of paper documents. Quality Assurance Jobs in WI JeffersonCity Consultant - (in Jefferson City, WI)) Doc175041 Job 7640 Business Analyst -Advanced -SP Create date: 27-Aug-2021 Bid URL: http://sourcing.myfloridamarketplace.com/Sourcing/Main/ad/webjumper?passwordadapter=SourcingSupplierUser&username=coolsoft1&itemID=hlu7az.fd&awcharset=UTF-8 Note: Contract Exhibit G - Resume Acknowledgement Form must be submitted Note: Each vendor may submit up to three HIGHLY QUALIFIED candidates. Note: Email or Onlin.... (This job is for - job Jobs in FL Tallahassee Analyst - (in Tallahassee, FL))    Data Processing job openings in CA Jobs List Data Engineer Create date: 30-Jan-2019 Description: We are looking for highly motivated engineers to fulfill our data needs and drive the product quality to thenext level. You will be working closely with a group of talented researchers and engineers on the cuttingedge machine learning technologies. Your responsibilities include data creation, data management,processing pipel.... (This job is for - job Jobs in CA Cupertino Engineer - (in Cupertino, CA)) Sr Systems Software Engineer - 38069 Create date: 30-Aug-2018 Job Description : Definition Under general supervision, the Senior System Software Engineer performs a variety of professional, technical, and analytical duties to support enterprise servers, client/server platforms, and other hardware and software systems. Distinguishing Characteristics Senior Systems So.... (This job is for - job Jobs in CA SanJose Engineer - (in San Jose, CA)) (Specialist: Data Processing, Business Intelligence, Investment Management, InvestmentFinancial Services ETL Process in Sacramento, CA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)