Business Analyst (Computer and Mathematical)

Company: Neotecra, Inc.
Location: Springfield
Posted on: January 27, 2023

Job Description:

We are looking for a Business Analyst. Below is the Job description. Job Title : Business Analyst Location : Springfield, N J (Remote) Duration : 12 Months Job Description: Candidate will be responsible for the management and maintenance of a legacy database supporting the Outdoor Lighting Department. Responsibilities will include the adherence to a data management policy, the monitoring and maintaining of data as well as manage data replication. Ensure that department's database is functional and backed up in the event of memory loss. Optimize database performance and user access, plan for backup and restoration/recovery of database information. Individual will resolve any errors in database performance including rewriting programming code as needed. They will also evaluate short-term, mid-term and long-term options (Cloud, MySQL, Solarwinds, Salesforce) to ensure success of the Outdoor Lighting department and adherence to regulatory requirements, as well as provide recommendations for database enhancements. Candidate must have the ability to develop a Linked Server allowing for the execution of queries from reference tables stored on non-SQL server database. Candidate will also be able to create an operational database that can calculate complex formulas using Power Query producing best tariff rates for managed customers. Job Requirements: 10 years experience in MS Access; 5 years in MS Access design/development/administration 5 years experience in MS Sql Server 5 years experience in MS Excel 2 years experience in migration MS Access databases to MS Sql Server 2 years experience in Salesforce Administration

Keywords: Neotecra, Inc., New York , Business Analyst (Computer and Mathematical), IT / Software / Systems , Springfield, New York