Title: Data Analyst/ Report Writer 2

Location: Austin, TX

Duration: Long Term

You may either create a user id and sign up under the arytic link or go in without signing up to access the job/open roles on our Arytic platform.

https://candidate.arytic.com/Ijobdetail/1003050

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.

Required Skills:

• 4 years of experience writing SQL reports that access data stored in databases such as SQL Server, DB2, and Oracle.
• 2 years of experience in developing procedures and views on SQL Server and Oracle databases
• 2 years of experience in 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 year of experience manipulating large data sets through statistical software or other methods.
• 1 year of experience in Strong functional expertise developing front-end reporting solutions.
• 1 year of experience in 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 year of experience in Considerable knowledge with SQL, Python, or similar language.

Preferred Skills:

• 1 year of experience graduation from an accredited four-year college or university with major course work in Computer Science, Statistics, MIS, IST or a related field.