Tech Stack
AWSAzureCloudDockerGoogle Cloud PlatformKafkaKubernetesMicroservicesRabbitMQSQL
About the role
- The Opportunity: eCapital is seeking a Data Architect to lead the modernization of our data and calculation systems that underpin our factoring business. The first and most critical initiative will be to optimize and re-architect a legacy SQL Server–based system of stored procedures that currently drives account summaries, one of our most important calculations. This role requires a forward-looking architect who can both stabilize performance today and design a scalable foundation for tomorrow. The ideal candidate will have deep expertise in SQL performance tuning , high-volume transaction processing , and modern distributed data architectures . You will help us transition from monolithic, tightly coupled stored procedures into a microservices-based, sharded, and parallelizable calculation platform that can handle our expected transaction growth. Key Responsibilities: System Modernization & Optimization Analyze, refactor, and optimize legacy SQL Server stored procedures to achieve measurable improvements in performance, reliability, and maintainability. Identify bottlenecks in current calculation processes (particularly account summary generation) and design targeted improvements. Architecture & Design Define and implement a microservices architecture that distributes calculations across shards, enabling parallel processing at scale. Establish standards for data modeling, data distribution, and data access patterns to ensure consistent performance as volumes grow. Introduce caching, partitioning, and query optimization strategies to ensure low-latency response times. Scalability & Performance Develop strategies for handling high transaction throughput, ensuring solutions scale linearly with volume expansion. Work closely with DevOps and infrastructure teams to implement resilient, cloud-ready solutions. Collaboration & Leadership Partner with business stakeholders to ensure architectural choices align with factoring business needs. Provide technical leadership and mentorship to developers, data engineers, and analysts. Champion best practices in data architecture, including data governance, quality, and security.
Requirements
- Technical Expertise 7+ years of experience in database engineering, data architecture, or related fields. Proven track record in SQL Server performance tuning, query optimization, and stored procedure refactoring. Strong knowledge of data partitioning, sharding, and distributed processing architectures. Experience with microservices architecture and messaging/streaming technologies (e.g., Kafka, RabbitMQ, or equivalent). Familiarity with cloud data services (AWS, Azure, GCP) and container orchestration (Kubernetes, Docker). Business Domain Advantage Experience in financial services, factoring, or high-volume transactional systems preferred. Understanding of accounting, ledger systems, or cash flow–driven calculations a plus. Soft Skills Strong problem-solving and analytical skills, with the ability to translate business needs into scalable technical solutions. Excellent communication and stakeholder management abilities. Demonstrated ability to balance short-term fixes with long-term architectural vision.