Associate Enterprise Data 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

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.