Remote Senior DB Architect for BI & DW

General Dynamics Information Technology, Inc.; United States; Remote; USD 108,000 - 138,000; Full time

Job summary

General Dynamics Information Technology, Inc. (GDIT) seeks a Database Analyst/Administrator to join AOUSC MSSD in mission-critical federal court systems. The role operates in an Agile SAFe environment, developing data standards, integrating data across systems, and delivering BI solutions.

The candidate will design and implement database structures, ETL processes, and analytics dashboards, collaborating with stakeholders and product owners while ensuring data quality and security.

Qualifications

• At least seven (7+) years of server database maintenance and analysis.
• Bachelor's degree in CS/Engineering or relevant major; experience may be considered in lieu of degree.
• Database or cloud certification preferred (e.g., Microsoft Azure DB Admin Associate / Azure Solutions Architect Expert).
• Proficient with Microsoft SQL Server, Informix, Oracle.
• Experience with Snowflake and cloud platforms (Azure).
• Experience with data warehousing concepts, data modeling, mapping, data flows and data marts.
• Ability to work independently, prioritize tasks, and communicate effectively.

Responsibilities

• Develops standards for performance, security, scalability, and maintainability.
• Maps business requirements to technical data solutions in an SAFe/agile environment.
• Designs dimensional models and data marts to support analytics and BI.
• Develops ETL packages and CI/CD pipeline implementations.
• Indexes logs in Splunk and builds dashboards, alerts, and reports.
• Collaborates with Product Owners and stakeholders to refine requirements.
• Performs data validation and ensures data accuracy and integrity.
• Hosts code reviews and supports deployment of database objects.

Skills

Business Intelligence (BI)

Database Architecture

Data Warehousing (DW)

Relational Data Modeling

Education

Bachelor's degree in Computer Science/Engineering or related major

Tools

Microsoft SQL Server

Informix

Oracle

Snowflake

Azure Cloud Platform

Job description

General Dynamics Information Technology, Inc. (GDIT) seeks a Database Analyst/Administrator to join AOUSC MSSD in mission-critical federal court systems. The role operates in an Agile SAFe environment, developing data standards, integrating data across systems, and delivering BI solutions.

The candidate will design and implement database structures, ETL processes, and analytics dashboards, collaborating with stakeholders and product owners while ensuring data quality and security.