Postgres Database Engineer

Ventera’s mission is to be a growing business technology consulting firm recognized for earning the loyalty of customers and employees by committing to their success. Ventera delivers innovative business and technology solutions to unique customer challenges, to help our clients achieve meaningful results. Our team brings expertise and serves as a trusted advisor to our clients in the areas of Management Consulting, Software Engineering, and Data Solutions. We strive to make Ventera a fun place to work, as well as a place where you will want to stay and build your professional career. We are a Washington Post Top 20 Workplaces Award Winner. Come Join Us!!

Position can be US based remote. We are not able to offer VISA sponsorship.

Ventera is looking for a Postgres Database Engineer to work on a cloud-based conservation analytics platform as part of a SAFe Agile scrum team. The successful candidate will be an experienced Postgres database engineer who has supported open-source and ESRI technologies in the front-end and back-end and ideally has worked with geospatial scientific data in an analytic capacity.

Responsibilities

Develop and manage performant Postgres geospatial database to support conservation analytics platform
Develop complex back-end spatial queries using Postgres and/or PostGIS
Implement and manage open source and ESRI ETL jobs and data pipelines in an AWS environment

Requirements

Proficiency in data engineering concepts, including ETL processing, data warehousing, schema design and optimization/data modeling
3 years of experience using PostgreSQL/PostGIS to complete geospatial processing
3 years of experience with PostgreSQL/PostGIS data tuning, permissions management
3 years of experience publishing services and creating web mapping applications using open-source web mapping or ESRI web mapping platforms.
Proficiency in FME model development
Proficiency in Python
Excellent communication skills

Preferred

Experience working with NRCS conservation datasets
1+ years of experience leveraging PostGIS for geospatial integration and automation
Experience with QGIS and ESRI for visualizing geospatial data
SAFe certification or experience working in an agile environment
Experience supporting a development team leveraging Git as a code repository

Perks of working at Ventera

Inclusive culture, providing a great work/life balance
Flexible work schedules
Medical, dental & vision coverage for employee
5 weeks of PTO & unlimited sick leave
Career coach development program
Educational benefits for training, conferences, certifications, tuition etc.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.