Senior Data Engineer – AxiomSL Development

Role Overview

Senior Data Engineer with deep expertise in Axiom

SL is to support regulatory reporting initiatives within a complex banking and financial services environment. This role is responsible for designing, developing, and maintaining Axiom

SL data sources, components, and regulatory reports while ensuring data integrity, traceability, and compliance with federal regulatory requirements. The ideal candidate combines strong Axiom

SL platform experience with advanced SQL, data modeling proficiency, and the ability to troubleshoot large-scale data integration challenges across disparate source systems.

• Design, develop, enhance, and upgrade Axiom
  
  SL data sources, portfolios, aggregates, and report templates.
• Configure and maintain Axiom
  
  SL components, data models, and calculation logic to meet regulatory requirements.
• Support Axiom
  
  SL platform upgrades, patching, and environment migrations.
• Implement automation strategies for report generation, validation, and reconciliation processes.

• Develop and maintain regulatory reports including FRY-9C, FFIEC 101, 14M, and 14Q.
• Translate regulatory requirements into technical specifications and Axiom
  
  SL data mappings.
• Partner with Regulatory Reporting, Finance, and Risk teams to validate calculations and reporting outputs.
• Support internal and external audits with clear data lineage, controls documentation, and traceability.

• Design and maintain scalable data pipelines feeding Axiom
  
  SL from core banking, risk, and finance systems.
• Perform advanced SQL development for data transformation, aggregation, and validation.
• Troubleshoot and resolve data quality issues across upstream and downstream systems.
• Implement reconciliation controls to ensure accuracy, completeness, and timeliness of reported data.
• Develop robust data models aligned to regulatory reporting and risk aggregation standards.

• Enforce data governance standards including lineage documentation, metadata management, and control frameworks.
• Conduct root cause analysis for data anomalies and reporting discrepancies.
• Collaborate with enterprise data management teams to improve data quality and consistency.
• Establish monitoring and automation mechanisms to proactively identify reporting issues.

• Provide L2/L3 production support for Axiom
  
  SL regulatory reporting cycles.
• Participate in month-end, quarter-end, and regulatory submission processes.
• Identify opportunities for performance optimization and process automation.
• Contribute to documentation, knowledge transfer, and platform stability initiatives.

• 5+ years of experience in data engineering within banking or financial services.
• 3+ years of hands-on Axiom
  
  SL development experience.
• Strong experience developing regulatory reports (FRY-9C, FFIEC 101, 14M/Q).
• Advanced SQL expertise (complex joins, CTEs, performance tuning, data transformations).
• Strong understanding of data modeling principles (dimensional and relational models).
• Experience integrating multiple source systems into regulatory reporting platforms.
• Proven ability to troubleshoot complex data quality and reconciliation issues.
• Experience working in controlled, audit-sensitive regulatory environments.

• Experience supporting Federal Reserve or OCC regulatory submissions.
• Familiarity with BCBS 239 principles and regulatory data aggregation standards.
• Experience with automation tools or scripting (Python, shell scripting, workflow orchestration tools).
• Knowledge of enterprise ETL tools and data warehousing platforms.
• Experience with cloud-based data platforms (AWS, Azure, or GCP).
• Familiarity with Agile delivery methodologies.

Locations: Pittsburgh, PA

Techstra Solutions is a certified woman-owned (WBENC) management consulting firm specializing in strategy, technology, and implementation services for large organizations undergoing digital and talent transformation. Our experienced team partners with clients to co-create innovative solutions in applications, data, AI, and automation that accelerate measurable, sustainable change. From advisory consulting through technical execution, we are dedicated to driving world-class business solutions that fit your strategic requirements and deliver results.

For more information:

Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender,, sexual orientation, gender identification, pregnancy, marital…