Systems Analyst - Data Warehouse Design

Position Overview

Systems Analyst – Data Warehouse Design
Location: Hybrid, Baltimore, MD
Schedule: 12 month+ contract opening
Compensation: $40/hr (W2)
This position supports a federal client, so US Citizen or Legal Permanent Resident status is required. The role involves working on complex data warehouse designs and solutions for our valued federal client while collaborating within a dynamic team.

Key Responsibilities

• Designs, develops, programs, installs, implements, and maintains internal data processing systems and utilities.
• Analyzes customer requirements, establishes system parameters, and documents both logical and conceptual data relationships for complex applications.
• Gathers information from existing systems and prepares detailed specifications and mapping documents for data transformation from source to target.
• Develops design logic, writes DDL scripts to create or update database structures (supporting Oracle and Redshift), and tunes database performance.
• Conducts quality assurance activities including peer/code reviews, gap and impact analysis, and supports overall project milestones.
• Collaborates with cross-functional teams to resolve technical/programming issues and enhance systems as required.

Required Qualifications

• Experience Required: At least 7 years of systems analysis experience in a data warehouse environment using MS tools and a minimum of 3 years in architecting data warehouse solutions, with overall general experience ranging from 9 to 13 years.
• Requirements: U.S. Citizen or Legal Permanent Resident as mandated by the federal client.
• Education: Bachelor of Science in a related field or equivalent years of experience.
• Proficiency in SQL commands, database data modeling, and performance tuning using industry tools.

Preferred Qualifications

• Experience implementing solutions using AWS Glue, MicroStrategy (2019 or higher), Oracle (10g or higher), and Redshift.
• Hands-on experience with ETL tools, metadata management (e.g., Erwin), and source-to-target mapping.
• Proven ability in developing logical and physical data models, conducting impact analyses, and drafting comprehensive system documentation.

Benefits & Perks

• Benefits: Eligible employees receive health and welfare benefits including medical, dental, vision, life insurance, and participation in a 401(k) plan.
• Opportunity to work with a leading provider of specialized services across critical infrastructure, technology, and government sectors.