Position: Senior Database Engineer
Company: GeeksForLess
Category: SQL
Experience required: 5y
English level: upper
Published: 2021-05-01T00:00:00+03:00

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