The Role
Design, develop, and maintain AxiomSL data sources, mappings, and regulatory reports. Build scalable data pipelines, perform advanced SQL transformations, ensure data lineage and reconciliation, support audits and production L2/L3 operations, and drive automation and platform upgrades to meet regulatory requirements.
Summary Generated by Built In
Role Overview
The Senior Data Engineer with deep expertise in AxiomSL is to support regulatory reporting initiatives within a complex banking and financial services environment. This role is responsible for designing, developing, and maintaining AxiomSL data sources, components, and regulatory reports while ensuring data integrity, traceability, and compliance with federal regulatory requirements. The ideal candidate combines strong AxiomSL platform experience with advanced SQL, data modeling proficiency, and the ability to troubleshoot large-scale data integration challenges across disparate source systems.
Key Responsibilities
AxiomSL Development & Platform Management
Preferred Qualifications
Locations: Pittsburgh, PA
About Techstra Solutions
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: www.techstrasolutions.com
The Senior Data Engineer with deep expertise in AxiomSL is to support regulatory reporting initiatives within a complex banking and financial services environment. This role is responsible for designing, developing, and maintaining AxiomSL data sources, components, and regulatory reports while ensuring data integrity, traceability, and compliance with federal regulatory requirements. The ideal candidate combines strong AxiomSL platform experience with advanced SQL, data modeling proficiency, and the ability to troubleshoot large-scale data integration challenges across disparate source systems.
Key Responsibilities
AxiomSL Development & Platform Management
- Design, develop, enhance, and upgrade AxiomSL data sources, portfolios, aggregates, and report templates.
- Configure and maintain AxiomSL components, data models, and calculation logic to meet regulatory requirements.
- Support AxiomSL 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 AxiomSL 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 AxiomSL 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 AxiomSL 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.
- Bachelor’s degree in Computer Science, Information Technology, or related field
- 5+ years of experience in data engineering within banking or financial services
- 3+ years of hands-on AxiomSL 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
Preferred Qualifications
- 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
About Techstra Solutions
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: www.techstrasolutions.com
Top Skills
AWS
Axiomsl
Azure
Data Warehousing Platforms
Etl Tools
GCP
Python
Shell Scripting
SQL
Workflow Orchestration Tools
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Techstra Solutions is a certified woman-owned consulting firm that provides strategy, technology and implementation support to large organizations undergoing digital and talent transformation. The rapid pace of technology innovation required to remain competitive, juxtaposed with the slow rate of change in many organizations, causes most to struggle. To be successful companies must drive new ways of working including the use of technology/analytics and new skillsets (hard/soft) deep into their culture so that they are able to rapidly and continuously react to change. They must also apply new approaches that empower their employees, ensuring its sustainability. At Techstra Solutions we focus on four key areas, otherwise known as the 4 A’s: Automation (Robotic Process Automation (RPA)/Intelligent Automation), Analytics (Reporting/Analytics/AI/ML), Application Modernization (Cloud, Mobility, etc), and Agile-based solutions (DevOps).
.png)
