Senior Data Analyst – DoD Data Warehouse & SQL Specialist

Strategic Data Systems; Dahlgren (VA); On-site; USD 70,000 - 110,000; Full time

Job summary

Strategic Data Systems is seeking a Data Analyst to support the Dahlgren Naval Surface Warfare Center in Dahlgren, VA. The role entails data table design, data acquisition, system specifications, data validation and documentation, plus developing data interface and report specifications.

The candidate will interact with customers, provide problem resolution, and help design data models and online queries. A DoD Secret clearance is required and a strong background in data warehousing is essential.

Qualifications

• Active DoD Secret Security Clearance required.
• High School Diploma and 6+ years of experience.
• Experience with data warehouse development and design.
• Knowledge of ERP, financial and HR systems for data warehousing.
• Strong SQL and data modeling skills.
• Experience with Cognos to create reports and dashboards.
• Ability to communicate with customers and stakeholders.
• Knowledge of government accounting (DOD accounting) preferred.

Responsibilities

• Systems development activities include data table/structure design, data acquisition, system specifications, data validation and documentation.
• Data Analyst support will also include development of data interface specifications, on-line query and report specifications, database load specifications, and data validation specifications.
• Customer support, including interfacing with customers, trouble shooting, product review and analysis and problem resolution.

Skills

SQL queries

Cognos Tool Suite

Data warehousing

Relational DBMS knowledge

Analytical skills

Communication skills

Team collaboration

DOD accounting knowledge

Active DoD Secret Clearance

Education

High School Diploma

Tools

Cognos Tool Suite

Job description

Strategic Data Systems is seeking a Data Analyst to support the Dahlgren Naval Surface Warfare Center in Dahlgren, VA. The role entails data table design, data acquisition, system specifications, data validation and documentation, plus developing data interface and report specifications.

The candidate will interact with customers, provide problem resolution, and help design data models and online queries. A DoD Secret clearance is required and a strong background in data warehousing is essential.