o9 Solutions

Integration Architect

o9 Solutions
Apply
23 hours ago
São Paulo, BrazilSenior

Responsibilities

  • Design, build, and deploy SSIS packages to validate, synthesize, and transform customer data.
  • Understand the o9 platform data model and design data structures for planning use cases.
  • Review customer data, technical and functional requirements, and data interdependencies.
  • Lead customer sessions for technical design, data requirements gathering, and best-practice recommendations.
  • Design and automate data-loading and insights-generation processes with validation checks and controls.
  • Design and support test plans, document issues, and track resolution progress.
  • Perform source-system analysis, data-quality validation, source-target mapping, performance tuning, and high-volume data loading.

Requirements

  • At least 8 years of experience, including experience with planning applications.
  • Experience building scalable ML frameworks through input-data collection, feature engineering, tuning, and testing.
  • At least 1 year of experience designing ETL solutions for clients; SSIS experience is preferred and required ETL development experience is a must.
  • Experience creating and testing web APIs using Postman, C#, or JavaScript.
  • Knowledge of Hive, Hadoop, Python, Apache NiFi, or Apache Airflow is desirable.
  • Prior supply-chain work experience and strong experience with cloud data quality and source-system analysis.
  • Strong SQL, MDX, and T-SQL skills, including DDL, DML, stored procedures, triggers, and performance tuning.
  • Experience with SSIS, Python, Bash, or PowerShell scripting and preferred experience with AWS, Azure, or Google Cloud.
  • Knowledge of C#, JavaScript, VB.NET, R, JSON serialization, and posting data to APIs is desirable.
  • Bachelor’s or master’s-level technical education such as BE, BTech, MTech, or MCA, along with strong technical and communication skills.
  • Proficiency with Microsoft Excel, PowerPoint, and Visio for analysis and presentation.

Benefits

  • Competitive salary and employer-provided technology tools, with a choice of a Windows or PC laptop.
  • Flexible hybrid work arrangement with work from home two days per week.
  • Supportive, diverse, international team environment with learning and collaboration opportunities.
  • Healthy snacks, fresh fruit, teas, and coffees.
  • Volunteering opportunities, social-impact initiatives, and diverse cultural celebrations.

Tech Stack

Apache AirflowApache HadoopApache HiveAWSAzureBashC#Google CloudJavaScriptPostmanPowerShellPythonRSQLVB.NET

Categories

Solutions Engineering
o9 Solutions

About o9 Solutions

1,001-5,000 employees

o9 Solutions builds an AI-first enterprise planning platform used for demand/supply planning, integrated business planning, and revenue/assortment decisions. It sells its software as a cloud SaaS suite with implementation and consulting services to large manufacturers and retailers; customers include Google, PepsiCo, Walmart, T-Mobile, AB InBev, and Starbucks. Founded in 2009 and headquartered in Dallas, it is privately held.

Contact me