Information Technology Auditor jobs in Fort Collins, CO

Responsible for designing reporting solutions to fulfill data and reporting requests and inquiries. Create reporting
solutions using multiple sources and systems and by manipulating data/information into clear and concise reports, graphs, charts, and
tables. Assist in application development, report writing, coding, testing, and debugging of District applications. Manage and submit
data to state and federal officials.

ESSENTIAL DUTIES AND RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each
essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable
accommodations may be made to enable individuals with disabilities to perform the essential functions. Frequency of duties, percent
of time and work year may vary based on department or building assignment.

Description of Job Tasks Frequency % of Time
Daily = D On an annual basis, e.g. 10
Weekly = W Monthly = M hours of a 40

Quarterly = Q hour work week = 10/40
Annually = A = 25%

1. Receive and fulfill data/reporting requests including collaborating with site staff, IT Data D 20%
Analysts, department Data Analysts, Application Support Analysts, Software Engineers,
subject matter experts, and customers to understand and design reporting solutions that
support data needs.

2. Manage and submit data to state and federal officials for all district schools, charter schools D 20%
and support staff to fulfill requirements for state and federal reporting.

3. Develop routine and non-routine queries, analysis, and reports to support data. Ensure all D 15%
requests are processed in a timely manner; produce reports, graphs, charts, pivot tables, flow
charts, and presentations often requiring complex data analysis; prepare documents and
reports related to student enrollment; provide and coordinate outreach to schools to ensure
that data needs are met; develop queries and scripts for the purpose of providing specific data.

4. Lead, manage and prioritize assigned projects, actively participate on project teams and D 10%
contribute to overall project team objectives; provide expertise, document processes.

5. Attend work and arrive in a timely manner. D 1%
6. Complete complex, detailed data analysis including identifying and interpreting trends and W 10%

possible results to aid in better understanding the data needs of the end-user in order to make
informed decisions to ensure data integrity in support of district goals and initiatives in
collaboration with Data Analyst II.

7. Assist Application Support Team in monitoring student data for accuracy by identifying data W 5%
quality issues.

8. Guide internal customers on best practices of reporting; follows District policies and W 5%
procedures relating to data privacy.

9. Devise in-depth understanding and document IT related workflows and overall systems W 5%
procedures; complete and update job specific documentation. Develop variety of user support
materials for the purpose of user reference, conveying information and ensuring end user
protocols.

10. Assist in performing student enrollment tracking and review. M 5%
11. Perform other duties as assigned. Ongoing 4%
TOTAL = 100%

2407 LaPorte Avenue, Fort Collins, CO 80521 • phone: (970) 490-3488
web: www.psdschools.org

EDUCATION AND RELATED WORK EXPERIENCE:

• Bachelor’s degree in computer science or computer information systems
• Two years of experience with reporting or business intelligence tools and working with data
• Application or database development experience preferred, including extracting and aggregating data
• Equivalent combination of education and experience acceptable
  

LICENSES, REGISTRATIONS or CERTIFICATIONS:

• Criminal background check required for hire

• Strong oral and written communication skills
• English language skills
• Analytical, mathematical, and statistical skills
• Interpersonal relations skills
• Strong customer service skills
• Advanced organizational, time management, and attention to detail skills
• Ability to lead a project team and communicate project status effectively
• Experience working with source control systems
• Understanding of relational databases
• General application development skills
• Strong knowledge of Microsoft Office Suite, especially Excel
• Experience and knowledge relational databases, performing SQL queries
• Ability to produce complex reports using reporting software and business intelligence tools
• Experience with data warehouse, BA, ETL and BI application(s), such as SAP, SAS, COGNOS, Microsoft BI
• Skills in Transact SQL using SQL Server including producing complex ad-hoc queries and the ability to import and manipulate

safety equipment, and report unsafe conditions to the appropriate administrator

38011 – IT Data Analyst I

MATERIALS AND EQUIPMENT OPERATING KNOWLEDGE:

• Advanced operating knowledge of and experience with personal computers and peripherals
• Advanced operating knowledge of and experience with office software
• Operating knowledge of and experience with typical office equipment, such as telephones, copier, fax machine, E-mail, etc.
  

REPORTING RELATIONSHIPS & DIRECTION/GUIDANCE:

POSITION TITLE # of EMPLOYEES
Direct reports: This job has no direct supervisory responsibilities.

• Responsible for providing guidance, mentoring, direction, and training to Applications Support Center Team colleagues.

PHYSICAL REQUIREMENTS & WORKING CONDITIONS: The physical demands, work environment factors and mental
functions described below are representative of those that must be met by an employee to successfully perform the essential functions
of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

PHYSICAL ACTIVITIES: Amount of Time
None Under 1/3 1/3 to 2/3 Over 2/3
Stand x
Walk x
Sit x
Use hands to finger, handle, or feel x
Reach with hands and arms x
Climb or balance x
Stoop, kneel, crouch, or crawl x
Talk x
Hear x
Taste x
Smell x

WEIGHT and FORCE DEMANDS: Amount of Time
None Under 1/3 1/3 to 2/3 Over 2/3
Up to 10 pounds x
Up to 25 pounds x
Up to 50 pounds x
Up to 100 pounds x
More than 100 pounds x

MENTAL FUNCTIONS: Amount of Time
None Under 1/3 1/3 to 2/3 Over 2/3
Compare x
Analyze x
Communicate x
Copy x
Coordinate x
Instruct x
Compute x
Synthesize x
Evaluate x
Interpersonal Skills x
Compile x
Negotiate x

38011 – IT Data Analyst I

WORK ENVIRONMENT: Amount of Time
None Under 1/3 1/3 to 2/3 Over 2/3
Wet or humid conditions (non-weather) x
Work near moving mechanical parts x
Work in high, precarious places x
Fumes or airborne particles x
Toxic or caustic chemicals x
Outdoor weather conditions x
Extreme cold (non-weather) x
Extreme heat (non-weather) x
Risk of electrical shock x
Work with explosives x
Risk of radiation x
Vibration x

VISION DEMANDS: Required
No special vision requirements.
Close vision (clear vision at 20 inches or less) x
Distance vision (clear vision at 20 feet or more)
Color vision (ability to identify and distinguish colors)
Peripheral vision
Depth perception
Ability to adjust focus x

NOISE LEVEL: Exposure Level
Very quiet
Quiet
Moderate x
Loud
Very Loud

38011 – IT Data Analyst I