Associate Architect

o9 Solutions, Inc.; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

o9 Solutions, Inc. seeks an Associate Architect to design, develop, and implement enterprise data integration solutions for planning and analytics. You will translate requirements into technical designs and scalable data pipelines, building batch ETL processes with SQL, Spark, Delta Lake, and related technologies.

Collaborate with solution architects and engineering teams to ensure data quality, schemas, and platform configurations meet business needs throughout the project lifecycle.

Qualifications

• Master’s degree plus 3 years in enterprise data integration or related fields.
• Experience designing, developing, and deploying data pipelines for planning or logistics.
• Strong knowledge of SQL and distributed data platforms.

Responsibilities

• Design, develop, and implement enterprise-scale data integration solutions for planning and analytics.
• Translate functional/data requirements into technical designs and scalable pipelines.
• Develop and maintain batch ETL processes using SQL-based transformations and Spark.
• Collaborate with architects and teams to define data schemas and quality rules.

Skills

Data modeling

Batch ETL design

Big data concepts

Education

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

Tools

SQL Server

Delta Lake

Apache Spark

PySpark

SparkSQL

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.

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 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 Computational Finance or

Operations Research and 3 years of experience in the job offered or 3 years of experience in a related occupation designing, developing, and implementing enterprise data integration solutions supporting supply chain planning or logistics systems; delivering solutions across the full implementation lifecycle, including data requirements analysis, technical design, data pipeline development, system and user acceptance testing, and production deployment; supporting large-scale enterprise implementations using agile delivery methodologies; working with data architectures and data models supporting supply chain planning domains such as demand planning, supply planning, 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, including ANSI 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-scale enterprise data environments; and using data integration patterns, data quality validation, reconciliation, and issue

resolution.

Sensitivity: Confidential

REFER TO: Job Number: JR102899.

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!