Description

You design and develop complex reports and manage data conversion tasks involving CEI to PEI file transitions.

This role is on-site.

Responsibilities

• Design and develop reports using SQL within SSRS and SSIS environments.
• Convert end-of-life CEI files from the Comptroller’s Office into PEI formats.
• Build front-end reporting solutions featuring dynamic grouping, sorting, drill-down, and cross-tab reports.
• Access and extract data from SQL Server, Oracle, and BD2 database management systems.
• Manipulate large data sets using statistical software or other data manipulation methods.

Required Skills

• 5+ years of experience in report writing and data analysis.
• Proficiency in SQL Server, SSIS, and SSRS.
• Experience working with Oracle and BD2 database systems.
• Advanced Excel skills including pivot tables, conditional formulas, formatting, and VLOOKUPs.
• Ability to create on-demand sub-reports and summary reports.
• Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, and Outlook).

Preferred Skills

• Bachelor's degree or equivalent graduate level education.

Key Skills

Education

Any Gradute