Associate Architect

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] 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. My name is LaToshia Morris and I hold the position of Director, HR with o9 Solutions, Inc. In my capacity as Director, HR, I have the authority to post advertisements and notifications to the o9 Solutions, Inc. external website.