Solution-Architect

ALLTECH CONSULTING SVC INC; Quebec; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading consulting firm seeks a proactive Senior Solution Architect to join their vulnerability management platforms team. The ideal candidate will have a solid background in data-intensive application development and be responsible for architecting high-throughput data ingestion pipelines, alongside mentoring the development team. This role requires extensive experience in RESTful API design, database interactions, and effective documentation skills.

Qualifications

• 8+ years in software development, specifically high-throughput RESTful API design.
• Proven experience in PostgreSQL and Snowflake, with optimization and schema design.
• Strong experience with FastAPI and SQL Alchemy.

Responsibilities

• Architect and document a high-throughput data ingestion pipeline.
• Develop and implement efficient ETL processes.
• Ensure application scalability and high availability in Kubernetes environments.

Skills

API Design

Python

Data Modeling

Database Design

Documentation

Job description

Job Description:

The vulnerability management platforms team is looking for an experienced and proactive senior solution-architect with solid background in data intensive app development. The candidate should be able to quickly adapt to a fast-evolving environment and take full ownership of the services / features they will be working on.

Core responsibilities:
– Architect and document a high-throughput data ingestion pipeline capable of processing billions of events daily
– Create detailed technical specifications and solution blueprints
– Develop and implement efficient ETL processes for ingestion, storage and retrieval
– Design and implement processes for detecting and offloading stale data from active systems to long-term storage databases.
– Ensure efficient integration of APIs with Redis and caching, optimizing data retrieval and reducing database load.
– Develop and deploy monitoring solutions for tracking API (FastAPI) usage patterns, response times and error rates.
– Collaborate with DevOps team to deploy and scale APIs within OpenShift/Kubernetes environments. Ensure application scalability, high availability, and resilience within a containerized ecosystem
– Conduct design and code reviews to ensure alignment with best practices.
– Define integration patterns and data flows between system components
– Establish technical standards, guidelines, and best practices
– Guide and mentor development team in implementing architectural decisions

Required skills:
– 8+ years of software development experience with focus on high-throughput RESTful API design with at least 2 years in architecture roles
– Proven experience in database interactions with PostgreSQL and Snowflake including query optimization and schema design
– Advanced Python programming with frameworks like Fast API and SQL Achemy
– Strong experience with caching strategies in API design
– Proven track record in designing large-scale, data intensive systems
– Strong experience in distributed systems architecture
– Deep understanding of data modeling and database design
– Experience with microservices architecture and event-driven systems
– Strong analytical skills for analyzing performance metrics and optimizing complex systems
– Excellent documentation and communication skills
– Proactive approach to identifying and solving technical challenges

Nice to have:
– Knowledge of monitoring tools like Prometheus and Open Telemtry