Sr. Database Operations Analyst
Sr. Database Operations Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Number:6921
External Description:
PSEG offers a unique experience to our more than 12000 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 departments 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)
- Bachelors 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. Drivers 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
LocationformattedLocationLong:Melville New York US
Required Experience:
Senior IC
Employment Type
Full Time
