Senior System Architect AWS & Snowflake (Architecture + Production Support)

About Apexon:

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.Apexon brings together distinct core competencies in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients toughest technology problems, and a commitment to continuous improvement. Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.

We enable #HumanFirstDIGITAL

Role Overview:

We are looking for a seasoned Senior System Architect with a strong foundation in Snowflake and AWS architecture, who also brings hands-on expertise in production support and operational reliability. This role will be responsible for designing robust, scalable data warehouse solutions while ensuring high availability, performance, and supportability of production environments.

The ideal candidate combines strategic architectural vision with the technical depth needed to troubleshoot, optimize, and maintain complex data systems in real-time

Key Responsibilities:

• Lead end-to-end solution design for data warehouse platforms using Snowflake on AWS.
• Architect and oversee data ingestion, transformation, and provisioning pipelines that are performant, secure, and maintainable.
• Design and implement monitoring, alerting, and logging frameworks for production data environments.
• Provide hands-on production support, including issue triaging, root cause analysis, resolution, and post-mortem reporting.
• Establish and manage SLA-driven support models, escalation paths, and on-call processes.
• Optimize Snowflake performance, warehouse sizing, and cost management strategies for production use.
• Collaborate with DevOps, platform, and engineering teams to maintain high system uptime and reliability.
• Ensure security, governance, and compliance standards are enforced across the entire lifecycle.
• Document architecture, production support runbooks, and incident resolution procedures.

Required Qualifications:

• Minimum 15 years of experience in data architecture, enterprise systems design, and cloud data platforms.
• In-depth experience with Snowflake, including query optimization, virtual warehouse tuning, and monitoring in production environments.
• Strong hands-on expertise with AWS services, especially S3, Glue, Lambda, CloudWatch, and IAM.
• Experience setting up and managing production support processes, on-call rotations, and incident response in large-scale environments.
• Strong SQL skills, with ability to troubleshoot and optimize long-running or failed queries in production.
• Familiarity with tools like dbt, Airflow, Matillion, and monitoring tools such as Datadog, Splunk, or CloudWatch Logs.
• Demonstrated ability to work under pressure in fast-paced environments and maintain system reliability.

Preferred Qualifications:

• SnowPro Advanced Architect certification or equivalent.
• Experience with automated testing, CI/CD pipelines, and infrastructure as code (IaC).
• Exposure to real-time data streaming (e.g., Kinesis, Kafka) and event-driven designs.
• Background in production support for regulated industries (e.g., finance, healthcare, insurance) is a plus.

Our Commitment to Diversity & Inclusion:

Did you know that Apexon has been Certified by Great Place To Work , the global authority on workplace culture, in each of the three regions in which it operates: USA (for the fourth time in 2023), India (seven consecutive certifications as of 2023), and the UK.Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com)

Our Perks and Benefits:

Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.

We also offer:

• Health Insurance with Dental & Vision
• 401K Plan
• Life Insurance, STD & LTD
• Paid Vacations & Holidays
• Paid Parental Leave
• FSA Dependent & Limited Purpose care