Technical Architect

o9 Solutions; Bengaluru; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

o9 Solutions in Bengaluru seeks a Senior Technical Architect with 9+ years of experience in SQL, Python and PySpark to lead complex data integration and governance initiatives.

You will design scalable data pipelines, oversee ingestion, transformation, validation, and publishing, and provide technical leadership across multi-source systems like Teradata, SAP ERP, SQL Server, Oracle, and Hadoop-based stores.

Qualifications

• 5+ years in data architecture or data engineering with emphasis on data modelling, ETL, and cloud data platforms.
• Hands-on experience with Python, PySpark, SQL, and Airflow.
• Experience with Parquet, JSON, RESTful APIs, HDFS, Delta Lake; familiarity with Hive/Presto.
• Knowledge of AWS, Azure, GCP cloud services and relational databases.
• Strong communication and collaboration in Agile environments.

Responsibilities

• Oversee data ingestion, transformation, validation, and publishing across complex pipelines.
• Review data with technical and functional context and map end-to-end data flows.
• Build data ingress/egress pipelines handling large volumes using PySpark and Python.
• Provide technical leadership, code reviews, and alignment with project standards.
• Coordinate with data sources like Teradata, SAP ERP, SQL Server, Oracle and flat files.

Skills

SQL

Python

PySpark

Airflow

Delta Lake

Hive

REST APIs

Parquet

JSON

SQL Server

Tools

SSIS

GitHub

Azure DevOps

Job description

Transforming the Future of Enterprise Planning At o9, our mission is to be the Most Value-Creating Platform for enterprises by transforming decision-making through our AI-first approach. By integrating siloed planning capabilities and capturing millions—even billions—in value leakage, we help businesses plan smarter and faster. This not only enhances operational efficiency but also reduces waste, leading to better outcomes for both businesses and the planet. Global leaders like Google, PepsiCo, Walmart, T-Mobile, AB InBev, and Starbucks trust o9 to optimize their supply chains.

Job Title: Technical Architect

About the role

We are looking for a skilled 9+ years experienced Senior Technical Consultant with expertise in SQL, Python and PySpark to join our team. The ideal candidate will have proficiency in building scalable Interfaces, performance tuning, data cleansing and validation strategies by leveraging the defined tech stack for data processing and data movement.

What you’ll do

Advanced Execution & Data Management: Oversee and manage intricate project tasks, providing insights and directions related to advanced data ingestion, transformation, validation, and publishing Review and analyse the data provided by the customer along with its technical/functional intent and interdependencies. Engage proactively with functional teams, ensuring a thorough understanding of end-toend data flows as related to the technical integration. Build data Ingress or Egress pipelines, handling of huge volume of data and developing data transformation functions using languages such as SSIS, Python, Pyspark, SQL etc. Integration of various data sources definitions like Teradata, SAP ERP, SQL Server, Oracle, Sybase, ODBC connectors & Flat Files through API or Batch.

Production Deployment and Hypercare: Assist with Production Deployment tasks; Assists with triage of issues, testing and identifying root cause; Carry out timely response and resolution of batch automation disruptions, in order to meet customer SLA’s with accurate and on-time results.

Technical Leadership & Coding Oversight: Guide and review the code developed by junior consultants, ensuring alignment with best practices. Incorporate o9 ways of working and embed the industry standards for smoother project executions.

What you should have

5+ years experience in Data architecture, Data engineering, or a related field, with a strong focus on data modelling, ETL processes, and cloud-based data platforms. Hands-on experience with Python, PySpark, SQL languages along with workflow management tools like Airflow, SSIS. Experience working with Parquet, JSON, Restful APIs, HDFS, Delta Lake and query frameworks like Hive, Presto Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases Working experience with version control platforms, e.g. GitHub, Azure DevOps Familiarity with Agile methodology Proactive mindset and the right attitude to embrace the agility of learning. Excellent verbal and written communication skills Good to have Hands-on Experience with Delta Lake Experience with Supply chain planning applications Experience with Amazon Web Services (AWS), AZURE, Google Cloud Infrastructures

More about us…

At o9, transparency and open communication are at the core of our culture. Collaboration thrives across all levels—hierarchy, distance, or function never limit innovation or teamwork. Beyond work, we encourage volunteering opportunities, social impact initiatives, and diverse cultural celebrations. With a $3.7 billion valuation and a global presence across Dallas, Amsterdam, Barcelona, Madrid, London, Paris, Tokyo, Seoul, and Munich, o9 is among the fastest-growing technology companies in the world. Through our aim10x vision, we are committed to AI-powered management, driving 10x improvements in enterprise decision-making. Our Enterprise Knowledge Graph enables businesses to anticipate risks, adapt to market shifts, and gain real-time visibility. By automating millions of decisions and reducing manual interventions by up to 90%, we empower enterprises to drive profitable growth, reduce inefficiencies, and create lasting value.

o9 is an equal-opportunity employer that values diversity and inclusion. We welcome applicants from all backgrounds, ensuring a fair and unbiased hiring process.

Join us as we continue our growth journey!

We have a vision. Our Digital Brain, o9's AI-powered platform, is being used by global enterprises to drive their digital transformations. The integrated planning and operational efficiencies we provide is helping businesses do more, be more and mean more to the world at large. Because businesses that plan better, reduce waste, creating value for themselves and the planet.

But we also have a vision for our people. We want the most talented, committed and driven people to power our transformative approach. As an individual and in a team, your actions reflect our values. In return, we'll provide a nurturing environment where you can be a part of something special.