Systems Analyst - Data Warehouse Design
Baltimore, MD
Experience: 0
Category: Information Technology
Contractor Work Model: Hybrid
Brand: System One
Compensation Range: 40.00 Per Hour
Job ID: 345603
Date Posted: 01/28/2026
Shortcut: http://jobs.systemone.com/lFoTcm
Systems Analyst – Data Warehouse Design
Hybrid, Baltimore, MD
12 month+ contract opening
W2 hourly pay rate: $40/hr.
Federal client requirement: US Citizen or Legal Permanent Resident
Specific Experience:
- Must possess 7 years of systems analysis experience in a data warehouse environment using MS tools (MS Word, Excel, PowerPoint, and Project)
- At least 3 years of recent hands-on architecting data warehouse solutions.
- Prefer experience implementing solutions in AWS Glue, MicroStrategy (2019 or higher), Oracle (10g or higher), and Redshift environment with a strong background in SQL commands/ functions/ Procedures and database data modeling tools similar to Erwin, source to target mapping tools similar to Erwin Mapping Manager.
General Experience: 9-13 years related experience
Education: Bachelor of Science in related field or equivalent years of experience
General Job Description:
- Designs, develops, programs, installs, implements, conducts research for, and maintains internal data processing computer systems and utilities, and/or for customers on a contract basis.
- Analyzes internal or external customers' needs and determines equipment and software requirements for solutions to problems by means of automated systems; develops customized solutions to customer/user problems.
- Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications.
- Establishes system parameters and formats; ensures hardware/software compatibility; and coordinates and/or modifies user requirements in terms of existing and projected computer capacity and capabilities.
- May make programming changes as required to adapt or enhance existing or new programs and/or utilities.
- Maintains supplied software packages for internal users.
- Analyzes new hardware to determine its need or application in the existing or proposed system; advises on new techniques and estimated costs associated with new or revised programs and utilities, taking into consideration personnel, time, and hardware requirements, and makes trade-off analyses; develops general and detailed documentation describing system specifications and operating instructions; and revises existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage.
- Gathers information from existing systems, analyzes program and time requirements. Provides technical advice on complex programming. Writes and prepares detailed specifications for programs at all levels of complexity.
- Designs systems and programs to meet complex business needs including enhancements to existing programs. Ensures programs meet standards and technical specifications. Performs technical analysis and component delivery. Supports project personnel in resolving complex program problems.
- Conducts quality assurance activities such as peer/code reviews.
- Works with all technical areas to resolve issues and validate programming requirements. Enhances processes where applicable.
- Ability to derive the pseudo code on metric calculations that can be used by the SDLC teams for Design, Development, and testing. Perform Gap and Impact analysis on any type of source changes and/or requirement updates.
- Ability to write complex SQL queries to perform analysis on complex and large sets of data in various file formats.
- Provides technical advice on complex data warehouse scenarios. Experience in AWS Glue is required to understand the data flow from source to Data warehouse by reading the existing complex ETL mappings. Experience with MicroStrategy BI tool is advantage.
- Leads data analysis, database design, develop Logical and Physical Data Models, including Relational and Dimensional Models.
- Develop Design Logic for the data transformation from Source to Target; prepare Mapping documents with all the transformation logics, BI Objects, Data Quality Rule creation/ enforcement, etc.
- Write DDL script to create/update database structures supporting Oracle and Redshift either manually or through Erwin, ability to tune database performance.
- Analyzes multi-data mart system integration opportunities and challenges. Proposes and communicates recommended solutions. Recommend testing methodologies for the proposed design.
- Works individually and with peers to perform metadata management across Erwin, Oracle, Redshift, AWS Glue and MicroStrategy.
- Develops, documents, and maintains data architecture-related standards and documentation.
- Responsible for supporting planning activities and supporting the on-schedule delivery of milestones and deliverables.
- Must possess effective organizational, interpersonal, oral and written skills, strong analytical and problem-solving capabilities and close attention to detail. Must be a team player able to multi-task in a dynamic environment and have an extensive working knowledge of the SDLC and the associated processes and documentation.
System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M-MM1
#LI-MM1
#DI-MM1
Ref: #856-Baltimore-S1
-
Sr MicroStrategy / BI Platform Administrator
Reston, VA
Job Title: Sr MicroStrategy / BI Platform Administrator Location: Reston, VA (hybrid) Type: Contract Compensation: $83.00-$87.00/HR on W2 Position Purpose: The MicroStrategy Administrator is a specialized technical leader responsible for the operationa...
Date Posted: 02/06/2026 Recommended
-
Senior SDET / Full Stack Engineer (Java & Automation)
Reston, VA
Job Title: Senior SDET / Full Stack Engineer (Java & Automation) Location: Reston, VA – Mostly remote Type: Contract Contact: Crystal.dinnocenti@systemone.com PURPOSE: Performs complex analysis, design, development, testing, and debugging of computer s...
Date Posted: 02/06/2026 Recommended
-
Technical Program Manager (Top Secret)
Arlington, Virginia
Technical Program Manager Top Secret Clearance required to start Hybrid - 1 day a week onsite in Sterling and 1 day a week onsite in DC Direct Hire System One is seeking a Technical Program Manager to support our Department of State client within the B...
Date Posted: 01/27/2026 Recommended
-
Cyber Data Engineer
Huntsville, Alabama
Title: Cyber Data Engineer Clearance: Top Secret with the ability to sit for the CI Poly Location: On-site in Huntsville, AL Experience Level: 8+ Years of Data/Architect experience. Contact: Crystal.Dinnocenti@systemone.com System One IT is looking for...
Date Posted: 12/29/2025 Recommended
-
System Software Programmer - Project Lead
Oceana, West Virginia
Job Title: System Software Programmer - Project Lead Location: Remote Type: Direct Hire Compensation: $110,000-$135,000 Role Responsibilities: Work closely with the Systems Integration Applications team and Public Health Deputy Area programs Independen...
Date Posted: 02/06/2026 Recommended
-
Materials Engineer
Bellevue, WA
Materials Engineer Approved for Remote Company: System One Rate: $52 – $85/hour Type: Long-term Contract This role will work as part of a high functioning team of engineers focused on materials processing, supply chain development and supplier qualific...
Date Posted: 01/12/2026 Recommended
-
Systems Engineer II
Tulsa, Oklahoma
Job Title: Systems Engineer II Location: Tulsa, Oklahoma Type: Direct Hire Compensation: $80000 - $95000 annually Contractor Work Model: Onsite JOB DESCRIPTION PRIMARY FUNCTION The Systems Engineer II will perform under the direction of the Engineering...
Date Posted: 02/06/2026 Recommended
-
Sr. Informatica Consultant
Alexandria, VA
Job Title: Sr. Informatica (IICS) Consultant Location: Alexandria, VA, onsite Mon-Fri Contract: 1 Year Contract with Opportunity to extend Pay Rate: Open to W2 and C2C Candidates must be eligible to work in the US (Visa Holders Accepted) Requirements I...
Date Posted: 01/21/2026 Recommended
-
Sr Software Engineer - IBM ITX & Healthcare EDI
Reston, VA
Title: Senior Software Engineer (IBM ITX SME) Location: Mostly remote Onsite: Reston, VA (3-4 times per year) Duration: 12-month contract to hire Contact: Cdinnocenti@altaits.com PURPOSE The Senior Software Engineer performs complex analysis, design, a...
Date Posted: 01/29/2026 Recommended
-
Solutions Architect - VDI
Oklahoma City, Oklahoma
Job Title: Solutions Architect - VDI Location: Oklahoma City, Oklahoma Type: Direct Hire Compensation: $150000 - $165000 annually Contractor Work Model: Hybrid (possibly remote) JOB DESCRIPTION The Solutions Architect Platform shapes application techno...
Date Posted: 01/13/2026 Recommended
-
Data Engineer
Topeka, KS
Job Title: Data Engineer System One is looking for an experienced Data Engineer our client. This role is to support financial reporting system in support of Oracle cloud migration initiative. The ideal candidate may work remotely, but will be required ...
Date Posted: 02/04/2026 Recommended
-
Systems Engineer - Linux / Windows
Merrifield, Virginia
Senior System Engineer, Linux/Windows Direct Hire First 6 months on-site, Fairfax, VA – then hybrid 2 days a week on-site thereafter Salary: $120,000 to $125,000 annually, plus benefits Federal End-Client: US Citizenship required, eligible for Public T...
Date Posted: 01/30/2026 Recommended
-
Primary Heat Transport System Design Engineer
Bellevue, WA
Job Title: Primary Heat Transport System Design Engineer Location: Remote Type: Contract (yearlong) typically extends on a yearly basis Compensation: $56 - $95 hourly Contractor Work Model: Remote Paid holidays | PTO System One is seeking a Primary Hea...
Date Posted: 11/24/2025 Recommended
-
Oracle Systems Analyst, Senior
McLean, Virginia
Job Title: Oracle Systems Analyst, Senior Location: McLean (Tysons Corner), Virginia Type: Direct Hire Compensation: $150000.00 - $180000.00 annually Contractor Work Model: Onsite JOB DESCRIPTION SUMMARY The Senior Oracle Systems Analyst is responsible...
Date Posted: 01/13/2026 Recommended
-
Senior Test Engineer
Vienna , VA
Job Title: Sr Principal-Level QA/Test Automation Engineer Location: Vienna, VA or Pensacola, FL Hybrid Work Model: onsite 2-3 days a week Pay Rate: Open to Both C2C and W2 options Position Type: Multiyear Contract We are looking for candidates with a m...
Date Posted: 01/21/2026 Recommended
-
OSP Engineer
Salem, OR
Mountain Ltd. has an opening for a Remote OSP Engineer to work in the Salem, OR area. Since 1979, Mountain Ltd. has successfully created and supported turnkey engineering solutions for traditional and wireless telecom providers across the United States...
Date Posted: 01/27/2026 Recommended
-
OSP Engineer
beaverton, OR
Mountain Ltd. has an opening for an OSP Engineer to work in the Remotely supporting PST Time! Since 1979, Mountain Ltd. has successfully created and supported turnkey engineering solutions for traditional and wireless telecom providers across the Unite...
Date Posted: 02/02/2026 Recommended
-
AWS Cloud Data Engineer
Reston, VA
Job Title: AWS Cloud Data Engineer Location: Reston, VA Type: Contract To Hire Compensation: $87/HR Contractor Work Model: Hybrid 12-month contract The AWS Cloud Data Engineer will lead the design, development, and delivery of scalable cloud and/or on-...
Date Posted: 01/14/2026 Recommended
-
Informatica Administrator
Leesburg, VA
Job Title: Informatica Administrator Location: Hybrid, out of Baltimore, MD Position Type: Long Term Contract Pay Rate: Negotiable Requirements • Perform day-to-day operational support, administration, and troubleshooting for enterprise applications an...
Date Posted: 02/06/2026 Recommended
-
IT Senior Specialist-DX Automation
Erlanger, Kentucky
Job Title: Senior Specialist- Digital Transformation (DX) Automation Location: Erlanger, Kentucky Type: Direct Hire Compensation: $92500 - $115625 annually Contractor Work Model: Hybrid Hours: M-F 3 days onsite in Erlanger USC or GC, no H1B sponsorship...
Date Posted: 11/25/2025 Recommended
-
Database Administrator
Washington, District Of Columbia
Oracle/SQL Server DBA Remote US citizenship required per government contract $55-60/hr W2 Overview: We are currently hiring for an experienced Database Administrator for Oracle and MSSQL systems running on Windows and Linux platforms, supporting multip...
Date Posted: 02/05/2026 Recommended
-
SQA Tester
Vienna , VA
Job Title: Senior/Lead SQA Tester Location: FT Remote Position Type: Multiyear Contract W2 Hourly Pay Rate: $70/hr. System One IT is staffing a remote, multi-year contract opening for a Senior/Lead SQA Tester to support a leading financial services cus...
Date Posted: 01/21/2026 Recommended
-
Customer Onboarding Specialist
Naples, FL
Position Tittle: Onboarding Specialist Duration: Contract to Hire Work Location: Naples, FL Work Mode: Hybrid (3 days in office, 2 remotes) MONDAYS ARE ALWAYS IN OFFICE Years of Experience: 3+ years applicable experience required overall Industry backg...
Date Posted: 01/14/2026 Recommended
-
Elastic Engineer
Herndon, VA
Elastic Engineer Direct Hire On-Site, Dulles, VA (Herndon, VA) Salary: $140,000 annually, plus benefits Federal End Customer Minimum Active Secret clearance with TS eligibility System One IT is staffing a direct-hire opening for an Elastic Engineer to ...
Date Posted: 01/06/2026 Recommended
-
Lead Software QA / Test Analyst
Baltimore, MD
Job Title: Lead Software QA / Test Analyst Location: Baltimore, Maryland (Remote) Type: 6 month contract Compensation: $60.00-$65.00/HR on W2, $73.00-$78.00/HR on C2C Job Objective: Responsible for developing, modifying, and executing software test pla...
Date Posted: 02/06/2026 Recommended
-
Weld Engineer
Bellevue, WA
Job Title: Weld Engineer Location: Bellevue, WA (local candidates only) Type: Contract (yearlong) typically extends on a yearly basis Compensation: $52 - $85 hourly Contractor Work Model: Onsite Paid Holidays | PTO System One is seeking a highly motiva...
Date Posted: 01/16/2026 Recommended
-
Senior Control Systems Engineer
Everett, WA
Job Title: Senior Control Systems Engineer Location: Everett, WA (Local candidates only) Type: Contract (yearlong) typically extends on a yearly basis Compensation: $52 - $85 hourly Contractor Work Model: Onsite Paid Holidays | PTO System One is seekin...
Date Posted: 01/30/2026 Recommended
-
Principal Software Developer
Bellevue, Washington
System One is seeking a highly skilled Full Stack Developer to support the development and ongoing enhancement of a mission-critical data management application used to support complex, data-heavy nuclear power construction projects. This application i...
Date Posted: 01/05/2026 Recommended
-
Senior Database Engineer
Washington, DC
Job Title: Senior Database Engineer Location: SE Washington, DC 20590 (onsite) Type: Contract Compensation: $45.00-$52.89/HR on W2 Security Clearance: Candidate must be a U.S. citizen or green card holder who has resided in the U.S. for at least 3 year...
Date Posted: 01/27/2026 Recommended
-
Data Engineer/Developer
Fort Detrick, Maryland
If interested reach out directly to kspicer@altaits.com or call/text 301-252-8762 Responsibilities: Support full SDLC services for LogiCole defined priorities. Communicate well on all levels to various government and contractor support personnel includ...
Date Posted: 01/28/2026 Recommended