Tax Data Warehouse Analyst (INFORMATION SYSTEMS ANALYST II, Option A)

at Illinois Department of Innovation & Technology in Springfield, Illinois, United States

Job Description

30% Under administrative direction, serves as a Tax Data Warehouse Analyst for the Department of Innovation & Technology (DoIT) supporting Illinois Department of Revenue (IDOR):
•    Coordinates and conducts complex application development using GenTax and Microsoft SQL programming language for the database design, program design, and the supplied GenTax tools for testing the new processes.
•    Provides application and user support. 
•    Conducts and coordinates in-depth technical research and feasibility studies to determine the best application needs for users. 
•    Confers with users to identify functional and security requirements and to determine application requirements. 
•    Performs system analysis by charting process flow.
•    Performs specification writing, coding, testing, audit trails.
•    Develops control procedures, inputs/outputs, forms design, interactive system procedures. 
•    Prepares testing plans, test scripts, and test data for new or modified programs and SQL code. 
•    Performs testing, ensuring logic paths are tested and other areas of the integrated tax system are not impacted. 
•    Evaluates test results to verify conformance with program objectives. 
•    Performs fine tuning of applications. 
•    Prepares user and operational guidelines, operational manuals and application or system documentation. 
•    Follows DoIT and IDOR adopted system design methodology to ensure the integrity of the section in the GenTax Integrated Tax System meets the required standards of security, efficiency, and scope of the system. 
•    Conducts reviews to ensure the security of federal tax data stored in the GenTax Warehouse.


20% Serves as a mentor and subject matter expert (SME) to GenTax Data Warehouse and Research team members.
•    Provides expertise, guidance, and direction to team members.
•    Provides training/knowledge transfer to team members.
•    Analyzes SQR’s, identifies system changes, and develops integrated work plans and cost benefits.
•    Performs complex systems modification design changes and prepares complex modifications.  


20% Serves as a project technical lead for a full-range major/complex projects including large hardware/software deployments and installation:
•    Independently plans, develops and implements techniques for gathering and interpreting data:
•    Offers technical guidance for staff to follow for completing assignments.
•    Interprets and explains policies and procedures.
•    Monitors project/team work to ensure quality assurance and control measures are applied.


10% Serves as the primary support for scheduled and remedial maintenance to the assigned applications:
•    Schedules processes, reviews history of processed jobs and responds appropriately to any abnormal completion status:
•    Provides status reports to management.

10% Keeps abreast of new developments in the Information Technology field:
•    Continues education by attending meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
•    Attends demonstrations and exhibitions related to assigned operations

5% Analyzes and recommends new procedures and techniques to improve the supported application systems: 
•    Adheres to adopted methodology standards to ensure the integrity of each system/sub-system during maintenance/enhancement activities


5% Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above.

Copy Link

Job Posting: 11970907

Posted On: Jun 12, 2024

Updated On: Jun 26, 2024

Please Wait ...