HEPCO, Inc. | Business Analyst (IT) | Springfield, NJ | United States | BigDataKB.com | 2023-01-27

Job Location: Springfield, NJ

Job Detail:

Work at one of the top utility companies in the nation and be a key contributor as a business analyst.

• Responsible for the management and maintenance of a legacy database supporting the Outdoor Lighting Department.
• Adherence to a data management policy, the monitoring and maintaining of data as well as manage data replication.
• Ensure that departments 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.
• Resolve any errors in database performance including rewriting programming code as needed.
• 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.

Qualifications 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
• Ability to develop a Linked Server allowing for the execution of queries from reference tables stored on non-SQL server database.
• Create an operational database that can calculate complex formulas using Power Query producing best tariff rates for managed customers.

Benefits

• Health Insurance
• Sick Time
• 401k

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, marital status, national origin, age, veteran status, disability, or any other protected class.

Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free