About this position
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.
- 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
Equal Employment Opportunity Statement
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 status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.
Powered by JazzHR