City of Detroit, MI - Detroit, MI

posted 10 days ago

Detroit, MI
Executive, Legislative, and Other General Government Support

About the position

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 executing 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 documents, communicate effectively, both verbally and in writing, and provide technical support resolving incidents, and creating/closing tickets.

Responsibilities

  • 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.
  • Perform related work duties as assigned.
  • 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.
  • Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism.
  • 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.
  • 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 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 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.
  • 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 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.
  • 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.

Requirements

  • 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.

Nice-to-haves

  • Experience in both large and high frequency data loads, techniques and optimization methods.
  • Knowledge of web technologies that facilitate the exchange of information between organization such as (S)FTP(S), REST, SOAD, JSON, etc.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service