Data Engineer -- Regulatory Reporting & Portfolio Intelligence

You will build and optimize scalable data pipelines for regulatory data ingestion, transformation, and delivery. You will develop XML and REST API connectors, implement real-time data handlers, design cloud data models, write SQL transformations, establish data quality controls, support AWS migration, and translate compliance and risk requirements into reliable technical systems.

Responsibilities

• Build and optimize scalable data pipelines for regulatory data ingestion, transformation, and delivery
• Develop XML and REST API connectors for banking partners, regulatory feeds, internal systems, and risk and compliance platforms
• Implement real-time request handlers for transaction and portfolio data updates
• Design data models and transformations for regulatory filing and reporting requirements
• Encode sanctions lists, transaction thresholds, portfolio limits, and reporting deadlines into data logic and quality checks
• Design and maintain cloud data warehouse models for regulatory reporting, audit trails, and risk analytics
• Write SQL queries and transformations for compliance analysis, regulatory submissions, and audit trails
• Ingest and transform structured and semi-structured data from compliance and risk sources
• Establish data quality checks, monitoring, and alerting mechanisms
• Support migration from on-premises systems to AWS
• Document data pipelines, connectors, and technical architecture
• Collaborate with Compliance, MLRO, Risk, Product, and Data teams to operationalize compliance rules
• Evaluate data controls, monitoring, and quality checks through testing and validation

Requirements

• 3–5 years of professional experience in Data Engineering, ETL/ELT pipeline development, or systems integration
• Strong SQL expertise, including query optimization, complex transformations, and data modelling
• Proficiency in Python or a similar language for data pipelines, scripts, and data processing
• Experience designing and developing REST and SOAP API connectors
• Experience working with XML and JSON data formats
• Experience with AWS Redshift, Snowflake, Google BigQuery, or similar cloud data platforms
• Experience with cloud storage such as S3 or GCS
• Familiarity with Apache Airflow, Prefect, or equivalent orchestration tools
• Understanding of data modelling concepts and efficient schema design
• Experience with real-time or near-real-time data processing is a plus
• Knowledge of data quality frameworks and testing practices
• Strong problem-solving and debugging skills
• Ability to collaborate with technical and non-technical stakeholders
• Familiarity with regulatory reporting, transaction reporting, sanctions screening, KYC/AML, or portfolio monitoring
• Ability to interpret regulatory documentation and translate compliance and risk requirements into technical specifications

Benefits

• Performance bonuses
• Sales commissions
• Equity for specific roles
• Recognition programs
• Medical coverage
• 24/7 employee assistance program
• Generous vacation programs
• Year-end shutdown
• Hybrid working environment with three days per week in the office
• Role-specific training
• Internal workshops
• Learning stipend
• Company-wide social events
• Team bonding activities
• Happy hours
• Team offsites