T SQL SSIS SSAS SSRS 2005 Or Greater SQL Queries SDLC Methodology SQL Server Repor   Requirement id 120516 Job title Developer Job location in Sacramento, CA Skills required SQL Reports, Data Models, Data Integration, T SQL SSIS SSAS SSRS 2005 Or Greater SQL Open Date 22-Nov-2021 Close Date Job type Not specified Duration 24 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: SQL Reports, Data Models, Data Integration, T SQL SSIS SSAS SSRS 2005 Or Greater SQL Bid URL: https://caleprocure.ca.gov/event/7920/0000021468 Note: Email Submission Note: CalSTRS will only accept one (1) offer per Vendor. Submission Deadline: 11/29/2021 2:00 PM PST Start Date: 3/1/2022 End Date : 2/28/2023 Client: California State Teachers Retirement Systems (CalSTRS) Description: Minimum Technical Qualifications As of the Offer Due Date, the proposed project person must have the following listed experience, knowledge, skills and abilities, as evidenced by Attachment II, Proposed Project Person Skill Summary Sheet and resume: 1. At least (8) years of experience working as a reports developer creating and fine-tuning SQL reports from data stored in various relational databases. This experience must include experience designing robust Logical Data Models and stewarding the data design of the solution and ensuring alignment with the larger roadmap goals. 2. At least (8) years of experience designing, developing, debugging and supporting complex data integration interfaces and processes (including stored procedures, triggers, tables, user defined functions, views, indexes, relational database models) using various tools and technologies including SSIS, SSAS, SSRS, T-SQL and SQL Server technology. This experience must include full time experience in developing ETL scripts and writing code from data model, dataflow diagram and technical design specifications. 3. At least (8) years of experience developing complex SQL queries; developing detailed SQL reporting specifications; aggregating, analyzing, validating, and/or reconciling data from heterogeneous data sources, e.g. MS SQL Server, XML files, CSV files, text files, etc.). 4. At least (8) years of experience demonstrating understanding of SDLC methodologies specific to requirements elicitation and analysis, analyzing business processes, business process modeling, preparing business use cases, logical data modeling, and user interface design for reports. 5. At least (6) years of experience working with Microsoft products/tools such as Power BI, SQL Server versions 2008, 2012 and 2016, SQL Server Reporting Services, etc. 6. At least (5) years of experience monitoring the performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary. 7. A four-year college degree (Bachelor) in Computer Science, Computer Engineering, or related fields from a government accredited/sanctioned college or university. CalSTRS reserves the right to ask for a copy of the degree. Desirable Technical Qualifications It is desirable for the proposed project person to have the following listed experience, knowledge, skills and abilities as evidenced by Attachment II, Proposed Project Person Skill Summary Sheet and resume: 1. In-depth knowledge and experience of Pension Administration Systems with a strong preference for Pension Products and Solutions. Previous experience with CalSTRS specific Pension Solution System and in-depth knowledge of the Pension Product that is currently being configured and customized for CalSTRS is highly desired. 2. Experience developing SQL Reports as part of the data integration solution for a Pension Administration System. 3. Experience with source code management software, such as TFS (Team Foundation Server). 4. Strong understanding of SQL Server Replication Services and experienced in setting up replication between a single source and multiple targets. 5. Strong understanding of SQL Server Reporting Services Security Model and integration with Microsoft Active Directory and SharePoint Technologies.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 120516 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),    SQL Reports job openings in other states Jobs List SQL Reporting Software Engineer 2 -SP Create date: 09-Oct-2017 Submission Deadline : 10/11/2017 Client : Department of Children and Families Description : * Title: SQL Reporting * Position Category: System Engineering Support * Position: Software Engineer 2 * Duration of Assignment: 250 days * Assignment Location: Hartford CO The agency needs to c.... (This job is for - RDBMS Jobs in CT Hartford Engineer - (in Hartford, CT))     (Developer: SQL Reports, Data Models, Data Integration, T SQL SSIS SSAS SSRS 2005 Or Greater SQL 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)