Solutions Architect

Systems Planning and Analysis, Inc.; United States; Remote; USD 100,000 - 140,000; Full time

Job summary

An established industry player is seeking a Solutions Architect to support the Army Financial Management Command. This role involves designing and optimizing ETL/ELT workflows in a Databricks Lakehouse environment, focusing on SAP data extraction and performance optimization. The ideal candidate will have extensive experience in data processing, a strong understanding of SAP ECC, and excellent communication skills. Join a team that values innovation and collaboration, and contribute to critical projects that support the U.S. Army's financial management systems. If you are ready to take on a challenging yet rewarding role, this opportunity is for you.

Benefits

401k Contribution

Competitive Salary

Challenging Work Environment

Supportive Team Culture

Qualifications

• 10-15 years of relevant experience in data processing and analytics.
• Expertise in SAP ECC and Databricks for data pipeline development.

Responsibilities

• Design and optimize ETL/ELT workflows for large-scale DOD data processing.
• Collaborate with data teams and stakeholders to align with mission goals.

Skills

SAP ECC

Databricks

Pyspark

SQL

Data Pipeline Development

ETL/ELT Development

Communication Skills

Education

Bachelor's Degree in STEM or Data Science

Tools

Databricks Lakehouse

SAP Landscape Transformation Replication Server (SLT)

Java Database Connectivity (JDBC)

Job description

Solutions Architect

Job Locations

US-Remote

ID

2025-19834

Category

Software Engineering

Security Clearance Requirement

Top Secret

Type

Regular Full-Time

Level

Senior

Overview

Intrepid, an SPA Company, sets the standard for delivering excellence in the federal marketplace and is known for treating employees like family. We provide our employees with a challenging and supportive work environment, paired with a competitive salary and an industry-leading 401k contribution.

Our Financial Management & Business Analysis Portfolio supports the U.S. Army Space and Missile Defense Command (USASMDC); the Office of the Assistant Secretary of the Army (ASA) Financial Management and Comptroller (FM&C); the U.S. Army Financial Management Command (USAFMCOM); the Defense Health Agency (DHA); and many other DoD customers. We ensure the Army FM systems and processes are modernized and integrated to provide a complete range of financial and cost information needed for the Army to conduct business transactions, provide accountability to the public, and to support performance reporting and decision making. We provide effective functional systems support, user technical support, training support, and governance support of the Army's modernized and deployed FM domain ERP systems (GFEBS / GFEBS-SA / GCSS-A (Finance)), ensuring technological capabilities maturation and evolution aligns with Army and FM domain goals and objectives. And we are responsible for the implementation and sustainment of the Army's General Funds Enterprise Business System (GFEBS) within DHA's Military Health System (MHS).#MC

Responsibilities

We are looking for a Solutions Architect to join our team in supporting the Army Financial Management Command (USAFMCOM) Special Support Operations (SSO) DAR team.

The successful candidate will assist with SSO-DAR's effort of rebuilding GFEBS-BI BW data models in a Databrick Lakehouse environment (ARES) by extracting raw SAP ECC data (GFEBS-ECC).

Your day-to-day work will include:

ETL/ELT Development - designing and optimizing ETL/ELT workflows for large-scale DOD data processing.
• Databricks Lakehouse Architecture - designing and implementing optimized data pipelines to store SAP data in Delta Lake.
• Performance Optimization - tuning Databricks jobs, and SAP ECC extractions for efficiency and scalability.
• Stakeholder collaboration - collaborating with data teams, developers, data engineers, and business analysts to align with migration strategy and mission goals.
• Other duties as assigned.

Qualifications

Required Qualifications:

• A bachelor's degree in a relevant discipline, STEM or Data Science is preferred
• 10-15 years relevant experience
• Knowledge of SAP ECC tables for establishing data pipeline to Databricks Lakehouse using SLT- (SAP Landscape Transformation Replication Server) or JDBC (Java Database Connectivity) and rebuilding legacy data models in Databricks Lakehouse
• Working Knowledge of SAP ECC
• LLM Expertise - Databricks, Pyspark, SQL, iQuery
• Excellent communication skills including written, verbal, and interpersonal with various levels of stakeholders (interactions with senior stakeholders)
• Demonstrated ability to take initiative and be a team player
• The ability to work with a diverse set of stakeholders across business and systems groups during the execution of a complex data & analytics solution development effort
• An active SECRET Level Security Clearance and the ability to maintain it