Conservation Services Group

Data Analyst

Job Summary

Company:

Conservation Services Group

Category:

IT/MIS

Type:

Employee

Status:

Full Time

Relocation:

None

Industry:

All

Close Date:

11/19/12

Compensation:

Hours:

Day

Location:

Portland, OR

Description

  • 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, Crystal Reports, 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 the Information Services team in Westborough, MA to maintain and upgrade proprietary software.
  • 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 and submit accurate monthly, quarterly and annual reports and develop new reports on an ad hoc basis under the direction of the Program Manager.
  • Train Program staff and Contractors in the use of CSG's database systems; 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

  • Three to five years demonstrated experience in database management
  • Three years experience using SQL and writing SQL scripts and queries
  • Knowledge of, and experience with, Oracle database systems 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
  • Employment contingent on satisfactory background check
  • Ability to travel between Portland and Washington offices with overnight stay as needed (approx 2-4 days per month) 

 

Salary Range: Commensurate with experience

 

Compensation package includes paid holidays, 80% paid medical, 50% paid dental, paid life & AD&D and paid STD & LTD insurance coverage, plus employer matching retirement plan  

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?