Remote Data & Analytics Solution Architect

NexTech Solutions

Memphis (TN)

Remote

USD 140,000 - 180,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

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.