Database Engineer

Database Engineer

Please apply to: codingjobs@communitydataplatforms.com
Use the subject line “Database Engineer – 2021”

About Community Data Platforms

Community Data Platforms is on a mission to help leaders better understand and better serve their communities by leveraging commercial and public data sets, developing advanced data solutions, and delivering actionable insights to leaders’ most urgent questions.

Leaders of the largest organizations in the country admit they don’t understand communities well. It’s where they sell billions of dollars of products and develop policies that affect millions of people. And yet, they admit they make decisions based on anecdotes. While data are used for all sorts of business decisions, no one has ever aggregated multi-source data and developed an analytics team dedicated to providing clarity about communities – the places where millions of Americans live, work, and receive services.

CDP is developing the “community data” category and intends to “own” it. We believe communities get smarter and stronger by using evidence-based decision making. 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 across a range of critical community functions.

Working with Community Data Platforms

Community Data Platforms is working with leaders across the country to solve problems in policy areas including healthcare, housing, and transportation. We’re looking for ambitious and resourceful people to join a rapidly growing start-up serving communities across the country.

  • 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 a critical stage as CDP moves from “start-up” to “scale-up” with enormous potential
  • Being at the forefront of the big data wave and its application to enterprise and community organization users
  • Remote working environment – you set your own hours and complete your work on your own time – no micromanaging!
  • Huge growth potential for correct candidate
  • Competitive salary

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 to:  codingjobs@communitydataplatforms.com
Use the subject line “Database Engineer – 2020”

Scroll to top