Community Indicators for Your Community

Real, lasting community change is built around knowing where you are, where you want to be, and whether your efforts are making a difference. Indicators are a necessary ingredient for sustainable change. And the process of selecting community indicators -- who chooses, how they choose, what they choose -- is as important as the data you select.

This is an archive of thoughts I had about indicators and the community indicators movement. Some of the thinking is outdated, and many of the links may have broken over time.

Tuesday, April 8, 2008

Job Opening: Social Compact

Some of you are really good at the technical side of metrics. One of you may be perfect for this position announcement:

JOB OPPORTUNITY: Database Administrator

The Database Administrator is a full-time position responsible for the management of Social Compact's relational database environment and design and maintenance of a database warehouse. Database Administrator will supervise the importing of raw data, monitor datasets, provide quality control, automate data aggregation processes, plan for future data and technology needs, and provide technical assistance to research staff.


* Management and design of the data integration process - aggregating
diverse datasets in complex and creative ways to build alternative market and demographic indicators across multiple cities.
* Manage SAS Server, SAS Enterprise Guide
* Support and maintain relational databases and applications, design
queries and reports for users. Pro-actively develop reporting solutions for staff.
* Supervise the process of data importing, geocoding, and cleaning of
* Ensure that data are properly geocoded and cleaned before
aggregating to neighborhood indicators.
* Identify appropriate data sources to expand the indicators and
improve reliability.
* Work with staff to integrate indicators into reports and market
* Respond data requests and provide assistance and training where
* Work collaboratively with research staff on a variety of projects
* Meet with community leaders, city planners and other researchers to
explain the data aggregation process to individuals with diverse levels of technical and research expertise.


The ideal candidate for this position will have the following
* Bachelor's degree in computer science or extensive
programming/database management experience; and 2 years of experience in database management, spatial and statistical analysis. Advanced degree preferred.
* Demonstrated proficiency in SQL
* Programming skills, preferably including VB and VBA
* Experience working with and designing geo-databases
* Knowledge of GIS mapping applications
* Prior experience with SAS and SAS Enterprise Guide is highly
* Proficiency in Microsoft Office
* Ability to work both independently and as a team-member within tight
* Interest in issues related to urban areas, economic development and
poverty alleviation

The Social Compact, Inc. is a DC-based nonprofit organization launched in 1990 by a coalition of business leaders who came together to promote successful business investment in undervalued communities for the benefit of current residents. This is largely done through the Neighborhood Market DrillDown, a pioneering market analysis model built on innovative sources of dependable, business-oriented data that reveals the hidden strengths of traditionally undervalued communities.

Questions about the opening and hiring process can be addressed to Ryan Sullivan (

Ryan Gerety
Associate Director, Research
The Social Compact, Inc.
738 7th Street, S.E.
Washington, DC 20003
United States

Tel: 001 202 547 2581
Fax: 001 202 547 2560
Cel: 001 505 315 5532


Post a Comment