Associate Architect
o9 SolutionsTransforming 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 Architect LOCATION: 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 unanticipated locations throughout the U.S.; may telecommute] Associate Architect needed by o9 Solutions, Inc. in Dallas, TX [and various unanticipated locations throughout the U.S.; may telecommute] to Design, develop, and implement enterprise-scale data integration solutions to support supply chain planning and analytics platforms. Translate defined functional and data requirements into technical designs and implement scalable data pipelines and data models. Develop and maintain batch-oriented ETL processes to extract, transform, and load large volumes of structured and semi-structured data from multiple source 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 SQL Server, MySQL, Delta Lake, and Apache Spark. Use ANSI SQL, T-SQL, PySpark, and SparkSQL to perform data validation, transformation, aggregation, and integration. Collaborate with solution architects and technical teams to define data schemas, data quality rules, and platform configuration specifications. Implement technical configurations 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. Develop standardized testing procedures and support automation of data validation where applicable. Support production deployments 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 operational support. Utilize agile development methodologies to deliver large-scale enterprise data engineering / integration solutions. Design, develop, and implement enterprise data integration solutions supporting supply chain planning or logistics systems. Deliver solutions across the full implementation lifecycle, including data requirements analysis, technical design, data pipeline development, system and user acceptance testing, and production deployment. Support large-scale enterprise implementations using agile delivery methodologies. Work with data architecture and data models supporting supply chain planning domains such as demand planning, supply planning, S&OP/IBP, or scheduling. Utilize relational and distributed data platforms, including SQL Server, Delta Lake, and Apache Spark. Utilize knowledge of SQL and distributed data processing languages, including ANSI SQL, T-SQL, PySpark, and SparkSQL, for data extraction, transformation, validation, and integration. Design and maintain batch-oriented ETL pipelines and data orchestration workflows for large-scale enterprise data environments. Use data integration patterns, data quality validation, reconciliation, and issue resolution. MINIMUM REQUIREMENTS: Requires a Master’s degree in Quantitative and Computat…