What are the responsibilities and job description for the Applications Analyst 2 (Integrations) position at City of Detroit, MI?

Salary : $52,924.00 - $95,039.00 Annually

Location : DWSD -735 Randolph Detroit MI 48226, MI

Job Type : Classified- Regular (DWSD Only)

Job Number : MM-022025-501034

Department : Water Department

Opening Date : 02 / 03 / 2025

Closing Date : 2 / 13 / 2025 11 : 59 PM Eastern

Bargaining Unit : 9000-Non Union Salary Regular Service General

Description

This is not a Civil Service Position. DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD does not honor reversion rights for internal candidates.

SUMMARY :

IT requires an Applications Analyst 2 (Integrations) with experience in working with Databases in multi-cloud,

tenant environments to design, develop support and document data flows from line of business

applications to other line of business applications or to DWSD's data warehouse. A solid knowledge

of T-SQL, PL / SQL. Java and python is required.

Experience in both large and high frequency data loads, techniques and optimization methods is a plus. Collaborate with IT to design and model application data structures, storage and integration in accordance with enterprise wide architecture standards across legacy, web, and cloud and purchased package environments.

Developing and executive text plans and scenarios including data design, tool design, data extract / transform, networks and hardware. Ensure compliance with HIPPA, PCI, PII, Federal and State required data policies / best practices as required. Ensure appropriate capture and retention and metadata management of data. Knowledge of web technologies that facilitate the exchange of information between organization such as (S)FTP(S), REST, SOAD, JSON, etc. is a plus.

Ability to write

technical and non-technical document, communicate effectively, both verbally and in writing, and

provide technical support resolving incidents, and

creating / closing tickets.

Examples of Duties

Assist other IT staff and IT management as needed with overflow activities involving the support and maintenance of computers, printers, applications, databases, networks, servers, storage, and data center facilities, and the installation, decommissioning, and relocation of related IT equipment. Perform related work duties as assigned.

SKILL TO :

Independently, and as part of a team providing timely, high quality customer-focused services
Work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
Work in a professional manner with access to confidential and other data types
Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism
Work in a team environment that provides the capacity for IT project delivery
Resolve technology and user issues both verbally and in writing to end-users of varying computing skills
Deliver quality written and presentations, including the ability to make technology understandable to end-users
Understand and translate the needs of varied users into IT system requirements
Use advanced technology

ABILITY TO :

Organize, perform and or coordinate technology tasks and projects

Install, remove, and make modifications to technology

Instruct groups or individuals on technology

Deliver quality customer service to users

Write technical and non-technical documentation

Interact and communicate with IT staff and business users

Apply IT policies and programs in a manner aligned with the Department mission, goals, and strategies

Learn new application software packages, operating systems, and IT processes and procedures

Effectively utilize appropriate security and safety equipment and procedures

Communicate effectively, both verbally and in writing

Understand and follow verbal and written instructions

Establish and maintain effective working relationships with others

Communicate frequently with team members and other units across the Department about process, equipment or potential problems

Develop proficiency in unit specific operations and software

Direct team activities or to work as a team member

Maintain regular and reliable attendance

Consult, coordinate and communicate with business units and IT staff to refine business requirements into tangible, functional requirements and technical specifications that both business and IT staff are able to interpret

Responsible for capacity planning and management, security planning and management, data management, systems maintenance, and performance management of one or more systems

Plan, design, and implement IT-related policies and procedures

Participate in information technology planning for hardware, software, and infrastructure

Coordinate with staff in various areas in different roles (application, project and technical management) developing different components of the functional design and requirements

Provide solutions and recommendations which integrate with current and future database, application, and infrastructure architectures

Identify potential risks and dependencies between applications, systems and business processes and provides solutions, impacts and recommendations to resolve conflicts if they should arise

Demonstrate ability to compose and provide project and technical documentation, including functional requirements and use cases, and technical specifications

Develop application prototypes and mockups to present to the project user group in an effort to collect functional clarifications and requirements

Provide production support for new and existing applications / interfaces.

Provide technical support resolving incidents, and creating / closing tickets

Maintain working knowledge of current industry information, vendor direction, new and emerging products, and technical architectures and approaches related to current and future organizational need

Plan, design, and implement additions, upgrades, replacements, or retirement of applications including the database management environment on the Web to support the capacity to store a substantial amount of data

Minimum Qualifications

REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry)

Bachelor's Degree in Computer Science, Information Technology or related field

Three (3) to five (5) years of related work experience; or combination of related work experience and education

Valid Michigan Driver's License

Ability to work irregular hours, commute to DWSD facilities and work sites, and respond to after hour emergencies and on-call responses

EMPLOYMENT BENEFITS

The City of Detroit offers a competitive and comprehensive employee benefit package. We pride ourselves on the longevity of our employees. Part of the reason for the low turnover rate is the exceptional benefit package listed below. Benefits include, but are not limited to the following :

HEALTH

Medical - Eligible for hospital, surgical, and prescription drug benefits.

Dental

Vision

INSURANCE

Life Insurance - Optional group insurance available to employee and their family. The City pays 60% of premium for first $12,500 of employee life insurance. Employee may purchase, at own expense, life insurance for spouse and each dependent.

Long-Term Disability Insurance (Income Protection Plan) - The City offers disability insurance through payroll deductions for persons who become disabled and who are not yet eligible for a service retirement.

PAID TIME OFF

Sick Leave

Vacation

Holidays

OTHER LEAVE BENEFITS

The City also has the following paid and unpaid leaves; funeral leave, Family and Medical Leave, jury duty, military duty leave, unpaid personal leave,

RETIREMENT BENEFITS

City Employees Retirement System

As a regular City employee you automatically become a member of the General Retirement System. This entitles you to a retirement allowance after :

Completion of thirty (30) years of service;

At age sixty (60) if you have at least ten (10) years of service, or

At age sixty-five (65) with eight (8) years of service.

In the event of disability, other eligibility rules apply);

An early, actuarially reduced, retirement is offered after you have attained at least twenty-five (25) years of service;

Employees are vested after ten (10) years of service, regardless of age.

ADVANCEMENT OPPORTUNITIES - Employees have many opportunities for growth and career advancement throughout all City departments and divisions.

Have a successful career with the City of Detroit . Always remember that you are a part of a team with a common Vision of delivering excellent service to the citizens of the City of Detroit

Salary : $52,924 - $95,039

Apply for this job

Receive alerts for other Applications Analyst 2 (Integrations) job openings

Applications Analyst 2 (Integrations)

What are the responsibilities and job description for the Applications Analyst 2 (Integrations) position at City of Detroit, MI?

What is the career path for a Applications Analyst 2 (Integrations)?

Job openings at City of Detroit, MI

Not the job you're looking for? Here are some other Applications Analyst 2 (Integrations) jobs in the Detroit, MI area that may be a better fit.

We don't have any other Applications Analyst 2 (Integrations) jobs in the Detroit, MI area right now.

AI Assistant is available now!