Data Management Expert

Data Management Expert

Location: On-site at Falls Church, Virginia, or Ft. Collins, Colorado

·         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