Senior Application & Technical Architect -Data Warehouse- Remote

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
Springfield, IL, United States
23 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence Audit Trail Microsoft Azure Business Intelligence Development Cloud Computing Code Review Databases Continuous Integration Data Integration Extract Transform Load (ETL) Data Warehousing
+9 more
Linux Data Flow Control Python (Programming Language) Performance Tuning Reference Data Cloud Services Software Deployment SQL Databases Drilldown

Job description

  • Own end-to-end application and technical architecture for reporting, analytics, data integration, and transaction-based processing solutions across on-premises platforms and future cloud services.
  • Translate business, operational, and regulatory requirements into maintainable system designs, including configurable business rules, effective-dated reference data, traceability, auditability, and reconciliation.
  • Design and lead modernization of legacy ETL, SQL logic, Linux/Unix scripts, and manual processing into Python-based applications and automation, using enterprise data platforms efficiently for high-volume processing.
  • Provide hands-on technical leadership across architecture, development, code review, testing, deployment, performance tuning, and production support to unblock the team.
  • Build proof-of-concepts that compare solution options, document measurable results, and support architecture decisions with the customer and leadership.
  • Define technical architecture across web/UI, API and service layers, processing engines, databases, orchestration, scheduling, security, identity/access, monitoring, and backup/recovery, in partnership with infrastructure, security, cloud, and data peers.
  • Lead BI and analytics delivery including enterprise report design, drill-down and detail reporting, reconciliation, data quality, and modernization of legacy reporting capabilities.
  • Establish engineering practices using Azure DevOps or equivalent - epics and user stories, repositories, branching, pull requests, code review, CI/CD, release traceability, and production deployment - and apply AI and automation with appropriate governance to accelerate analysis, conversion, documentation, and testing.
  • Produce architecture diagrams, solution designs, technical specifications, dataflow and interface documentation, implementation of roadmaps, estimates, risks, and operational support models.
  • Lead and mentor architects, data engineers, ETL and BI developers, modelers, analysts, and testers; build backup coverage and develop team capability.
  • Present architecture, options, risks, and recommendations concisely to customer stakeholders and project leadership, creating clarity across ambiguous scope, legacy constraints, and accelerated timelines.

Requirements

  • Healthcare payer, Medicaid, managed care, or health-insurance experience, including claims, adjustments, voids, eligibility, providers, payments, and regulatory reporting data.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…