Data Engineer

ASCENDING LLC • Full-time • Burke, VA, Fairfax County, VA, US • $0 / year • 3d ago

Title:Data Engineer Term: Long term contract Location: 100% remote Availble for W2 or 1099, No C2C/3rd Parties Please. Candidate Must able to obtain Public Trust. Our client 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 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 database to support conservation analytics platform Develop complex back-end queries using Postgres and/or PostGIS Implement and manage 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 Overall 6 years of experience 3 years of experience using PostgreSQL to support high performant data analytics platform 3 years of experience with PostgreSQL data tuning, permissions management Excellent communication skills Experience leveraging Git as a code repository Preferred Experience working with NRCS conservation datasets Experience leveraging PostGIS for geospatial integration and automation Experience with QGIS and ESRI for visualizing geospatial data Experience publishing services and creating web mapping applications using open-source web mapping or ESRI web mapping platforms. Experience in FME model development Experience in Python Experience with Liquibase or any equivalent database deployment tool. Familiarity with Visualization tools like Tableau, PowerBI SAFe certification or experience working in an agile environment 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. Thanks for applying