Conservation Services Group

Senior Data Analyst

Job Summary

Company:

Conservation Services Group

Category:

IT/MIS

Type:

Employee

Status:

Full Time

Relocation:

None

Industry:

All

Close Date:

09/16/13

Compensation:

Hours:

Not Applicable

Location:

Peoria, IL

Description

CSG is seeking an Oracle Data Analyst to support the company's business systems and data needs. CSG’s Peoria, IL office is responsible for administering the Ameren Electric and Gas Residential Programs. This position will be physically located in Peoria and will be a part of the local operations team.

 

The successful candidate will support Oracle database functions for the Ameren programs; and assist in database systems development, including specification of data base needs, data analysis using Oracle SQL, and writing PL/SQL scripts.

 

This position will be expected to maintain data integrity of the programs databases; to prepare regular, periodic reports and perform special analyses in a timely fashion upon request from the client or program management; assist in the testing of new features; and to provide feedback to CSG's applications development team on opportunities to improve and evolve the database system in keeping with the demands of the client and with program changes over time.

 

Responsibilities:

The Data Analyst, reporting to the Operations Manager and interfacing with all other areas of the program, is responsible for producing program data for periodic reporting to clients. In addition to reporting duties, including periodic review of content with clients, the Data Analyst is responsible for identifying processes that need refinement. These include systems integration and finding novel solutions for business challenges.

  • Manage data analysis systems for a variety of tasks, activities and reports; ensure that the database is functioning; identify program database needs; and assist in database development tasks for CSG's Applications Development team.
  • Participate in development, implementation and maintenance of data policies, objectives and plans, providing a critical interface between project staff and software developers; identify problems with current database structures, processes and procedures.
  • Develop/modify reports using SQL, Access, Oracle and Excel, interpret data/report results and self direct further analysis when needed.
  • Design, implement, and maintain operational tracking databases, as needed.
  • Develop processes, procedures and formats for data collection and reporting.
  • Interact with both internal and external customers to clarify report requests and determine report specifications.
  • Document all information related to each report generated (data source files/queries, process to run report, etc). and assist in documenting business requirements for system enhancements.
  • Diagnose existing reports for modifications and/or enhancements, as needed and discover and initiate corrective action on source data that causes problems downstream.
  • Work with the CSG and Client on measure requests and system changes to ensure program incentives and requirements are correctly captured in the client database.
  • Coordinate with program staff, contractors, and CSG corporate to oversee core application software improvements and ensure that stakeholder input is addressed, application testing is completed and new versions are deployed in a timely manner with proper training for the stake holders.
  • Prepare accurate monthly, quarterly and annual reports and develop new reports on an ad hoc basis under the direction of the Operations Manager.
  • Provide database support to administrative staff responsible for the oversight of project work, in order to ensure consistent and accurate data entry and storage.
  • Perform miscellaneous job-related duties as assigned.

Requirements

  • 3 to 5 years demonstrated experience in database management
  • 3 years experience using SQL and writing SQL scripts and queries
  • Knowledge of, and experience with, Oracle database systems and Crystal Reports highly desirable
  • 3-5 years Experience with Microsoft Access and Excel
  • Ability to develop, plan, and implement short- and long-range goals
  • Skill in examining and re-engineering operations and procedures, formulating policy, and developing and implementing new strategies and procedures
  • Excellent organizational and self-directed skills - ability to initiate, coordinate and prioritize responsibilities and follow through on tasks and projects, and ability to perform multiple tasks in an environment of frequent and often short deadlines
  • Ability to communicate effectively, both orally and in writing
  • Ability to foster a cooperative work environment
  • Strong interpersonal and communication skills and the ability to work effectively with a wide range of stakeholders

 

Salary Range: Commensurate with experience

 

CSG’s compensation package includes comprehensive medical coverage with BlueCross BlueShield Blue Care Elect PPO, dental coverage with Delta Dental PPO, and vision coverage with EyeMed Vision Care; Employer paid life and AD&D insurance and STD & LTD insurance coverage; Plus paid holidays, PTO, and employer matching 401(k) retirement plan.

 

Please apply online at: http://jobs-csg.icims.com

 

CSG is an Equal Opportunity Employer

Company

Conservation Services Group (CSG) is the leading provider of residential energy efficiency programs in North America. CSG has helped Americans make smart energy use decisions an important part of the way they live and work since 1984. The company designs, develops, and delivers innovative, results-driven programs. CSG employees are committed to a mission of delivering these comprehensive programs to help people use energy more wisely. Energy efficiency and renewable energy are our sole business, not one of a hundred departments in a large corporation. CSG provides proven expertise to utilities, state agencies, trade allies and homeowners, tenants, and property owners seeking to improve home durability, safety, air quality and comfort while saving money. We bring creativity and commitment to our goals of championing the development and use of safe, clean energy.

People who work at CSG say that it's a unique kind of organization - one that nurtures individual talents and inspires dedication. We share a commitment to our work and our mission. CSG has a collegial atmosphere, where people respect and encourage each other to help the environment and change the way our country uses energy. How about you; do you see yourself as a part of our team?