
Integration Architect
o9 Solutions23 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
About o9 Solutions
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.