Senior Data Analyst

Willdan

2h

About The Position

Willdan Energy Solutions (WES) is one of the nation's preeminent providers of specialized energy, water, and resource management services to a growing list of clients that includes utilities, local and federal governments, hospitals, schools and private enterprises. WES's portfolio of services includes marketing and engineering, program management and implementation of energy efficiency and water conservation programs and development and implementation of information systems for the energy industry. WES's expertise also covers hardware retrofits, commissioning and retro-commissioning, demonstrations of new technologies, energy efficiency education/outreach, sustainability strategy and local government partnerships.

Willdan Lighting & Electric (WLE), a subsidiary of WES, is seeking a Senior Data Analyst to work on our energy efficiency programs in New Jersey. The Senior Data Analyst will develop and support program tools/automations as well as database efforts.

Requirements

• 4+ years of experience with relational database (Microsoft SQL server), including table structuring, creating queries and stored procedures.
• 2+ years of development experience with object-oriented languages.
• Proficiency in advanced Microsoft Excel and Visual Basic for Applications (VBA) including creating/editing macros.
• Bachelor’s in computer science, information technology, engineering or related field or equivalent experience.
• Good communication skills – both written and oral.
• Must be able to work independently, and in team environments.

Responsibilities

• Create and maintain reports, dashboards, and visualizations as needed by program.
• Design and develop tables, views, stored procedures, indexes, functions, dictionaries, and complex ad- hoc queries for SQL Server databases.
• Work with program management team to prioritize business and reporting/data needs.
• Identify potential risks and issues in any requested data reporting or changes in existing data reports.
• Ensure data integrity and accuracy across all data reporting.
• Exercise critical thinking to identify opportunities to reduce manual processes through automation.
• Communicate/coordinate with team to ensure proper implementation of company standards and procedures.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level