IT Solution Architect

NexTech Solutions; Memphis (TN); Remote; USD 140,000 - 180,000; Full time

Job summary

NexTech Solutions is seeking an IT Solution Architect to own the architecture for enterprise data warehousing, batch processing, and consolidated reporting in a remote role. You will translate business requirements into technical roadmaps and guide data modernization efforts.

Responsibilities include designing and optimizing data warehouse solutions, coordinating with legacy systems, ensuring timely batch processing, and mentoring developers while aligning with enterprise standards.

Qualifications

• Degree in Computer Science or a related technical field, or equivalent technical experience.
• Typically 5–10 years of IT experience, with most experience in data platforms, architecture, or related 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.

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.

Skills

SQL skills

Data warehousing

ETL/ELT orchestration

Dimensional modeling

Azure DevOps

Data analysis

Communication

Problem solving

Architectural design

Education

Bachelor's in CS or related

Tools

Oracle SQL/PLSQL

Microsoft SQL Server

VBScript

Batch scripting

Windows scripting

Job description

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.