Description :

Role Summary :

We are seeking a Solution Architect with expertise in Python and Java-based services, and advanced database/SQL and data pipeline performance optimization.

This role will architect, design, and scale data-intensive, cloud-native platforms supporting analytics, operational systems, and AI/ML workloads.

The ideal candidate combines deep system design skills, database knowledge, DevOps, and the ability to build end to end enterprise solutions in cloud environments.

Key Responsibilities :

Cloud Architecture & Platform Design :

- Own end-to-end cloud solution architecture for data-driven platforms

- Design scalable, fault-tolerant, cloud-native systems using Python and Java

- Define architectural standards for microservices, data access layers, and APIs

- Ensure solutions meet performance, security, cost, and compliance requirements

- Continuously monitor and incrementally evolve system performance, reliability

Python Solution :

- Architect and deploy Python services in tandem with ML Engineers:

1. Data ingestion, transformation, and orchestration

2. Analytics, reporting, and decisioning systems

3. ML/AI pipelines and feature processing

- Python frameworks and tools such as :

1. FastAPI / Flask

2. Pandas, PySpark, Dagster

Java-Based Data Services :

- Design and govern Java backend and data services, including :

1. REST / gRPC APIs

2. High-throughput data access services

3. Streaming and event-driven services

- Work with technologies such as :

1. Spring Boot / Spring Cloud

2. Connection pooling, caching, and resilience patterns

Database Architecture & SQL Optimization :

- Design and optimize database architectures for both OLTP and OLAP workloads

- Deeply analyze and tune SQL queries :

1. Query plans, indexes, partitions, joins, and materialized views

2. Locking, concurrency, and transaction isolation

- Optimize performance across :

1. Relational databases (Postgres, MySQL, SQL Server, Oracle)

2. Cloud-native databases (Aurora, Cloud SQL, Azure SQL)

3. Data warehouses (Snowflake, BigQuery, Synapse)

- Lead efforts in :

1. Schema design and normalization/denormalization tradeoffs

2. Indexing strategies and partitioning

3. Query refactoring and workload tuning

4. Database cost and performance optimization

Data & Streaming Platforms :

- Architect solutions using :

1. Data lakes and lakehouses (S3/ADLS/GCS, Delta, Iceberg, Hudi)

2. Streaming platforms (Kafka, Flink, Spark Structured Streaming)

- Enable data quality, lineage, and governance

- Design batch + real-time hybrid architectures

DevOps, Reliability & Security :

- Implement observability for services, databases, and queries

- Enforce security best practices :

1. IAM, encryption, secrets management

2. Network isolation and least privilege

- Drive cost optimization across compute, storage, and database layers

Technical Leadership :

- Act as architectural authority across teams

- Mentor engineers on database design, query tuning, and system performance

- Partner with product, analytics, and ML teams to deliver data-driven capabilities

- Communicate complex technical tradeoffs clearly to leadership

Required Qualifications :

Core Experience :

- 8+ years of software engineering experience with architecture ownership

- Strong hands-on experience with Python and Java in production systems

- Proven expertise in database design and SQL performance optimization

- Deep experience with at least one major public cloud (Azure, or GCP)

Cloud & Engineering :

- Microservices and distributed systems

- Containers and orchestration (Docker, Kubernetes)

- Event-driven architectures

- CI/CD and DevOps best practices

Preferred Qualifications :

- Experience with large-scale analytics or AI/ML platforms

- Knowledge of MLOps and feature stores

- Experience supporting multi-tenant, global systems

- Prior role as Solution Architect, Principal Engineer, or Staff Engineer