Database Operations Analyst

Job Number: 6906

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: 81858

Community / Marketing Title: Database Operations Analyst

Location_formattedLocationLong: Melville, New York US