information technology analyst - Torrance, United States - City of Torrance, CA

Description

Salary : $6, $8,860.80 Monthly

Location : Torrance, CA

Job Type: Permanent Full-time

Job Number: AP

Department: Communication & Information Technology

Opening Date: 02/29/2024

Closing Date: Continuous

DESCRIPTION

WE STRONGLY ENCOURAGE APPLICANTS TO READ THE JOB ANNOUNCEMENT

IN ITS ENTIRETY BEFORE SUBMITTING AN APPLICATION FOR THIS POSITION.

The City of Torrance recognizes the principles of diversity and inclusion, and strives to ensure equal opportunities for its workforce, applicants and community members. If you are a person who wants to make a difference, give back to your community, and be a voice for change, apply to the City of Torrance today.

The City of Torrance is recruiting for an INFORMATION TECHNOLOGY ANALYST to be part of the Communications and Information Technology Team

The Department
The is a dynamic technical computer organization that readily adapts to the needs of the City of Torrance. CIT administers and maintains the City's communications and computing network environment, software applications, network/hardware infrastructure, desktop computers, telephones (desktop and cellular), and mobile radio communications for Police, Fire and the entire City's wireless communication infrastructure. CIT is responsible for approximately 200+ different business applications and office automation software programs and is also responsible for ensuring the integrity and security of all data passing through or stored on our network.

The Position
Under direction, the IT Analyst in the Applications and Analytics Division significantly enhances the City's IT portfolio, focusing on software development, deployment, and analytics. This versatile role involves coding, system analysis, and implementing solutions that align with strategic objectives, emphasizing operational efficiency.

The Analyst's duties extend to gathering business requirements and ensuring IT solutions are tailored to the City's needs. By collaborating with various teams, the IT Analyst ensures application and data integration, contributing to the City's technological ecosystem's efficiency.

Leading IT small to moderate-sized projects, the IT Analyst ensures solutions are delivered effectively. The role also includes developing analytic dashboards, engaging in workflow analysis, and project planning, essential for driving the City toward its strategic goals.

With a commitment to continuous improvement and innovation, the IT Analyst plays a key role in fostering relationships across departments, delivering exceptional IT services that enhance the City's operational and strategic framework. This position embodies the versatility of the Applications and Analytics Division.

Although normal working hours are a 9/80 schedule with alternate Fridays off, this position must be available to work on various weekends and closed Fridays during computer "down" times. In addition, the Information Technology Analyst must be available to be on call.

For more information about the duties of the position, click .

NOTE: Employees are eligible for premiums up to a maximum of 15% for IT certification. Please click on the following link to access the Memorandum of Understanding to see the eligible certifications for this position (Attachments B-F): Torrance Professional and Supervisory Association Memorandum of Understanding.

QUALIFICATION GUIDELINES

Education and Experience
Any combination of education and experience that provides the required knowledge and skills is qualifying. A typical way to obtain the knowledge and skills would be:

An Associate's degree in Data processing or Computer Sciences or a Certificate in Data Processing;
AND
Three years of progressively responsible information technology experience consisting of systems design, program design, coding, testing, implementing and documenting business application systems currently in use by the City.

License and/or Certification
Must possess and maintain an appropriate California driver's license. Professional certification in applications, hardware and systems used by the City is highly desirable.

Successful candidates will possess the following:

• Experience in the development of dynamic ETL (Extract, Transform, Load) aggregating processes from multiple data sources (Rest APIs, Databases, Files, Soap Web Services) using various scripting languages: SQL, Perl, JavaScript, Python, etc.
• Experience in writing custom applications, ETLs, automation, and interfaces using a variety of languages such as .NET, Java, PL/SQL, JavaScript, and Python.
• Experience using low/no-code tools like Microsoft Power Platform (Power BI, Power Automate, Power Pages, and Power Apps).
• Experience in developing dashboard representation of enterprise data in Business Intelligence (BI) tools such as Power BI, Business Works, Cognos, or Tableau.
• Demonstrated experience in strong analytical skills and problem-solving abilities.
• Experience synthesizing ideas and information into well-organized and accurate reports, correspondence, charts, and presentations.
• Experience in successfully leading small to moderate-size projects from conception, planning, building, testing, implementation, and closure.
• Ability to apply best business practices for data collection, processing, management, validation, integrity, analysis, security, and reporting.
• The ability to document business process workflows in Microsoft Visio using Business Process Modeling and Notation (BPMN).
• Ability to exercise sound, independent judgment, and work with minimal supervision.
• Ability to perform highly detailed work on multiple concurrent projects and tasks under strict deadlines.
• Ability to research and evaluate new technologies and present recommendations.
• The ability to establish and maintain effective working relationships with all team members and business users.

HOW TO APPLY & EXAM PROCESS

Application submission will be accepted on a continuous basis until the position is filled. First review of applications will be those received by Wednesday, March 20, 2024, at 11:59 p.m. (If a sufficient number of qualified applications are received by the first review date, there is the possibility that the recruitment may close at that time.)

Only those candidates who best meet the City and Department's needs will be invited to participate in the examination process, which will consist of the following component:

Panel Interview: 100% (Tentatively scheduled for Tuesday, April 2, 2024)
The tentative test date(s) will be based on a sufficient number of qualified applications received by the first review date. If a sufficient number of applications are not received by the first review date, there is the possibility that the test date may change to a later date.
SPECIAL NOTES

Visit www.TorranceCA.Gov to find out more information about our community.

Applicants with disabilities who require special testing arrangements must contact Human Resources prior to the examination date(s). If you have a disability for which you require an accommodation, please contact us at before the test date.

As a condition of employment, candidates must pass a background check.

The provisions of this announcement do not constitute an expressed or implied contract and any provisions contained in this announcement may be modified or revoked without notice.

City of Torrance Inclusion Statement
The City of Torrance is a welcoming and culturally-rich community. As a pillar of public service, we strive to be an employer of choice by attracting and retaining a talented workforce where people of diverse backgrounds, cultures, religions, and lifestyles are valued. Our mission is to create an inclusive environment where our staff are empowered to perform at their highest level and contribute towards making a positive impact.

The City is an equal opportunity employer and works towards building collaborative teams from all walks of life without regard to race, color, ethnicity, religion, national origin, age, sex, sexual orientation, gender identity, marital status, ancestry, disability, genetic information, veteran status, or any other status protected under federal, state and/or local law. Come join us to help cultivate a workplace that welcomes and celebrates the diversity of our employees

BENEFIT SUMMARY FOR TORRANCE PROFESSIONAL AND SUPERVISORY ASSOCIATION (TPSA)
Note: Not all benefits listed may be applicable to all positions with in the unit. Please refer to the MOU for specifics.

Health, Dental, Vision and Life Insurance (sec. 4.1)
Effective 1/6/19, the City's monthly contribution for health insurance is as follows:
Employee Only Employee +1 Employee +2 or more
Full Time
Part- time
(hired prior to 1/1/
Part-time
(hired after 1/1/

The City's monthly contribution for vision insurance is $3.33
The City's monthly contribution for dental insurance is $33.71/EE only and $67.42/EE +1 or more
The City provides a Cash In-Lieu payment of $400 per month for eligible full-time employees for as long as the employee opts-out of medical coverage
City provides a $50,000 life insurance policy

Premium/Certification Pay (sec. 3.2)
Varies by position and assignment. Please see section 3.2 for further information.

Educational Incentive Program (Sec. 3.3)
Building Inspection Supervisors: 4% of base pay for ICC certificate in one of the certified areas. (Additional 2% for each additional certificate, up to max of 12%).
Failure to maintain certification results in loss of 2% for each year's delay of recertification.

Disability Insurance (sec. 4.1)
Employee receives 2/3 base pay after elimination period (14 consecutive days for STD and 180 consecutive days for LTD)

Retirement (sec. 4.2)
PERS
Employees hired prior to 11/09/2010, City pays 7% EPMC*
Employees hired on or after 11/09/2010, pay 7% EPMC*
*Employer Paid Member Contribution (EPMC)
PERS
"New members" hired on or after 1/01/2013, pay (50%) of normal cost with three year average final compensation.

Deferred Compensation (sec 4.3)
Eligible to participate in a voluntary 457 plan. Required participation in Retirement Health Savings Plan (RHSP). Upon retirement or separation from City: 600 sick and 300 vacation will be deposited in RHSP.

Sick Leave/Personal Leave (sec. 4.5)
Accrue 6 hours per month
Maximum Accrual: 600 hours.

Holidays (sec. 4.6)
13 paid holidays for all classifications except Sr. Librarian - (New Year's Day, Martin Luther King Jr. Day, Lincoln's Birthday, Washington's Birthday, Memorial Day, Independence Day, Labor Day, Veteran's Day, Thanksgiving Day, day after Thanksgiving, Christmas Eve, Christmas Day & New Year's Eve).
Paid holidays for *Senior. Librarian- New Year's Day, Martin Luther King's birthday, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, Christmas Eve, Christmas Day and New Year's Eve. (Lincoln's and Washington's birthday, Veteran's day and day after Thanksgiving - provided leave is taken on a rotational basis (subject to Dept. Head approval).

Vacation/Annual Leave (sec. 4.7)
(Accrual rate per month):
Years 1 -2 : 6.55 hours; Years 3 - 4: 7.88 hours; Years 5 - 9: ; Years : 13.90 hours; Years : 15.22 hours; Year 25+: 15.88 hours
Maximum Accrual: up to the amount earned over the preceding 36 months

Bereavement Leave (sec. 4.8)
Up to three (3) working shifts with pay per death (Additional 2 work shifts for deaths that occur out of state or in excess of 300 miles

Family-School Partnership Leave (Sec
40 hours (max 8 hours per month) unpaid per calendar year (employees may use accrued vacation or comp time)

Uniform Allowance (Sec
$500 voucher: Animal Control Supervisor, Police Operations Supervisor, Forensic Identification Specialist, Senior Forensic Identification Specialist and Forensic Supervisor (payable in September of each year).
$250 voucher: granted twice (2) per calendar year for Transit Supervisor

Night Shift Differential (sec. 5.3)
5% over base pay when 1⁄2 or more of the shift is worked after 4:00 p.m.
7 1⁄2% when 1⁄2 or more of the shift is worked after midnight
Sr. Librarian - 10% above average base hourly when 1⁄2 shift is worked after 3:00 p.m.

Safety Shoes (Sec. 6.4.B)
Allowance of $125 each 6 months of employment (paid June and December), for those required to wear safety shoes.

01

The following supplemental questions will be used to evaluate your qualifications for the position for which you are applying. Resumes are encouraged but will NOT be used in lieu of the application or supplemental questions. Please read each question carefully and provide a thorough and complete response. Do NOT state "see resume" or "see application" to respond to any of the following questions. Failure to respond to all questions will be considered an incomplete application and may not be considered for further processing. Do you understand the foregoing?

• Yes
• No

02

I UNDERSTAND that I am required to describe IN DETAIL my qualifying experience in the Work Experience Section of my application. In addition to including my qualifying experience, I UNDERSTAND that I should list ALL JOBS, regardless of duration, including part-time jobs, military service and any volunteer experience during my entire work history.I UNDERSTAND that when providing my work history, ALL DATES should be UPDATED, starting with my most recent job.I UNDERSTAND that answers that I provide to the supplemental questions should be reflected in the Work Experience Section of my application.I UNDERSTAND that if I am currently employed by the City of Torrance, I MUST provide my appropriate job classification/title and provide a description of my duties in the Work Experience Section of my application.I have read these statements in their entirety and understand them completely and to their fullest.

• Yes
• No

03

Indicate your level of education as it relates to this position.

• None
• Certificate in Data Processing
• Associate degree in Information Technology, Data Analyst, Computer Science or equivalent
• Bachelor's degree in Information Technology, Data Analyst, Computer Science or equivalent
• Other (If other, please make sure your education is clearly detailed on the primary application)

04

Please list any related college coursework that you have completed or active specialized IT/PM certifications that you possess. Please ensure that you attach a copy of the certification(s) to your application. (Type N/A if not applicable)

05

Indicate the number of years of experience providing professional support to enterprise information systems.

• None
• Less than one year
• More than one year, but less than three years
• More than three years, but less than five years
• More than five years

06

Indicate your years of experience in coding a solution in Python.

• None
• Less than one year
• More than one year, but less than three years
• More than three years, but less than five years
• More than five years

07

Provide a detailed example(s), provide the year(s), the role, IT initiative, and the challenges you faced and how you successfully navigated these obstacles when developing the solutions in Python. (Type N/A if not applicable)In your response, include details that clearly reflect how you meet this minimum qualification. Such as:
• Examples of when you used the knowledge skill or ability.
• Role you served in (professional, internship, volunteer).
• The impact and/or results of your of experience.
• Skills, training, transferable skills or lived experience you have that will help you in this area.
• Total years of experience applying the knowledge, skill, or ability.

08

Indicate your years of experience in coding a solution in JavaScript.

• None
• Less than one year
• More than one year, but less than three years
• More than three years, but less than five years
• More than five years

09

Provide a detailed example(s), provide the year(s), the role, IT initiative, and the challenges you faced and how you successfully navigated these obstacles when developing the solutions in JavaScript. (Type N/A if not applicable)In your response, include details that clearly reflect how you meet this minimum qualification. Such as:
• Examples of when you used the knowledge skill or ability.
• Role you served in (professional, internship, volunteer).
• The impact and/or results of your of experience.
• Skills, training, transferable skills or lived experience you have that will help you in this area.
• Total years of experience applying the knowledge, skill, or ability.

10

Indicate your years of experience with developing Analytical Dashboards in Power BI, Tableau, Business Works, or Cognos.

• No
• Less than one year
• More than one year, but less than three years
• More than three years, but less than five years
• More than five years

11

Provide a detailed example(s), provide the year(s), the role, the business problem, tools utilized, and the challenges you faced and how you successfully navigated these obstacles when a visual dashboard to solve a business problem. (Type N/A if not applicable)In your response, include details that clearly reflect how you meet this minimum qualification. Such as:
• Examples of when you used the knowledge skill or ability.
• Role you served in (professional, internship, volunteer).
• The impact and/or results of your of experience.
• Skills, training, transferable skills or lived experience you have that will help you in this area.
• Total years of experience applying the knowledge, skill, or ability.

12

Indicate your years of experience in utilizing the Power Pages, Power Automate, and Power Apps.

• None
• Less than one year
• More than one year, but less than three years
• More than three years, but less than five years
• More than five years

13

Indicate your years of experience in developing ETLs (Extract, Transform, Load) solutions.

• None
• Less than one year
• More than one year, but less than three years
• More than three years, but less than five years
• More than five years

14

Provide a detailed example(s), provide the year(s), the role, IT initiative, coding language/Low Code Platform, and the challenges you faced and how you successfully navigated these obstacles when developing ETLs. (Type N/A if not applicable)In your response, include details that clearly reflect how you meet this minimum qualification. Such as:
• Examples of when you used the knowledge skill or ability.
• Role you served in (professional, internship, volunteer).
• The impact and/or results of your of experience.
• Skills, training, transferable skills or lived experience you have that will help you in this area.
• Total years of experience applying the knowledge, skill, or ability.

15

Describe your experience in SQL development, SQL Queries and reporting, and administration in Microsoft SQL database. (Type N/A if not applicable)

16

Are you willing and available to work on call, evenings, holidays, and weekends, including Saturdays and Sundays?

• Yes
• No

Required Question