Database Engineer

Community Data Platforms

About Community Data Platforms:

Community Data Platforms believes communities get smarter and stronger by using evidence-based decision-making. CDP supports this mission by building data platforms in communities across the country to help leaders and decision-makers answer their Pressing Questions.

With a five-year goal of serving 100 communities, CDP believes it can support data-driven decision-making among governments, businesses, and nonprofits, leading to better outcomes among a range of critical community organizations. Communities have pressing questions and CDP’s team and approach develops actionable insights and communicates them clearly by using advanced visualizations. We believe a community data platform is an essential community service.

Working with Community Data Platforms:

We’re looking for ambitious and resourceful people to join a rapidly growing start-up serving communities across the country. Benefits include:

  • A culture of intellectual humility and a passion for understanding the world around us (we don’t care who’s right – we care what’s right!)
  • Working with driven and intellectually curious people who are experts in their fields
  • A close-knit team that is devoted to a common mission
  • The opportunity to be involved at the early stages of a start-up with enormous potential
  • Being at the forefront of the big data wave and its application to community-based decision-making
  • Remote working environment – you set your own hours and complete your work on your own time – no micromanaging!

Duties and Responsibilities:

The Database Engineer will be responsible for organizing and improving a growing data warehouse for a fast-paced organization. They will support various teams to create scalable solutions to answer pressing questions across multiple communities in the United States. An excellent candidate will work directly with ETL developers, data scientists, and dashboard developers to advise the storage process from raw data to actionable insight.

Effective communication is essential. A strong foundation in data storage principles and design is mandatory. The Database Engineer must be adept at working alongside colleagues with varying backgrounds and technical expertise. The position requires versatility and creative thinking in order to meet business goals.

Regular activities will include user group management, the participation in brainstorm sessions, the research of appropriate solutions and the translation of data science results into dashboard-ready tables. A successful candidate should demonstrate experience analyzing issues holistically, from the application tier through the database, down to the storage.

Requirements include:

  • A bachelor’s degree and previous database engineering experience. This includes at least 1 year of experience developing PostgreSQL solutions in an enterprise environment.
  • Experience with Linux-based cloud computing systems (AWS).
  • Ability to design and organize a data warehouse for efficiency and scalability. Knowledge of normalization and denormalization techniques such as dimensional modelling and NoSQL paradigms preferred.
  • Know how to create Airflow DAGs to create ELT and ETL processes, perform web scraping, and other data management tasks.
  • Expert level scripting of regular processes using Python (Object Oriented and Functional) and SQL.
  • Ability to productionize Jupyter Notebook and R scripts written by data science colleagues into Airflow DAGs.
  • Proficiency with managing database user groups.
  • Conversational English to answer technical questions posed by ETL team members.
  • Demonstrated ability to work effectively with multiple managers simultaneously to meet business timelines.
  • Awareness of emerging technologies and approaches in IT to keep the company at the forefront of innovation.

Optional:

  • Maintain cloud infrastructure on AWS and DigitalOcean.
  • Maintaining SSL Certifications and manage web servers, including Apache, Nginx, and Node deployments.
  • Troubleshooting user issues with OpenVPN/FreeIPA (LDAP Authentication).

Preferred Specific Technologies:

  • PostgreSQL Database Administration.
  • Linux (Ubuntu, CentOS) Systems Administration.
  • Airflow.
  • FreeIPA.

Please send a resume and cover letter using as subject line “Database Engineer – 2021