Enterprise Asset Management Analyst (EAM)

JSM Consulting Inc.; City of Albany (NY); On-site; USD 90,000 - 125,000; Full time

Job summary

JSM Consulting Inc. seeks a seasoned Software Analyst with extensive EAM and state agency experience. The role requires working with NYSDOT systems, gathering detailed requirements, and translating business needs into technical specifications. Strong data analysis and stakeholder communication are essential.

The candidate will leverage SQL and data modeling tools to support data migration, reporting, and process improvements while aligning with SSDLC practices.

Qualifications

• 36 months Enterprise Asset Management (EAM) experience implementing and managing enterprise asset management systems.
• 36 months experience with NYSDOT or any other state agency; minimum 2 years working directly with NYSDOT systems and process.
• 84 months Software Analyst experience acting as a liaison between users and developers to gather requirements.

Skills

Analytical problem-solving

Data analysis & modeling

Requirements gathering

Translate customer input to design

Stakeholder communication

Education

MBA / accounting / IT

Tools

SQL

Oracle Data Modeler

MS Visio

MS Office

Job description

• 36 months Enterprise Asset Management (EAM) experience implementing and managing enterprise asset management systems.
• 36 months experience with New York State Department of Transportation (NYSDOT) or any other state. Minimum 2 years working directly with NYSDOT systems and process.
• 84 months Software Analyst experience Ability to study software application domains and develop detailed requirements specifications while serving as a liaison between users and developers.
• Understands software technology and has experience writing SQL queries for data retrieval, reporting and database management.
• Analytical problem-solving skills to effectively convey user demands and facilitate technical solutions.
• 36 months Data Migration Expertise Experience migrating legacy Microsoft access databases to modern data warehouse repositories and enterprise data platforms.
• 24 months Geospatial Information System (GIS) experience. Gather requirements for various data components to generate comprehensive reports, map point-to-location data, and compile documentation on conditions within the geospatial information system framework.
• 84 months working as a Software Analyst with agencies/business areas to understand business requirements to produce functional and non-functional specifications according to Project Management Industry standards and Secure System Development Lifecyle (SSDLC).
• Gather, organize, analyze, and quantify data about customer needs and requirements, costs/benefits, advantages/disadvantages, technical feasibility of implementing new or changed business solutions, and comparisons of technical solutions.
• Translate customer input into information that can be used to make decisions and support the technical solution.
• Experience with process modeling for improving business and systems operations in turn identifying innovative ways to increase customer satisfaction. This includes the ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
• Experience data analysis and modeling for on-line transactional processing systems, data warehouses, and/or data transformation using tools such as Oracle Data Modeler.
• 48 months experience with MS Office (Word, Excel, Powerpoint) as well as MS Visio
• 48 months experience working in a fast-paced environment wherein the team comprises a variety of Stakeholders including Senior Business and IT Management, Business Subject Matter Experts, Vendors and IT resources to understand and negotiate needs and expectations across all.
• 48 months experience translating technical information into clear, readable documents to be used by technical and non-technical personal.
• Masters in Business Administration (MBA), accounting, IT or any related field