Organization: Innovate!, Inc.
Title: GIS Database Administrator
Data Analyst and Engineering Services
Innovate! Inc. is seeking a highly motivated individual to join its geospatial solutions team as a Data Analysis to support a project under the National Park Service (NPS). The contractor team will bring journeyperson/intermediate-level knowledge of data development and data systems engineering. A Data Engineer, or Data Systems Engineer, is responsible for developing and maintaining data processing software and for requirement capture, database development, data documentation, and development and maintenance of data processing pipelines. Their duties include coordinating with NPS staff to create unique data infrastructure, running tests on their designs to isolate errors, and updating systems to accommodate changes in NPS needs.
*Contingent upon contract being awarded*
Develop data models, database schemas, data pipelines, and perform data migration activities. Migrate data from as-is to to-be data structures.
Maintain expertise in SQL and python programming to write procedural code for databases including Microsoft SQL Server and PostgreSQL (T-SQL or PL/pgSQL code).
Understand enterprise-level spatial data management, its unique characteristics, and how to effectively store spatial data within RDBMS and geodatabases.
Create data migration plans documenting key activities, tasks, and risks associated with populating new solutions with all current and historical data necessary for correct operation of the solution. Monitor and report progress of the data migration plan at project level.
Build required coding and/or infrastructure for optimal extraction, transformation, and loading of data from various data sources using Cloud and SQL technologies.
Perform analysis to assess quality and meaning of data. Document data business and quality rules and requirements and implement them into data engineering activities.
Design a quality management process and plan for data migration activities including validation of loaded data to ensure the maximum efficiency and accuracy of data populated within the new solution.
Identify, design, and implement internal process improvements including redesigning infrastructure for greater scalability, optimizing data delivery, and automating manual processes.
Work with stakeholders and customers and assist them with data-related technical issues and data infrastructure needs.
Work with ISS and other NPS staff to identify process improvement opportunities and propose system modifications. Create presentations and reports based on recommendations and findings.
Structure small and large data sets appropriate to the intended audience or application to support efficient retrieval of usable information. Perform data requests as needed.
Define and maintain domain definition requirements for a complete set of permissible values for an attribute/column.
Work with a team of analysts, database administrators, GIS specialists, and other personnel to process alphanumeric and geospatial information and to support data governance activities.
Develop and document appropriate metadata records (business, technical, process, and operational) for the contents of developed data management systems and data standards.
EDUCATION AND EXP.
At least have 3 years of experience with data analysis and engineering activities including data schema development and data migration activities.
Bachelor’s degree in GIS, geography, computer science, or related field
LEARN MORE ABOUT US
Innovate! Inc. is a woman and minority-owned company passionate about the dynamic benefits of providing effective management consulting, IT support, and geospatial technology for the federal government. We believe that thinking innovatively can achieve positive results in organizations that lead to cultural and business change. This belief and our ability to deliver cutting-edge solutions were recognized with Innovate being named 2012 Environmental Protection Agency (EPA) Outstanding 8(a) Small Business of the Year. Innovate is a fast-paced, rapidly growing group of entrepreneurs creating a culture of excellence. Rapid advancement within our organization is not only possible it is encouraged.
To view our website, visit http://www.innovateteam.com.
Innovate! Inc. proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active-Duty Wartime or Campaign Badge Veteran, Armed Forces Services Medal, or any other characteristic protected by law.
Apply on our Career page: Innovate Public Job Board. If you need assistance or accommodation due to a disability, you may contact us at [email protected] or 703.922.9090 x5.
This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee.
SALARY AND BENEFITS:
To learn more about Innovate’s benefits, please click here: Benefits
To request salary range information for this position, please click here: Salary
All Contents © 1999-2022. The GIS Jobs Clearinghouse