·At least eight (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.
·At least eight (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
·At least eight (8) years of experience demonstrating
understanding of SDLC methodologies specific to requirements elicitation and
analysis, participating in joint application design sessions with the business
users to analyze existing or future business processes, preparing business
process workflows, business use cases, logical data models, and user interface
design for reports and associated functionality.
·At least eight (8) years of experience working with
Microsoft products/tools such as Power BI, SQL Server versions 2008, 2012 and
2016, SQL Server Reporting Services, etc. This experience should include
monitoring the performance of reports and taking corrective action to optimize
or improve the performance of the reports when necessary.
Desirable Technical Qualifications:
It is desirable for the proposed project personnel to
have the following listed experience, knowledge, skills and abilities as
evidenced by Attachment II, Proposed Project Personnel Skill Summary Sheet and
·Experience developing SQL Reports as part of the data
integration solution for a Pension Administration System.
·Experience in the field of Data Integration, Data
Conversion, and ETL.
·Experience with source code management software, such
as (Team Foundation Server) TFS.
·Experience producing and assisting in the creation of
the following documents: Reports Specification document, data dictionary,
reporting tool/platform architecture, test scenarios and test cases for reports
·Strong understanding of SQL Server Replication
Services and experienced in setting up replication between a single source and
·Experience in working with tables with a large number
of records and creating test data sets for testing the reports.
·Strong understanding of SQL Server Reporting Services
Security Model and integration with Microsoft Active Directory and SharePoint
·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.