IT Solution Architect

Job Title: IT Solution Architect Data & Analytics

Location: Remote

Overview

We are seeking an IT Solution Architect to own and evolve the architecture supporting enterprise data warehousing, batch processing, and consolidated reporting. This role combines solution architecture with hands-on troubleshooting, legacy data analysis, and ongoing support of high-visibility data products. The architect will translate business requirements into technical roadmaps and implementation patterns while helping advance data modernization efforts.

Key Responsibilities

• Design, maintain, optimize, and support data warehouse solutions used for enterprise reporting.
• Trace, extract, and manipulate data across legacy manufacturing and business systems.
• Integrate data from ordering, invoicing, production, shipping, accounts receivable, accounts payable, and related sources.
• Transform data from disparate systems into consistent warehouse structures for downstream reporting and analytics.
• Support master data systems used for commercial reporting.
• Monitor batch jobs and data movement, troubleshoot failures, and intervene to maintain timely and accurate processing.
• Help ensure reliable data processing during critical reporting periods, including financial month-end close.
• Translate business requirements into solution architectures, technical roadmaps, and implementation patterns.
• Define technical direction and architectural standards for product, delivery, and managed service provider teams.
• Collaborate on user stories, solution designs, system integration plans, testing strategies, deployment plans, and release activities.
• Evaluate technology trends and product performance while managing architectural risk, quality, security, and compliance.
• Align solutions with enterprise and platform architecture standards.
• Coach developers and engineers while serving as a technical expert for supported data products.
• Create and communicate technical specifications, solution design documentation, and stakeholder presentations.

Required Qualifications

• Degree in Computer Science or a related technical field, or equivalent technical experience.
• Typically 510 years of IT experience, with most experience concentrated in data platforms, architecture, or a closely related technical area.
• Strong SQL skills and experience tracing, extracting, transforming, and troubleshooting data across complex or legacy systems.
• Experience with relational database platforms and SQL-based data extraction.
• Hands-on knowledge of dimensional modeling, data warehousing, data normalization and denormalization, and schema access.
• Experience with ETL/ELT orchestration, batch processing, data interfaces, and scheduled processing.
• Working knowledge of DDL, DML, DQL, and TCL commands.
• Experience developing or supporting stored procedures and other code-based data-processing components.
• Ability to independently investigate, diagnose, and resolve complex data problems using fact-based analysis.
• Experience supporting business-critical data products while contributing to modernization initiatives.
• Ability to translate business requirements into solution designs, architecture patterns, and technical roadmaps.
• Experience creating technical specifications, system integration plans, testing and quality plans, deployment plans, and change or release documentation.
• Knowledge of Agile and waterfall delivery methodologies and related platforms such as Azure DevOps.
• Strong communication and collaboration skills across business stakeholders, data stewards, architects, developers, engineers, product teams, and external delivery partners.
• Ability to work effectively in an evolving, unstructured environment and communicate complex technical concepts clearly.
• Ability to learn and support newer data platforms, including Microsoft Fabric.

Preferred Qualifications

• Experience working with Oracle databases and Oracle backend environments.
• Experience with Oracle SQL*Loader, PL/SQL, packages, stored procedures, and triggers.
• Experience with Microsoft SQL Server and T-SQL extraction sources.
• Experience with Windows scripting, including VBScript and batch scripts.
• Experience managing scheduled tasks, file server storage, and server or file-directory processes.