GIS Database Engineer

Job Family:

Travel Required:

Clearance Required:

What You Will Do:

The GIS Database Engineer (DBE) will work as part of a team supporting data analysis management processing and automation for a Security & Installations/Infrastructure office within the National Geospatial-Intelligence Agency (NGA). The DBE position will be responsible for translating business and IT requirements into robust data architecturesdesigning developing and implementing relational and objectoriented databases. The DBE will also deliver usable data assets by creating and updating ad hoc queries scripts and macros to build complex scalable systems from inception through system acceptance testing and Initial Operational Capability (IOC). Additionally this position is part of Guidehouses broader AI & Data horizontal team offering reach back and connectivity to firm-wide network of data practitioners. Additional specific duties include:

• Provide technical expertise for database design development implementation information storage and retrieval data flow and analysis.

• Develop relational and/or Object-Oriented databases database parser software and database loading software.

• Project long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes number of users logical and physical distribution response times retention rules security and domain controls.

• The DBE works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC).

• Develops requirements from a projects inception to its conclusion for a particular business and IT subject matter area (i.e. simple to complex systems).

• Assist with recommendations for and analysis and evaluation of systems improvements optimization development and/or maintenance efforts.

• Translate a set of requirements and data into a usable document by creating or recreating ad hoc queries scripts and macros; updates existing queries creates new ones to manipulate data into a master file; and builds complex systems using queries tables Open Database Connectivity and database storage and retrieval using Cloud methodologies.

What You Will Need:

• ACTIVE Top Secret SCI clearance and the ability to obtain a CI poly within 30 days of starting

• Bachelors Degree and TEN (10) or more years relevant experience OR NINE (9) or more years relevant experience with a Masters Degree

• Demonstrated experience working with GIS data in various formats such as vector or raster

• Experience with programming languages and database creation

• Extensive experience designing developing and administering GIS databases including spatial data management geodatabase design and enterprise system integration.

• Strong ArcGIS Enterprise expertise (Pro Server Online key extensions) including spatial analysis geoprocessing and web map application development.

• Experience automating GIS workflows (Workflow Manager or similar tools).

• Strong RDBMS experience (Oracle SQL Server PostgreSQL) with proven SQL query optimization for spatial data.

• Python scripting proficiency for geospatial processing and automation plus JavaScript experience for web development.

• Extensive experience developing geospatial data models including schema design validation and maintenance.

• Extensive data integration experience (ETL API) focused on integrating GIS with enterprise systems.

• Familiarity with Agile principles.

• Excellent communication and collaboration skills effectively conveying technical concepts to diverse audiences.

• Strong analytical and problem-solving skills for complex geospatial issues.

• Experience integrating BIM data with GIS platforms including solid BIM understanding.

• Willingness to explore and experiment with new geospatial technologies.

What Would Be Nice To Have:

• Experience working with CAD files

• Experience working within the Intelligence Community and familiarity with IC security and systems & installation protocols

What We Offer:

Guidehouse offers a comprehensive total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical Rx Dental & Vision Insurance

• Personal and Family Sick Time & Company Paid Holidays

• Position may be eligible for a discretionary variable incentive bonus

• Parental Leave and Adoption Assistance

• 401(k) Retirement Plan

• Basic Life & Supplemental Life

• Health Savings Account Dental/Vision & Dependent Care Flexible Spending Accounts

• Short-Term & Long-Term Disability

• Student Loan PayDown

• Tuition Reimbursement Personal Development & Learning Opportunities

• Skills Development & Certifications

• Employee Referral Program

• Corporate Sponsored Events & Community Outreach

• Emergency Back-Up Childcare Program

• Mobility Stipend

About Guidehouse

Guidehouse is an Equal Opportunity EmployerProtected Veterans Individuals with Disabilities or any other basis protected by law ordinance or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities or to apply for a position and you require an accommodation please contact Guidehouse Recruiting at 1- or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @ or . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse please report the matter to Guidehouses Ethics Hotline. If you want to check the validity of correspondence you have received please contact . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicants dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.