Position: Data Management Expert
Location: On-site at , in Falls Church, Virginia, or Ft. Collins, Colorado
Client: US Fish and Wildlife Service (US FWS)
Objective:
The primary objective of this engagement is to ensure the continued enhancement, as well as maintenance and operational support of ECOSphere, which includes its seamless integration with other systems/applications, by leveraging the expertise of highly qualified technical professionals. The focus is to ensure ECOSphere remains a secure, scalable, and efficient system that serves both internal FWS users and the public.
Tasks:
Support database development, governance, quality control, metadata management, modeling, ETL processes, data warehouse/lakehouse management, compliance with relevant policies and regulations, and documentation.
· Manage data integration, governance for ECOSphere databases and data processes.
· Ensure compliance with data and metadata management policies and regulations.
· Develop and test data models, database structure and data workflows.
· Implement data pipelines using AWS, Databricks, and other ETL solutions.
· Support the development and maintenance of Data Lakehouse architectures, including graph databases.
· Develop APIs to make necessary FWS data available to the public.
· Ensure technical documentation is accurate and thorough:
o System configurations, API documentation, and standard operating procedures.
o Data integration workflows and security protocols.
o Performance dashboards tracking key metrics and system health.
· Complete weekly status reports detailing work completed, issues, and upcoming milestones
Requirements/Skills:
· Databricks, Data Lakehouse Solutions, Delta Lakes
· SQL Server Management Studio, SQL Server Integration Services (SSIS), Postgres SQL, ETL Tools such as FME, Big Data Technologies
· AWS QuickSight, SQL Server Reporting Services (SSRS), Data Validation, Data Mapping and Migration, Data Modeling, Database design and development
· Data and Metadata management, Data Governance
· Graphing databases including ESRIs ArcGIS Knowledge graph software and analytics
· SQL, Python, R
