Tax Data Warehouse Analyst (Information Systems Analyst II, Option A)

Position Title: INFORMATION SYSTEMS ANALYST II, Option A

Agency : Department of Innovation and Technology

Posting Date: 06/12/2024

Closing Date/Time: 06/26/2024

Salary: $7,491.00-$11,015.00/monthly (Effective 7/1/24)

Job Type: Salaried

County: Sangamon

Number of Vacancies: 1

Plan/BU: RC063

This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.

All applicants who want to be considered for this position MUST apply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.

Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.

Proof of educational coursework is required. Acceptable proof of coursework includes unofficial transcripts, copies of official transcripts, account records (including screenshots) of academic coursework, and any similar documents created by an academic institution.

Posting Identification Number 38464

Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. This position serves as a Tax Data Warehouse Analyst, supporting Illinois Department of Revenue (IDOR). In the Tax Data Warehouse Analyst role, you will coordinate and conduct complex application development using GenTax and Microsoft SQL programming language for the database design, program design, and the supplied GenTax tools for testing new processes. In addition, you will serve as a project technical lead for a full-range projects including large hardware/software deployments and installation while independently planning, developing, and implementing techniques for gathering and interpreting data. If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!

As a State of Illinois employee, you receive a comprehensive benefits package including:

• Competitive Group Insurance benefits including health, life, dental and vision plans.

• Flexible work schedules (when available and dependent upon position)

• 10 -25 days of paid vacation time annually (10 days for first year of state employment)

• 12 days of paid sick time annually which carryover year to year

• 3 paid personal business days per year

• 13-14 paid holidays per year dependent on election years

• 12 weeks of paid parental leave

• Pension plan through the State Employees Retirement System

• Deferred Compensation Program - voluntary supplemental retirement plan

• Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)

• Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility

For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

Essential Functions

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.

Essential Functions Continued

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.

Minimum Qualifications

1.Requires knowledge, skill, and mental development equivalent to four (4) years of college with course work in computer science or directly related fields.

2.Requires three (3) years of professional experience in Application Services or in a related Information Technology field.

Specialized Skills

1.Requires three (3) years of professional application development experience with object-oriented development within GenTax Integrated Tax System and GenTax Tools.

2.Requires three (3) years of professional experience developing code with Microsoft SQL, VB.NET, application programming, database management systems, and business process analysis/systems/analysis and design.

3.Requires three (3) years of professional experience with electronic transfer utilities and handling of Federal Tax Information.

Preferred Qualifications

1.Three (3) years of professional application development experience with object-oriented development within GenTax Integrated Tax System and GenTax Tools.

2.Three (3) years of professional experience developing code with Microsoft SQL, VB.NET, application programming, database management systems, and business process analysis/systems/analysis and design.

3.Three (3) years of professional experience with electronic transfer utilities and handling of Federal Tax Information.

4.Working knowledge of the various parts of the functions contained in the Audit, Collections, Interfaces and Discovery portions of the GenTax System.

5.Ability to coordinate work activities to achieve desired results.

6.Developed verbal and written communication skills to present technical information to others with clarity and precision.

7.Extensive knowledge in development of Object-Oriented Application Design methodology.

Conditions of Employment

NOTE: Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position.

1.Requires the ability to verify identity.

2.Requires employment authorization to accept permanent full-time position with the State of Illinois

3.Requires the ability to pass a position specific, agency required background check.

4.Requires self-disclosure of criminal history.

5.Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone and any other required equipment or devices.

6.Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies, or other industry related topics relevant to job duties.

7.Requires the ability to lift and carry objects or equipment weighing up to 10 pounds. This is considered sedentary work as defined by the U.S. Department of Labor (20 CFR 404.1567(a)). Sedentary work involves lifting no more than 10 pounds at a time and requires occasional lifting, carrying, walking, and standing.

8.Requires ability to pass a tax compliance check.

The conditions of employment listed are incorporated and/or related to any duties included in the position description.

Work Hours: 7:45 AM- 4:15 PM

Work Location: 101 W Jefferson St, Springfield, Illinois, 62702

Agency Contact:

Maddie Beyer

Email: madison.beyer@illinois.gov

Posting Group: Science, Technology, Engineering & Mathematics

This position DOES contain "Specialized Skills" (as that term is used in CBAs).

The Department of Innovation & Technology (DolT) is the state's IT agency delivering an enterprise approach to statewide technology, innovation, and telecommunication services, as well as policy and standards development, lifecycle investment planning, and cybersecurity services. With over 1,500 employees, DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents, DolT offers employees the opportunity to advance their careers, develop new skills and reach their potential, both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity and inclusion. We welcome and value employees with different backgrounds, life experiences and talents. It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement. In recruiting for our team, we recognize the unique contributions of each applicant regardless of culture, ethnicity, race, national origin, sex, gender identity and expression, age, religion, disability, and sexual orientation.

APPLICATION INSTRUCTIONS

Use the "Apply" button at the top right or bottom right of this posting to begin the application process.

If you are not already signed in, you will be prompted to do so.

State employees should sign in to the career portal for State of Illinois employees - a link is available at the top left of the Illinois.jobs2web.com homepage in the blue ribbon.

Non-State employees should log in on the using the "View Profile" link in the top right of the Illinois.jobs2web.com homepage in the blue ribbon. If you have never before signed in, you will be prompted to create an account.

If you have questions about how to apply, please see the following resources:

State employees: Log in to the career portal for State employees and review the Internal Candidate Application Job Aid

Non-State employees: on Illinois.jobs2web.com - click "Application Procedures" in the footer of every page of the website.

The main form of communication will be through email. Please check your "junk mail", "spam", or "other" folder for communication(s) regarding any submitted application(s). You may receive emails from the following addresses:

• donotreply@SIL-P1.ns2cloud.com
• systems@SIL-P1.ns2cloud.com

Nearest Major Market: Springfield