Technical Architect

About the role

o9 is an AI-first enterprise planning platform transforming decision-making and capturing value leakage across supply chains. As a Technical Architect in Bangalore, you will oversee advanced data ingestion, transformation, validation, and publishing, build scalable ETL/ingress-egress pipelines, integrate diverse data sources, and provide technical leadership by reviewing code and guiding junior consultants. The role is full-time and based in Bangalore, Karnataka, India.

What you’ll do

• Oversee and manage intricate project tasks, providing insights and directions related to advanced data ingestion, transformation, validation, and publishing
• Review and analyse customer-provided data along with its technical/functional intent and interdependencies
• Engage proactively with functional teams to ensure thorough understanding of end-to-end data flows related to technical integration
• Build data ingress or egress pipelines, handle huge volumes of data, and develop data transformation functions using SSIS, Python, PySpark, SQL, etc.
• Integrate various data source definitions such as Teradata, SAP ERP, SQL Server, Oracle, Sybase, ODBC connectors, and Flat Files through API or Batch
• Assist with production deployment tasks, triage issues, test, identify root cause, and resolve batch automation disruptions to meet customer SLAs
• Guide and review code developed by junior consultants, ensuring alignment with best practices
• Incorporate o9 ways of working and embed industry standards for smoother project executions

What you’ll bring

• 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, and SQL
• Proficiency with workflow management tools like Airflow and SSIS
• Experience working with Parquet, JSON, RESTful APIs, HDFS, Delta Lake, and query frameworks like Hive and Presto
• Advanced SQL knowledge and experience with relational databases and query authoring
• Working experience with version control platforms such as GitHub or Azure DevOps
• Familiarity with Agile methodology
• Excellent verbal and written communication skills

Nice to have

• Hands-on experience with Delta Lake
• Experience with Supply chain planning applications
• Experience with Amazon Web Services (AWS), Azure, or Google Cloud Infrastructures

Skills