Verified today
Associate Technical Architect
About the role
Associate Technical Architect at o9 Solutions drives enterprise planning through AI-first data solutions. Leads advanced data ingestion, transformation, validation, and publishing. Builds scalable pipelines with SSIS, Python, PySpark, SQL. Integrates diverse data sources (Teradata, SAP ERP, SQL Server, Oracle, Sybase, ODBC, flat files) via API or batch. Oversees production deployment, triage, testing, root‑cause analysis to meet SLAs. Guides junior consultants, ensuring best coding practices. Embeds o9 ways of working and industry standards. Requires 3+ years data architecture/engineering, strong data modelling, ETL, cloud platforms, Python, PySpark, SQL, Airflow, SSIS, Parquet, JSON, REST APIs, HDFS, Delta Lake, Hive, Presto, GitHub, Azure DevOps, Agile, proactive mindset, excellent communication. Good to have Delta Lake, supply chain planning apps, AWS, Azure, GCP.
What you’ll do
- Oversee advanced data ingestion, transformation, validation, publishing
- Review and analyze customer data and technical intent
- Engage functional teams on end‑to‑end data flows
- Build data ingress/egress pipelines using SSIS, Python, PySpark, SQL
- Integrate Teradata, SAP ERP, SQL Server, Oracle, Sybase, ODBC, flat files via API/batch
- Assist production deployment, triage issues, test, root‑cause analysis, meet SLAs
- Guide and review junior code, ensure best practices
- Embed o9 ways of working, industry standards
What you’ll bring
- 3+ yrs data architecture/engineering, data modelling, ETL, cloud platforms
- Hands‑on Python, PySpark, SQL; workflow tools Airflow, SSIS
- Experience with Parquet, JSON, REST APIs, HDFS, Delta Lake, Hive, Presto
- Advanced SQL, relational DBs, GitHub, Azure DevOps, Agile methodology
- Proactive mindset, strong communication
Nice to have
Delta Lake, supply chain planning apps, AWS, Azure, GCP