Sr. Database Operations Analyst

LocationMelville, NY
Job Typefull_time

About This Job

Job Number:

6921

External Description

PSEG offers a unique experience to our more than 12,000 employees – we provide the resources and opportunities for career development that come with being a Fortune 500 company, as well as the attention, camaraderie, and care for one another you might typically associate with a small business. Our focus on combatting climate change through clean energy technology, our new net zero climate vision for 2030 and enhanced commitment to diversity, equity, and inclusion; and supporting the communities we serve make this a particularly exciting time to join PSEG.

Job Summary

Responsibilities include but are not limited to design, develop, and maintain Microsoft Access Databases to store, retrieve, and drive business decisions. Enhance existing or create new databases to perform calculations, organize and save data and create reports for various Revenue Operations groups. Migrate a multitude of Microsoft Access Databases to Sequel Server. This position will also be responsible to analyze data, determine trends, and develop reports as requested by management as related to the department’s achievement of various OSA metrics, or to meet various regulatory requirements. Devise strategies for business optimization, spearhead the development of processes, identify strengths and weaknesses, and offer recommendations on areas in need of improvement. Work as the go between with management and the IT department to communicate complex technical issues for innovative solutions; the creation of daily, weekly, monthly reports for Back Office Billing department. Formulate various forecasts as they relate to work totals, workflow and staffing. Conduct comprehensive data analysis using Microsoft Access and other analytical tools to identify trends, patterns, insights and develop reports as requested by management.

Job Responsibilities Include

Develop and/or enhance existing databases/spreadsheets
Review/create reports, tables and databases to determine inconsistencies and/or irregularities
Develop tables, queries, and code within SQL Server
Must possess the ability to transfer data from the backend of Microsoft Access to SQL using limited applications.
Must possess well developed planning, organizational, leadership and time management skills in order to investigate and develop solutions to requests.
Develop and generate ad-hoc reports and scorecard reports from existing systems that support informational needs of management and/or operating personnel
Proficient in designing SQL queries, views, and stored procedures to extract data from multiple sources and perform relevant analysis.
Collect, summarize and analyze various reports and performance measures
Prepare reports (daily, monthly, annually, and ad hoc)
Actively participate in problem solving initiatives to determine root cause, gap analysis, along with the development and implementation of process improvement recommendations
Provide timely feedback to determine effectiveness of implemented solutions and take corrective action as required
Reconcile data transfer between systems and ensure accuracy and integrity of data through regular audits and validation procedures.
Work closely with cross-functional teams to understand data needs and deliver actionable insights.
Assist on special projects as required.
Support the month-end, quarter-end and year-end closing processes. These can include creating and maintaining journal entries, conducting actual vs plan analysis, and creating ad hoc analysis.
Assist in analyzing results and identify areas of opportunities for efficiency and cost savings.
Provide training and support to team members on the use of Access databases and other data analytical tools.
Distribute work assignments to the union staff from multiple data streams.


Job Specific Qualifications (required Skills)

Bachelor's degree preferably in Business Management, Finance, Economics, Computer Science, Information Technology, Data Analytics or other related discipline, and a minimum of 2 years Analyst experience; in lieu of a degree, a minimum of 5 years of experience in customer operations, business, accounting, economics, computer science, or finance and proficiency with databases
Excellent computer skills, specifically proficiency with Microsoft Access programming with VBA, Oracle or similar applications and Excel.
Demonstrated proficiency in PowerPoint, Word and Tableau
Knowledge of SQL from end to end
Demonstrated ability to manage multiple priorities in a dynamic environment
Demonstrated strong analytical and problem-solving abilities
Must have excellent verbal, quantitative and written communication skills
Must possess and maintain a valid U.S. Driver's License and a safe and satisfactory driving history
Must demonstrate a sense of teamwork and initiative

Job Number:

81879

Community / Marketing Title:

Sr. Database Operations Analyst

Location_formattedLocationLong:

Melville, New York US

Trending Jobs

company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Division Order Analyst

Coronado Resources
Job TypeFull-time
 
Dallas, TX
about 2 months ago
company-logo

Professional Landman

Penterra Services, LLC
Job TypeContract
 
Lovington, NM
25 days ago
company-logo

Accounts Payable Clerk

LPR Energy
Job TypeFull-time
Salary
$65000 - $65000
Dallas, TX
2 months ago
company-logo

Division Order Landman

R. Lacy Services, Ltd.
Job TypeFull-time
 
Longview, TX
about 1 month ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, LA
4 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, TX
3 months ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, TX
over 1 year ago
company-logo

Title Landman

Sustain Land Services
Job TypeFull-time
 
Norman, OK
3 months ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, TX
3 months ago
company-logo

Oil and Gas Title Attorney

Oliva Gibbs PLLC
Job TypeFull-time
 
Houston, TX
2 months ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, PA
5 months ago
company-logo

Title Reviewer

Innovation Land Services
Job TypeFull-time
 
Pittsburgh, PA
5 months ago
company-logo

Landman

Stockyards Energy Land Services
Job TypeContract
 
Akiachak, TX
6 months ago
company-logo

Civil/Structural Designer

Dudley Staffing
Job TypeFull-time
Salary
$30 - $60
Canonsburg, PA
5 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Midland, TX
4 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Cheyenne, WY
4 months ago
company-logo

Mechanical/Piping Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Senior Division Order Analyst

Formentera
Job TypeFull-time
Salary
$110000 - $130000
Austin, TX
about 1 year ago
company-logo

E & I - Office/Field Administration

Surepoint Group
Job Typefull_time
 
Grande Prairie, AB
28 days ago

Notice: The inclusion of job postings or company information on our platform does not imply endorsement, partnership, or affiliation. Listings may include publicly available roles from various sources, and companies shown may not have a direct relationship with Energy Hire.