SMX is seeking a highly skilled Data Integration Specialist to join our team of technical and domain experts. This role is pivotal to the successful implementation of a new enterprise-wide budget solution for a key client. As a Data Integration Specialist, you will be responsible for designing, developing, and maintaining the data pipelines that connect the client's source financial systems (such as ERPs, General Ledgers, and HR systems) to the new budgeting and forecasting platform. This is a full-time position that is 100% remote and will require minimal travel <20% and requires a Public Trust clearance.
Essential Duties :
You will be the bridge between raw financial data and actionable insights, ensuring data flows accurately, securely, and efficiently. This position requires a blend of deep technical expertise in ETL/ELT processes and a strong understanding of financial data structures. Your work will directly contribute to our mission of breaking down data stovepipes and delivering targeted capabilities that solve real problems for our clients, assuring a successful outcome.
Key Responsibilities
• Data Pipeline Development: Design, build, and maintain robust, scalable, and automated ETL/ELT pipelines to extract financial data from various source systems and load it into the target budget solution.
• Source System Analysis: Collaborate with client stakeholders and functional consultants to analyze source data from systems like, SAP S/4HANA, and other government financial systems to understand data structures, relationships, and business rules.
• Data Mapping & Transformation: Create and manage complex data mapping documents. Write and execute HANA CDS views and SQL queries and scripts to transform, cleanse, and validate data according to the requirements of the new budget solution.
• Data Quality Assurance: Implement rigorous data quality checks, validation routines, and reconciliation processes to ensure the integrity, accuracy, and completeness of financial data.
• Troubleshooting & Performance Tuning: Proactively monitor data integration jobs, troubleshoot failures, and optimize performance of data pipelines to meet processing windows and performance SLAs.
• Collaboration: Work closely with project managers, solution architects, functional consultants, and client SMEs to ensure the integration design aligns with overall project goals and business requirements.
• Documentation: Develop and maintain comprehensive technical documentation, including data flow diagrams, integration specifications, and standard operating procedures (SOPs).
Required Skills & Experience:
• Bachelor’s degree in Computer Science, Information Systems, Finance, or equivalent experience.
• Proven experience with SAP Analytics Cloud (SAC), SAP HANA, SAP S/4 HANA, SAP BW/4HANA and SAP BW.
o Data analytics, business intelligence, and reporting.
o Client-side JavaScript to enhance SAC functionality.
o Familiarity with SAC, BPC or BW-IP.
• 5+ years of hands-on experience in a data integration, CDS View development, ETL development, or data engineering role.
• Proven proficiency in writing complex, optimized CDS, SQL and working with relational databases (e.g., SAP HANA, SQL Server, Oracle).
• Demonstrable experience with loading data into models using SAC and S/4HANA Source System. Experience with (e.g., SAP Data Services, SAP BTP).
• Skilled in Data analytics, business intelligence, and reporting capabilities.
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Strong communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Must have the ability to obtain a Public Trust clearance which requires US Citizenship.
Desired Skills & Experience
• Experience working on a financial system or ERP implementation, particularly with federal government clients.
• Experience with SAP HANA, SAP BW, and SAP Business Objects Data Services (BODS).
• Solid understanding of core financial and accounting concepts (e.g., General Ledger, Chart of Accounts, Debits/Credits, Trial Balances) and experience with ABAP scripting language.
• Experience working with SAP Ariba
• Direct experience with federal budgeting solutions and platforms (e.g., OneStream, Anaplan, Oracle EPM/Hyperion/FM, IBM TM1).
• Knowledge of API-based data integration and web services (REST, SOAP).
• Relevant technical certifications (e.g., SAP SAC, SAP HANA, SAP BW4/HANA).
• Prior experience in a client-facing or consulting role.
# LI-SA1
#CJPOST
The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.
At SMX®, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.
We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.
SMX is an Equal Opportunity employer including disabilities and veterans.
Selected applicant may be subject to a background investigation and/or education verification.
SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Finance, or equivalent experience
- Proven experience with SAP Analytics Cloud, SAP HANA, SAP S/4HANA, SAP BW/4HANA, and SAP BW
- 5+ years of experience in data integration, CDS view development, ETL development, or data engineering
- Proficiency writing complex, optimized CDS and SQL queries and working with relational databases such as SAP HANA, SQL Server, or Oracle
- Experience loading data into models using SAP Analytics Cloud and SAP S/4HANA source systems
- Experience with SAP Data Services or SAP BTP
- Skills in data analytics, business intelligence, and reporting
- Strong analytical, problem-solving, communication, and attention-to-detail skills
- Ability to obtain a Public Trust clearance and US citizenship
- Experience with financial system or ERP implementations, particularly for federal government clients
- Experience with SAP HANA, SAP BW, and SAP Business Objects Data Services
- Understanding of financial and accounting concepts, including General Ledger, Chart of Accounts, debits and credits, and trial balances
- Experience with ABAP scripting
- Experience working with SAP Ariba
- Experience with federal budgeting solutions such as OneStream, Anaplan, Oracle EPM/Hyperion/FM, or IBM TM1
- Knowledge of API-based data integration and REST or SOAP web services
- Relevant SAP technical certifications, such as SAP SAC, SAP HANA, or SAP BW/4HANA
- Prior client-facing or consulting experience
SMX Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about SMX and has not been reviewed or approved by SMX.
-
Fair & Transparent Compensation — Salary ranges are publicly listed on many postings and a pay transparency statement clarifies how location, contract, and credentials influence offers. This visibility helps set clear expectations around compensation.
-
Leave & Time Off Breadth — About four weeks of PTO plus 11 paid federal holidays are highlighted in careers materials. Paid military leave on some roles further expands time‑off coverage.
-
Retirement Support — A 401(k) with a dollar‑for‑dollar match on the first 5% and immediate vesting is called out in role descriptions. Traditional and Roth options support long‑term savings.
SMX Insights
What We Do
SMX is a global technology and advanced engineering provider specializing in Cloud Solutions, C5ISR, and Advanced Engineering / IT. Our tradition of delivering innovative, technical solutions dates back to 1995, however, you may know us better by one of our legacy company names: Trident Technologies, Smartronix, Datastrong, or C2S Consulting Group. With the support of OceanSound Partners, our private equity investment sponsor, we began operating as one business starting in 2019 and became SMX in 2021. We operate in close proximity to our clients around the globe and have core locations in Alabama, California, the DC Metro, Florida, Hawaii, Maryland, and Massachusetts. Today, as SMX, we are one team and together empower government and commercial enterprises to become more effective, innovative, and resilient, no matter what challenges they face. SMX offers competitive benefits, excellent work environments, and growth opportunities for our employees while continuing to expand operations and support our communities. We have more than 25 years of rapid and consistent growth with continuous recognition as an employer-of-choice technology company. In addition, we have earned coveted industry quality and business certifications; have a strong commitment to business partnerships, ethics, compliance, and sustainability; and have a multitude of premier contracting vehicles. The combination of these attributes allows us to provide sound, repeatable business solutions yet remain flexible and agile to quickly adapt to specific customer requirements. Committed to ensuring the highest levels of customer satisfaction, SMX is structured around the programs and technologies we support to provide optimal and seamless operations. We have maintained a reputation for excellence, helping to assure the missions of our Department of Defense, Public Sector, Fortune 1000, and other Government and commercial customers.
.jpg)
