> Markdown version of [/jobs/ext/600151-application-architect](https://www.wearedevelopers.com/jobs/ext/600151-application-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Application Architect - **Company:** Gainwell Technologies - **Location:** Houston, TX, United States (Remote available) - **Experience:** Experienced - **Salary:** $95,100.0 - $135,800.0 - **Contract:** Permanent contract - **Skills:** Agile Methodology, Amazon Web Services, Microsoft Azure, System Configuration, Data Dictionary, Data Governance, Data Transformation, Data Structures, Document-Oriented Databases, Systems Development Life Cycle, Standard Sql, Software Engineering, SQL Databases, Systems Architecture, Systems Integration, Google Cloud, Sql Optimization, Integration Frameworks - **Published:** June 23, 2026 - **Apply:** https://www.dice.com/job-detail/8f5413f5-6261-4fa4-9ec6-7dbe3a135ef1 ## About the Role * 3-5 years of experience in a technical analyst, data analyst, or healthcare systems analyst role. + Advanced SQL skills, including experience with joins, data transformations, and large dataset manipulation, including pharmacy claims datasets. + Strong understanding of healthcare systems and Medicaid concepts, including Medicaid pharmacy claims processing, NDC ? based pricing, DUR edits, prior authorization workflows, and pharmacy benefit rules. + Familiarity with Data Element Dictionaries (DEDs), interface specifications, and integration design, including pharmacy ? related interfaces such as NCPDP. + Excellent communication and documentation skills. + Experience working in SDLC and Agile environments preferred. + Understanding of system implementation in cloud platforms (AWS/Azure/Google Cloud) is a plus. ## Description The Technical Analyst plays a critical role in bridging business needs with technical execution across one or more functional domains (e.g., Member, Provider, Claims/UM, Pharmacy, Finance, Plan, or VUE360). Working in close collaboration with Business Analysts and Configuration Analysts, the Technical Analyst ensures that solutions are technically sound, data ? driven, and aligned with project and system architecture. This role provides essential support for system design and technical specification creation, data setup, testing, and decision ? making throughout the Software Development Life Cycle (SDLC). The analyst leverages deep SQL expertise, an understanding of healthcare concepts, familiarity with Data Element Dictionaries (DEDs), and knowledge of Medicaid pharmacy claims processing, NDC ? based pricing, DUR edits, prior authorization workflows, and pharmacy benefit rules. Your role in our mission * Understand business requirements at a detailed level and translate them into technical specifications and data models, including pharmacy claims adjudication logic, pricing methodologies, DUR edits, and PA workflows. + Support business analysts with insight into how system data and integrations meet operational and policy needs, including pharmacy benefit rules and pharmacy claims data structures. + Apply healthcare and pharmacy domain knowledge to validate logic, dependencies, and downstream impacts of technical decisions. + Use advanced SQL skills to extract, analyze, and validate data to support solutioning, testing, and quality assurance, including pharmacy claims data elements such as NDCs, quantities, units, pricing fields, and DUR indicators. + Interpret and utilize Data Element Dictionaries (DEDs) to understand data structures and relationships across modules, including pharmacy ? specific data dictionaries. + Analyze and document data flows, integration logic, and technical dependencies across internal systems and external interfaces, including NCPDP pharmacy interfaces and pharmacy PA systems. + Serve as a liaison between business users, developers, QA, and configuration teams to ensure shared understanding of requirements, including pharmacy ? specific rules and adjudication logic. + Document and communicate technical decisions, risks, and impacts clearly and concisely to stakeholders, including pharmacy program impacts. + Develop detailed technical solution models and recommend scalable approaches that align with enterprise architecture and platform capabilities, including pharmacy claims and pharmacy benefit configurations. + Mentor junior technical analysts on data standards, SQL best practices, and documentation expectations, including pharmacy claims data structures and pricing logic. + Provide analytical support during defect resolution, system configuration validation, and pre ? deployment quality checks, including pharmacy claims adjudication and DUR logic validation. ## Related Videos - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [The Cloud is Calling: Answer with In-Demand Skills](https://www.wearedevelopers.com/videos/945-the-cloud-is-calling-answer-with-in-demand-skills) - [Crypto-secure Data Management with In-Database Blockchain](https://www.wearedevelopers.com/videos/632-crypto-secure-data-management-with-in-database-blockchain) - [Analytics in the Age of Agentic AI: A tour of ClickHouse and Langfuse](https://www.wearedevelopers.com/videos/100240-analytics-in-the-age-of-agentic-ai-a-tour-of-clickhouse-and-langfuse) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)