Database Operations Analyst
Date: May 8, 2025
Location: Melville, NY, US
Company: LIPAPRD
Requisition: 81858
PSEG Company: PSEG Long Island
Salary Range: $ 65,400
- $ 116,200
Work Location Category: Hybrid Flexible
PSEG operates under a Flexible Work Model where flexible work is offered when job requirements allow. In support of this model, roles have been categorized into one of four work location categories:
Onsite are roles that have specific onsite requirements and are typically onsite daily.
Hybrid fixed are roles that are a blend of onsite work/in-person interactions with some ability to work remotely and require employees to live within a commutable distance and be onsite fixed days each week.
Hybrid flexible are roles that can be performed remotely but require some level of onsite work/in-person interactions on a regular basis, require employees to live within a commutable distance and, since business needs vary by position and may change over time, managers will set expectations and flexibility regarding where and when work is performed.
Fully remote are roles that can be performed remotely, require employees to live in approved states and will have purpose-driven in-person interactions on occasion.
We want you to be healthy, balanced, and feel secure. That’s why you’ll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you’ll be offered several health-related benefits including medical, vision, dental, well-being and behavioral health programs. We also offer a retirement program, 401(k) with company match, company paid life insurance, tuition reimbursement and a minimum of 18 days of paid time off per year (including vacation, scheduled holidays, and floating holidays).
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
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
Knowledge and Experience Required:
• 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
Minimum Years of Experience
Education
Certifications
Disclaimer
Certain positions at the Company may require you to have access to Part 810-Controlled Information. Under the law, the Company is limited in who it can share this information with and in certain circumstances it is necessary to obtain specific authorization before the Company can share this information. Accordingly, if the position does require access to this information, you must complete a 10 CFR Part 810 Export Control Compliance Nationality Request Form, a copy of which will be provided to you by Talent Acquisition if an offer is made. If there is a need for specific authorization, due to the time it takes to obtain authorization from the government, we will likely not be able to further proceed with an offer.
If you are a current PSEG employee and if you are offered an opportunity with PSEG Long Island, you will be treated as a new hire. Please note that as a new hire to the Long Island subsidiary, your benefits will change and generally will be consistent with other similarly situated PSEG Long Island new hires. Similarly, for PSEG Long Island employees who accept job opportunities with PSEG or any of its subsidiaries (other than PSEG Long Island), their benefits would change and generally be consistent with other similarly situated new hires of that company.
As an employee of PSE&G or PSEG LI, you should be aware that during storm restoration efforts, you may be required to perform functions outside of your routine duties and on a schedule that may be different from normal operations.
For all roles, PSEG’s drug and alcohol testing program includes pre-employment testing, testing for cause, and post-incident/accident testing. For employees in federally regulated roles (including positions covered by USDOT, PHMSA, or NRC regulations), this also includes random testing. Although numerous states throughout the country have legalized marijuana/cannabis products recreationally and/or medically, it is prohibited for employees in federally regulated roles. Employees who are hired or transfer into a federally regulated role are subject to drug and alcohol testing, inclusive of marijuana. Please note that the use of CBD products may result in a positive drug test for THC/Marijuana and such use is not a legitimate medical explanation for such a positive result.
PSEG is an equal opportunity employer, dedicated to a policy of non-discrimination in employment, including the hiring process, based on any legally protected characteristic. Legally protected characteristics include race, color, religion, national origin, sex, age, marital status, sexual orientation, disability or veteran status or any other characteristic protected by federal, state, or local law in locations where PSEG employs individuals.
PSEG is committed to providing reasonable accommodations to individuals with disabilities. If you have a disability and need assistance applying for a position, please call 973-430-3845 or email accommodations@pseg.com.
If you need to request a reasonable accommodation to perform the essential functions of the job, email accommodations@pseg.com. Any information provided regarding a disability will be kept strictly confidential and will not be shared with anyone involved in making a hiring decision.
ADDITIONAL EEO/AA INFORMATION (Click link below)
Know your Rights: Workplace Discrimination is Illegal
Pay Transparency Nondiscrimination Provision
Nearest Major Market: Long Island
Nearest Secondary Market: New York CIty