Associate Architect

o9 Solutions, Inc.; Dallas (TX); Remote; USD 120,000 - 160,000; Full time

Job summary

o9 Solutions, Inc. is seeking an Associate Architect in Dallas to design and implement enterprise-scale data integration solutions for supply chain planning and analytics. You will develop scalable data pipelines, model data, and support forecasting and optimization use cases.

Responsibilities include building batch ETL processes, writing SQL and Spark-based transformations, and ensuring data quality across source systems. Collaboration with platform and product teams is essential.

Qualifications

• Master's degree required with 3 years in data integration for enterprise planning or logistics contexts.
• Experience designing, building, and optimizing large-scale data pipelines and models.
• Proficiency in SQL, Spark SQL, PySpark, and data validation with ETL processes.

Responsibilities

• Design, develop, and implement enterprise data integration Solutions for supply chain planning and analytics.
• Build and optimize data pipelines to support forecasting, optimization, and reporting use cases.
• Develop and maintain batch ETL processes loading data from multiple sources (RDBMS, flat files, spreadsheets).
• Write and optimize SQL-based transformations (T-SQL, ANSI SQL) and data processing logic.
• Collaborate with solution architects to define data schemas and quality rules.
• Support testing, production deployments, and issue resolution in collaboration with engineering teams.

Skills

SQL

ETL Pipelines

Data Integration

Python

Spark

Data Modeling

Data Warehousing

Education

Master's degree in Quantitative and Computational Finance or Operations Research

Tools

SQL Server

Delta Lake

Apache Spark

MySQL

Job description

Associate ArchitectWe use cookies to make the safest and most effective website possible.### Associate ArchitectApply: Dallas, Texas, United States: Full time: Posted Today: End Date: November 5, 2026 (13 days left to apply): JR102899**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.POSITION: Associate ArchitectLOCATION: 1501 Lyndon B Johnson Fwy, Ste 140, Dallas, TX 75234 [and various unanticipated locations throughout the U.S.; may telecommute/work from home]**POSITION:** Associate Architect **JOB LOCATION:** 1501 Lyndon B Johnson Fwy, Ste 140, Dallas, TX 75234 [and various unanticipatedlocations throughout the U.S.; may telecommute] Associate Architect needed by o9 Solutions, Inc. in Dallas, TX [and various unanticipated locations throughoutthe U.S.; may telecommute] to Design, develop, and implement enterprise-scale data integration solutions tosupport supply chain planning and analytics platforms. Translate defined functional and data requirements intotechnical designs and implement scalable data pipelines and data models. Develop and maintain batch-orientedETL processes to extract, transform, and load large volumes of structured and semi-structured data from multiplesource systems, including relational databases, flat files, and spreadsheets, into analytical and planning platforms.Build and optimize complex datasets to support forecasting, optimization, and reporting use cases. Write,optimize, and maintain SQL-based transformations and data processing logic using technologies such as SQLServer, MySQL, Delta Lake, and Apache Spark. Use ANSI SQL, T-SQL, PySpark, and SparkSQL to performdata validation, transformation, aggregation, and integration. Collaborate with solution architects and technicalteams to define data schemas, data quality rules, and platform configuration specifications. Implement technicalconfigurations in the planning platform based on approved technical designs. Design and execute data validation,integration, and system test cases. identify data issues. and support defect resolution through deployment. Developstandardized testing procedures and support automation of data validation where applicable. Support productiondeployments and resolve data integration issues in collaboration with internal engineering and product teams.Document technical designs, data mappings, and integration logic to support maintainability and operationalsupport. Utilize agile development methodologies to deliver large-scale enterprise data engineering / integrationsolutions. Design, develop, and implement enterprise data integration solutions supporting supply chain planningor logistics systems. Deliver solutions across the full implementation lifecycle, including data requirementsanalysis, technical design, data pipeline development, system and user acceptance testing, and productiondeployment. Support large-scale enterprise implementations using agile delivery methodologies. Work with dataarchitecture and data models supporting supply chain planning domains such as demand planning, supplyplanning, S&OP/IBP, or scheduling. Utilize relational and distributed data platforms, including SQL Server, DeltaLake, and Apache Spark. Utilize knowledge of SQL and distributed data processing languages, including ANSISQL, T-SQL, PySpark, and SparkSQL, for data extraction, transformation, validation, and integration. Designand maintain batch-oriented ETL pipelines and data orchestration workflows for large-scale enterprise dataenvironments. Use data integration patterns, data quality validation, reconciliation, and issue resolution. **MINIMUM REQUIREMENTS:** Requires a Master’s degree in Quantitative and Computational Finance orOperations Research and 3 years of experience in the job offered or 3 years of experience in a related occupationdesigning, developing, and implementing enterprise data integration solutions supporting supply chain planningor logistics systems; delivering solutions across the full implementation lifecycle, including data requirementsanalysis, technical design, data pipeline development, system and user acceptance testing, and productiondeployment; supporting large-scale enterprise implementations using agile delivery methodologies; working withdata architectures and data models supporting supply chain planning domains such as demand planning, supplyplanning, S&OP/IBP, or scheduling; utilizing relational and distributed data platforms, including SQL Server,Delta Lake, and Apache Spark; utilizing knowledge of SQL and distributed data processing languages, includingANSI SQL, T-SQL, PySpark, and SparkSQL, for data extraction, transformation, validation, and integration;designing and maintaining batch-oriented ETL pipelines and data orchestration workflows for large-scaleenterprise data environments; and using data integration patterns, data quality validation, reconciliation, and issueresolution. Sensitivity: ConfidentialREFER TO: Job Number: JR102899. My name is LaToshia Morris and I hold the position of Director, HR with o9 Solutions, Inc. In my capacity asDirector, HR, I have the authority to post advertisements and notifications to the o9 Solutions, Inc. externalwebsite.**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!*