Senior Data Platform & Analytics Engineer

General Dynamics Information Technology, Inc.

Virginia (MN)

On-site

USD 120,000 - 160,000

Full time

3 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

General Dynamics Information Technology, Inc. is seeking a Database Analyst/Administrator to join AOUSC Mission Support Systems Division.

You will operate in an SAFe environment, develop standards, and manage data elements and relationships across complex systems. The role emphasizes data warehousing, ETL, SQL Server, Snowflake, and cloud migrations; you will create dashboards, validate data, perform peer reviews, and collaborate with product owners to translate business needs into technical

Qualifications

At least seven (7+) years of server database maintenance and database analysis experience.
Bachelor's degree in Computer Science, Computer Programming, Computer Engineering or a related field; experience may be considered in lieu of degree.
Database or cloud certification preferred (e.g., Microsoft Azure Database Administrator Associate, Azure Solutions Architect Expert).
Proficient with databases such as Microsoft SQL Server, Informix, Oracle.
Experience with Snowflake and Azure cloud platform.
Experience with database environment installation, configuration, and ongoing administration support.
Understanding of standard data warehouse concepts.
Adept at data modeling, data mapping, data flow diagrams and data marts.
Experience architecting and implementing cloud-based database solutions and data migration to multi-cloud/hybrid environments.
Proven ability to work independently, prioritize tasks and deliver.
Strong analytical, technical, problem-solving skills.
Excellent organization and time management and ability to prioritize tasks.
Excellent written and oral communication skills.

Responsibilities

Works within an Agile solution development environment with daily scrums, biweekly sprint planning and quarterly Program Increment planning.
Develops operating standards and best practices, including performance, security, scalability, and maintainability.
Ensures proper definition, control, and coordination of data elements and standards and facilitates efficient data relationships, systems integration, and physical structure.
Participates in development and implementation of database management policies and standards for quality control and data administration.
Collaborates with Product Owners and users to gather business requirements and map to technical requirements; meets with agency leaders and stakeholders on innovative data analysis techniques.
Documents complex workflow designs for project teams and stakeholders.
Works on complex problems and contributes to new business strategy within Agile practices.
Collects, analyzes, and interprets large data sets to guide business decisions; uses advanced statistics, data mining, and predictive modeling.
Synthesizes information and creates data visualizations to track KPIs and metrics tied to program outcomes.
Hosts peer reviews of code and performs data validation and integrity checks.
Develops stored procedures, jobs, views, and tables in SQL Server Management Studio.
Designs dimensional data models including start and snowflake schemas, fact and dimension tables, and data marts.
Develops and deploys ETL packages using CI/CD pipelines; uses version control systems.
Works with Atlassian Suite tools.
Indexes logs in Splunk and creates dashboards, alerts, and reports.