

Pat N Sally Consulting Inc
Software Analyst
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Software Analyst with a contract length of over 6 months, offering $60.00 - $70.00 per hour. Requires EAM experience, 2 years with NYSDOT, SQL proficiency, GIS expertise, and a Master's degree. On-site work location.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
560
-
ποΈ - Date
October 23, 2025
π - Duration
More than 6 months
-
ποΈ - Location
On-site
-
π - Contract
Unknown
-
π - Security
Unknown
-
π - Location detailed
Albany, NY
-
π§ - Skills detailed
#Project Management #Databases #Migration #Data Warehouse #"ETL (Extract #Transform #Load)" #Database Management #Oracle #Documentation #Data Migration #Data Analysis #Microsoft Access #SQL Queries #SQL (Structured Query Language)
Role description
Enterprise Asset Management (EAM) experience implementing and managing enterprise asset management systems.
Experience with New York State Department of Transportation (NYSDOT) or any other state. Minimum 2 years working directly with NYSDOT systems and process.
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.
Data Migration Expertise β Experience migrating legacy Microsoft access databases to modern data warehouse repositories and enterprise data platforms.
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.
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.
Experience with MS Office (Word, Excel, PowerPoint) as well as MS Visio
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.
Experience translating technical information into clear, readable documents to be used by technical and non-technical personal.
Masterβs in business administration (MBA), accounting, IT or any related field
Job Types: Full-time, Contract
Pay: $60.00 - $70.00 per hour
Education:
Master's (Required)
Experience:
Enterprise Asset Management (EAM): 3 years (Required)
SQL queries: 1 year (Required)
Geospatial Information System (GIS): 2 years (Required)
MS Office: 4 years (Required)
data analysis: 1 year (Required)
Data Migration: 3 years (Required)
Work Location: In person
Enterprise Asset Management (EAM) experience implementing and managing enterprise asset management systems.
Experience with New York State Department of Transportation (NYSDOT) or any other state. Minimum 2 years working directly with NYSDOT systems and process.
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.
Data Migration Expertise β Experience migrating legacy Microsoft access databases to modern data warehouse repositories and enterprise data platforms.
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.
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.
Experience with MS Office (Word, Excel, PowerPoint) as well as MS Visio
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.
Experience translating technical information into clear, readable documents to be used by technical and non-technical personal.
Masterβs in business administration (MBA), accounting, IT or any related field
Job Types: Full-time, Contract
Pay: $60.00 - $70.00 per hour
Education:
Master's (Required)
Experience:
Enterprise Asset Management (EAM): 3 years (Required)
SQL queries: 1 year (Required)
Geospatial Information System (GIS): 2 years (Required)
MS Office: 4 years (Required)
data analysis: 1 year (Required)
Data Migration: 3 years (Required)
Work Location: In person






