Description

<< Back to all jobs

SSIS/SSRS Report Writer - Austin, TX (On-site)

[Austin, TX, 78752] |   2023-02-07 13:29:25

Apply Now

Share Job 

Job Code : 2023-MY3TECH0056

Urgent Requirement: 

Job Title: SSIS/SSRS Report Writer

Job Location: Austin, TX (On-site)

Duration: 6-month Contract with possibility to extension


Job Description:

  • 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.

 

Candidate skills and qualifications:

YearsRequired/PreferredExperience
4RequiredExperience writing SQL reports that access data stored in databases such as SQL Server, DB2, and Oracle.
2Requiredexperience in developing procedures and views on SQL Server and Oracle databases
2RequiredExperience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating crosstab reports highlighting key summary information.
1RequiredExperience manipulating large data sets through statistical software or other methods.
1RequiredStrong functional expertise developing front-end reporting solutions.
1RequiredMicrosoft 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.
1RequiredConsiderable knowledge with SQL, Python, or similar language.
1PreferredGraduation from an accredited four-year college or university with major course work in Computer Science, Statistics, MIS, IST or a related field.

Education

Any Graduate