Senior Data Platform Engineer & Analytics Lead

General Dynamics Information Technology; Virginia; On-site; USD 110,000 - 150,000; Full time

Job summary

General Dynamics Information Technology (GDIT) invites applications for a Database Analyst/Administrator to support the AOUSC Mission Support Systems Division. The role involves agile development practices, data modeling, DW concepts, and cloud-based database solutions across SQL Server, Informix, Oracle, Snowflake, and Azure.

The candidate will design data warehouses, develop ETL pipelines, and produce dashboards and reports to drive program outcomes, with strong emphasis on data quality and

Qualifications

• 7+ years of server database maintenance or related role.
• Degree in CS/Engineering or equivalent experience.
• Database certifications preferred (Azure, SQL Server).
• Proficient with SQL Server, Informix, and Oracle.
• Experience with Snowflake and Azure cloud platforms.
• Understanding of data warehousing concepts.
• Adept in data modeling, mapping, flows, and data marts.
• Experience building cloud-based database solutions.
• Experience migrating data from on-prem to multi-cloud.
• Strong problem-solving, communication, and time management.

Responsibilities

• Participate in Agile SCRUM rituals with daily stand-ups and sprint planning.
• Develop operating standards for performance, security, and scalability.
• Define data elements and ensure proper data relationships and integration.
• Gather business requirements from Product Owners and stakeholders.
• Document complex workflow designs for the project team.
• Analyze complex data problems and contribute to new business strategies.
• Collect, analyze, and interpret large data sets to guide decisions with stats and data mining.
• Create data visualizations and dashboards to track KPIs and metrics.
• Review code with peers and validate data accuracy and integrity.
• Develop stored procedures, views, tables, and database objects in SSMS.
• Design dimensional models (star/snowflake) and data marts for BI.
• Develop and deploy ETL packages using CI/CD; manage version control.
• Work with Atlassian tools for project management.
• Index logs in Splunk and create dashboards, alerts, and reports.

Skills

Database maintenance

Database analysis

Data modeling

Data mapping

Data flow diagrams

Data marts

Analytical skills

Communication skills

Time management

Independent work

Education

Bachelor's degree in Computer Science/Engineering

Tools

SQL Server

Informix

Oracle

Snowflake

Azure

Job description

General Dynamics Information Technology (GDIT) invites applications for a Database Analyst/Administrator to support the AOUSC Mission Support Systems Division. The role involves agile development practices, data modeling, DW concepts, and cloud-based database solutions across SQL Server, Informix, Oracle, Snowflake, and Azure.

The candidate will design data warehouses, develop ETL pipelines, and produce dashboards and reports to drive program outcomes, with strong emphasis on data quality and