Technical Architect

CSpring; Oregon; Hybrid; USD 160,000 - 230,000; Full time

Job summary

CSpring is a data-focused consulting firm seeking a senior data architect to lead enterprise data warehousing, reporting, and analytics modernization. You will drive end-to-end architecture across on-premises and cloud platforms, translate requirements into scalable designs, and mentor a cross-disciplinary team of data engineers and BI developers.

The role emphasizes hands-on leadership, governance, and collaboration with stakeholders to deliver measurable data-driven outcomes for public and

Qualifications

• Bachelor's degree in computer science, engineering, information systems, or related field.
• 10+ years of information technology experience, including senior-level architecture for large enterprise systems.
• Proven experience architecting enterprise data warehouse, reporting, analytics, and claims or transaction-processing solutions.
• Hands-on development with Python and advanced SQL, automation, and data processing.
• Experience designing APIs, services, databases, security, scheduling, monitoring, and environment management.
• BI/reporting experience with tools like Power BI, Tableau, SAS, or similar.
• Experience with Azure DevOps or similar CI/CD platforms.
• People leadership experience leading BI, data, and engineering staff.

Responsibilities

• Provide hands-on architecture and engineering leadership for data warehousing and analytics modernization.
• Own end-to-end architecture for reporting, data integration, and processing solutions across on-premises and cloud services.
• Translate requirements into maintainable system designs with traceability and auditability.
• Lead modernization of ETL/SQL/Linux scripts toward Python-based automation.
• Mentor architects, engineers, and BI developers; support production and delivery.

Skills

Python

SQL

Data architecture

Leadership

BI tools

Education

Bachelor's degree in CS/Engineering/IS

Tools

Azure DevOps

Power BI

Tableau

Informatica

Job description

DescriptionAt CSpring, we believe in the power of data to drive decisions and real-world impact. We're a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy. Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here.

Why You'll Love Working Here

• Purposeful Projects - Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight.
• People-First Culture - We're as committed to your growth as we are to delivering high-impact solutions. You'll find support, autonomy, and community here.
• Strategic, Hands-On Work - From data architecture and documentation to client workshops and solution delivery, you'll influence every step of the process.
• Collaborative Trust - Our clients rely on us to listen carefully, deliver consistently, and guide wisely. We partner with integrity, curiosity, and heart.

What You'll Do

You'll provide hands-on architecture and engineering leadership for enterprise data warehousing, reporting, and analytics modernization:

• 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, 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 Optum leadership, creating clarity across ambiguous scope, legacy constraints, and accelerated timelines.

Requirements

• Bachelor's degree in computer science, engineering, information systems, or related field, or equivalent professional experience.
• 10+ years of information technology experience, including senior-level application, solution, technical, or data architecture for large enterprise systems.
• Proven experience architecting enterprise data warehouse, reporting, analytics, and claims or transaction-processing solutions from the ground up - architecture, infrastructure, design, development, proof-of-concept, testing, implementation, and support.
• Hands-on development experience with Python and advanced SQL, including automation, data processing, troubleshooting, and code review.
• Experience designing application architecture including APIs, services, web components, databases, security, identity/access, job scheduling, monitoring, and environment management.
• Hands-on BI/reporting experience with BusinessObjects, Power BI, Tableau, SAS, or comparable enterprise reporting tools.
• Experience implementing source control, branching, pull requests, CI/CD, and automated deployment in Azure DevOps or a similar platform.
• People leadership experience leading BI, data, and engineering staff, with strong written, verbal, and presentation skills for customer and executive audiences.

Bonus Experience

• Healthcare payer, Medicaid, managed care, or health-insurance experience, including claims, adjustments, voids, eligibility, providers, payments, and regulatory reporting data.
• Federal reporting experience, especially CMS-64, quarterly expenditure reporting, reconciliation, certification, or related state Medicaid reporting.
• On-premises to cloud migration experience with Microsoft Azure, Azure Data Factory, Databricks, Data Lake Storage, Snowflake, or comparable cloud data services.
• ETL/ELT and data engineering experience with Informatica, Teradata, or comparable enterprise integration and large-scale MPP data warehouse platforms.
• Applying AI-assisted engineering or automation to code conversion, source-to-target mapping, testing, documentation, and data-quality activities within enterprise governance.
• Data modeling across conceptual, logical, and physical models, effective-dated reference data, dimensional models, and transaction lineage; experience with Linux/Unix scripting and job orchestration.
• Knowledge of HIPAA, PHI, PII, security architecture, and public-sector compliance expectations; advanced degree or relevant architecture, cloud, data, or agile certifications.

Come Build With Us

At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment- apply today!