Onsite /Local SSIS/SSRS Developer with SQL server, DB2, Oracle database

Job ID: TX-23R0007917 (99090209)
Onsite /Local SSIS/SSRS Developer with SQL server, DB2, Oracle database

Location: Austin, TX ( TDPS)
Duration: 6 months

Skills:
CANDIDATE SKILLS AND QUALIFICATIONS

Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
4 Required Experience writing SQL reports that access data stored in databases such as SQL Server, DB2, and Oracle.
2 Required experience in developing procedures and views on SQL Server and Oracle databases
2 Required Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating crosstab reports highlighting key summary information.
1 Required Experience manipulating large data sets through statistical software or other methods.
1 Required Strong functional expertise developing front-end reporting solutions.
1 Required Microsoft Office Suite (Word, Excel, PowerPoint, and Outlook). With considerable knowledge in Excel, including creating pivot tables, conditional formulas and formatting, VLOOKUPS, etc. Able to learn new software/systems.
1 Required Considerable knowledge with SQL, Python, or similar language.
1 Preferred Graduation from an accredited four-year college or university with major course work in Computer Science, Statistics, MIS, IST or a related field.

Description:

Texas Department of Public Safety requires the services of 1 Data Analyst/Report Writer 2, hereafter referred to as Candidate(s), who meets the general qualifications of Data Analyst/Report Writer 2, Data/Database Administration and the specifications outlined in this document for the Texas Department of Public Safety.

All work products resulting from the project shall be considered “works made for hire” and are the property of the Texas Department of Public Safety and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Department of Public Safety will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

A SSIS/SSRS Report Writer for analysis and research data work involving complex systems and design and develop reports utilizing SQL in SSRS and SSIS. This position will be focused end of life CEI file provided from the Comptroller’s Office (CPA) and converting to PEI file.

Must have the ability to access data stored in a variety of database management systems such as BD2, SQL Server and Oracle.

Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating cross tab reports highlighting key summary information.

Manipulate large data sets through statistical software or other methods. Strong functional expertise developing front-end reporting solutions.

Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, and Outlook). Able to learn new software/systems. Considerable knowledge of Excel, including creating pivot tables, conditional formulas and formatting, VLOOKUPS, etc.

TX-23R0007917

Leave a Reply

Search

Categories

Archives

Tags

There’s no content to show here yet.

Discover more from innoSoul:

Subscribe now to keep reading and get access to the full archive.

Continue reading