Senior Database Engineer Offline

Details

Project description: data platform for communities across the USA to help leaders and decision-makers answer their Pressing Questions. With a five-year goal of serving 100 communities, the client can support data-driven decision-making among governments, business, and nonprofits, leading to better outcomes among a range of critical community organizations. Communities have pressing questions and the team and approach develop actionable insights and communicates them clearly by using advanced visualizations. A community data platform is an essential community service.

Requirements

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;

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;

Conversational English to answer technical questions posed by ETL team members.

Would be a plus

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).

Responsibility

The Database Engineer will be responsible for organizing and improving a growing data warehouse for a fast-paced organization;

To support various teams to create scalable solutions to answer pressing questions across multiple communities in the United States;

To work directly with ETL developers, data scientists, and dashboard developers to advise the storage process from raw data to actionable insight;

A strong foundation in data storage principles and design is mandatory.