Azavea is a civic technology firm based in Philadelphia that uses geospatial data to build software and data analytics for the web. As a B Corporation
, our mission is to use advanced geospatial technology for civic, social, and environmental impact. Most of our work deals with local governments, non-profit organizations, and academic or federal research projects. We build custom web applications, perform geospatial analysis, and manage SaaS products in several civic domains.
We are looking for a Database Specialist to contribute to the Cicero product. Cicero
is a global database of elected officials and legislative districts that is made available as an API, as a batch processing system, and as a licensed database. Cicero enables non-profits and other civic organizations to advocate more effectively by connecting constituents with their elected officials at the national, state, and local levels for over 350 cities and counties in nine countries. Ideal candidates have experience working with large data sets, are passionate about learning, and are willing to support a growing SaaS product. We’re excited about what we do, we’re growing, and we hope you will join us.
Skills & Requirements
Your core responsibility will be researching, entering, and ensuring the quality of our data. However, this position will also allow for the opportunity to advance the product through content marketing efforts and brainstorm and develop new ways for our customers to have improved access to our data.
What You’ll do:
- Develop a thorough knowledge of the Cicero database and its architecture
- Research and enter election results, and update contact information for legislators in 9 countries
- Work with the rest of the Cicero team to ensure timely and accurate updates to our data
- Perform regular data-driven quality checks on the database to identify gaps and inconsistencies in the data
- Write technical and non-technical blog articles and marketing content around Cicero data, including topics like: grassroots advocacy, legislator demographics and trends, redistricting, gerrymandering, and elections
- Display a meticulous attention to detail
- Have experience working with and ensuring the quality of large datasets
- Know SQL and be able to use it to query and pull data from a relational database
- Possess excellent writing skills
- Be interested in technology, elections, and democracy
- Have a strong desire to learn, and the drive to improve a growing product
You get extra points for:
- Knowledge of REST APIs
- Experience with GIS analysis, including digitizing, geocoding, spatial analysis, or cartography
- Familiarity with using Python or R for data analysis
- Formal marketing or business development experience, especially in relation to a SaaS product
Office and Benefits
Our Philadelphia headquarters is located in a brightly lit office on the 5th floor of a converted factory building in the Callowhill neighborhood, a short walk from Center City, the Reading Terminal Market, and SEPTA subway and regional rail stations. For bicyclists, we have in-house bike parking, a shower and lockers. The office itself is assembled as an open office plan with several smaller rooms for team meetings and concentration time. You get your own desk with a high-end Linux workstation or Apple laptop and extra monitors. We have flex-time to deal with personal stuff, and most people work a 40 – 45 hour week on a regular schedule. After the first six months, our staff can also spend up to 10% of their time on an open source, professional development, or research project. Recent 10% time projects include experiments with functional programming, machine learning, mapping with vector tiles, t-shirt design with satellite imagery, and experiments with large geospatial data sets.
We offer a salary commensurate with skills and experience and a benefits package that includes:
- Fully subsidized health care, dental, prescription plan, including for spouse/partner and children
- Fully subsidized life and long-term disability insurance, plus voluntary short term disability insurance
- Medical reimbursement plan to cover what the health insurance does not
- Retirement plan with matching percentage
- Almost 4 weeks paid vacation plus additional paid sick/personal time off
- Family and medical leave
- Flexible work schedule
- Paid maternity and paternity leave
- Child care subsidy
- Paid time off for voting and volunteering
- Education assistance plan
- Student loan assistance
- Public transit and biking reimbursement plans
- Monthly guest lectures with lunches on the house
- 10% time for research or learning projects
- Profit-sharing bonus plan
- Financial transparency through an open book policy
- Kind, capable and thoughtful colleagues
We welcome qualified candidates from all walks of life and value diversity in our company. We prohibit discrimination based on race, color, religion, ancestry, national origin, sex, sexual orientation, gender identity, age, veteran status, military service, disability unrelated to job requirements, marital status, or domestic partner status.
Azavea is on the map for the company’s mobile and web geospatial data applications. Employees say the client-based and internal projects are the most challenging they’ve ever taken on. It’s not surprising; Azavea has taken on projects with the U.S. Department of Energy, The World Bank and NASA.
The 65-person company doesn’t view “company culture” as ping pong tables and happy hours, though both have a place in its office in the Callowhill neighborhood of Philadelphia. Instead, “culture” is a reflection of the values the company already has. When the company was established in 2001, founders Robert Cheetham and Rachel Cheetham-Richard considered forming a nonprofit company but came to the conclusion that it’s possible to be a for profit company that’s not only for profit. B Corp certified, Azavea is committed to improving the world. The commitment is reflected in projects like NYC TreesCount! for NYC Parks, GoPhillyGo for the Clean Air Council or OpenDataPhilly. If it harms communities or the environment, they’ll pass, even when evaluating new business opportunities.
The growing company treats its employees with the same respect. In addition to a generous set of benefits, team members successfully balance hobbies, family and friends — and take their vacation days. Azavea’s culture is democratic throughout the hiring process and allocation of profits — at least 2 percent a year — to nonprofit organizations. Every team member has a voice at the table.
The office itself is as open-minded and inclusive as the company. Meetings are held in the expansive kitchen or smaller rooms named after cities. Visitors may find Azaveans tucked in the library nook or collaborating in the open floor plan. Employees often stop to talk around the healthy snacks selection (an idea submitted during Azavea’s annual meeting to solicit feedback from employees) on the kitchen island.