ETL Developer

Vantor is forging the new frontier of spatial intelligence, helping decision makers and operators navigate what’s happening now and shape what’s coming next. Vantor is a place for problem solvers, changemakers, and go-getters—where people are working together to help our customers see the world differently, and in doing so, be seen differently. Come be part of a mission, not just a job, where you can: Shape your own future, build the next big thing, and change the world.To be eligible for this position, you must be a U.S. Citizen. This position requires an active U.S. Government security clearance, applicants who do not currently hold the required clearance will not be eligible for consideration. Employment for cleared roles is contingent upon verification of clearance status. Export Control/ITAR: Certain roles may be subject to U.S. export control laws, requiring U.S. person status as defined by 8 U.S.C. 1324b(a)(3).Please review the job details below.This position requires an active U.S. Government Security Clearance at the TS/SCI clearance with required Polygraph.We are seeking an experienced ETL Developer to provide onsite support for a geospatial visualization platform. This role focuses on developing, maintaining, and optimizing data pipelines to ensure reliable data flow into a PostgreSQL database. The ideal candidate will have strong experience in ETL processes, data integration, and working with large, complex datasets, including geospatial data.Responsibilities: Design, develop and manage ETL workflows using Apache NiFi to support a geospatial visualization platformLearn the nuances of the existing NiFi system and the related AWS and PostgreSQL infrastructure in order to monitor and troubleshoot real time issuesObtain an understanding of existing NiFi flows with minimal support from othersDevelop new NiFi flows that adopt best practices of existing NiFi flowsTake feedback on NiFi flows and develop requested changesTake direction and communicate status via a ticketing systemInterface with analysts via email, chat, and in person meetings to comprehend future data flow needs and refine general requirements into specific actionsInterface with a development cycle using a local development environment of containerized infrastructure and version control via Git and NiFi RegistryGain competency in geospatial database design and employ best practices for table creation, indexing, and unique constraintsTake feedback from analysts on nuances to support application data layersProgrammatically manipulate and transform data from multiple sourcesQuery and analyze large datasets using SQLRetrieve and process data from external systems via APIsSupport data quality, integrity, and performance optimization effortsUnderstand Python and data science frameworks while differentiating between experimental prototypes and enterprise level software requirementsDevelop Python in support of data science related efforts or ETL prototypesMinimum Qualifications: Experience:Bachelor’s degree with 8+ years of relevant experience, ORMaster’s degree with 7+ years of experience, ORDoctorate with 6+ years of experienceDegree in Computer Science, Systems Engineering, Geography, or a related technical fieldActive TS/SCI clearance with required polygraphU.S. Citizenship requiredWillingness to work onsite full-timeWillingness to develop NiFi flows using existing best practicesStrong understanding of ETL concepts and best practicesStrong experience with databases for data managementProficiency in SQL for querying large datasetsExperience with API integration and data retrievalDemonstrated experience with programmatic data manipulationCompetency to rapidly adopt containerized development proficiencyCompetency to rapidly adopt AWS architecture proficiencyCompetency to rapidly adopt NiFi registry and Git for code managementPreferred Qualifications: Creativity to experiment and recommend best practice coding improvementsDrive to adopt and recommend AI into development processesAbility to design and develop custom NiFi processors using JavaExperience with AWS cloud services for data ingestion and processingStrong experience with PostgreSQL for data managementHands-on experience with Apache AirflowHands-on experience with Apache NiFiHands-on experience with NiFi registry and GitHands-on experience with Git and repository actions and pull requestsHands-on experience in Python for data manipulation and API interfacingExperience working with geospatial data and related toolUnderstanding of basic data science concepts and toolsPay Transparency: In support of pay transparency at Vantor, we disclose salary ranges on all U.S. job postings. The successful candidate’s starting pay will fall within the salary range provided below and is determined based on job-related factors, including, but not limited to, the experience, qualifications, knowledge, skills, geographic work location, and market conditions. Candidates with the minimum necessary experience, qualifications, knowledge, and skillsets for the position should not expect to receive the upper end of the pay range.The base pay for this position within California, Colorado, Hawaii, New Jersey, the Washington, DC metropolitan area, and for all other states is:$200,000.00 - $250,000.00Benefits: Vantor offers a competitive total rewards package that goes beyond the standard, including a robust 401(k) with company match, mental health resources, and unique perks like student loan repayment assistance, adoption reimbursement and pet insurance to support all aspects of your life. You can find more information on our benefits at:The application window is three days from the date the job is posted and will remain posted until a qualified candidate has been identified for hire. If the job is reposted regardless of reason, it will remain posted three days from the date the job is reposted and will remain reposted until a qualified candidate has been identified for hire.The date of posting can be found on Vantor's Career page at the top of each job posting.To apply, submit your application via Vantor's Career page.EEO Policy: Vantor is an equal opportunity employer committed to an inclusive workplace. We believe in fostering an environment where all team members feel respected, valued, and encouraged to share their ideas. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, gender identity, sexual orientation, disability, protected veteran status, age, or any other characteristic protected by law.SummaryLocation: McLean, VAType: Full time