> Markdown version of [/jobs/ext/4804341-senior-data-architect](https://www.wearedevelopers.com/jobs/ext/4804341-senior-data-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). --- # SENIOR DATA ARCHITECT - **Company:** PSN Services, LLC - **Location:** Plano, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Artificial Intelligence, Business Logic, Microsoft Azure, Information Systems, Continuous Integration, Data Architecture, Information Engineering, Data Infrastructure, Data Warehousing, Apache Hive, Identity and Access Management, Job Scheduling, Python (Programming Language), Microsoft SQL Server, SQL Azure, Networking Basics, Operational Data Store, Performance Tuning, Power BI, Migration Manager, SQL Databases, Data Streaming, Enterprise Data Management, Azure Service Bus, File Transfer Protocol (FTP), Azure Data Factory, Fast Healthcare Interoperability Resources, Apache Spark, Git, Microsoft Fabric, Data Lakes, Pyspark, Storage Technologies, Information Technology, Data Lineage, Deployment Automation, Health Level Seven International, Bicep, Restful APIs, Terraform, Azure Synapse Analytics, Software Version Control, Data Pipelines, Key Vault, Databricks - **Published:** November 20, 2026 - **Apply:** https://www.thejobnetwork.com/job/6593736c-3b8a-47eb-ab39-99686a36692b/senior-data-architect ## About the Role You will architect the platform on the Microsoft Azure data stack - Data Factory for orchestration, Databricks and PySpark for transformation at scale, and a Delta Lake serving layer feeding analytics and downstream applications. This is a senior individual-contributor role with significant design authority: you decide how the platform is structured, not just how a given pipeline is written., * Seven or more years in data engineering, data warehousing, or data architecture, including two or more years in a lead or architect capacity. * Deep hands-on proficiency with Azure Data Factory, including metadata-driven pipeline design and production support ownership. * Deep hands-on proficiency with Databricks and PySpark, including Delta Lake, performance tuning, and cluster configuration. * Expert SQL, including complex analytical queries, window functions, query plan interpretation, and performance tuning. * Demonstrated experience designing dimensional models and enterprise data warehouse or lakehouse architectures from the ground up. * Experience with Git-based version control and CI/CD for data platform code. * Working knowledge of Azure platform services: storage, networking basics, identity and access management, and Key Vault. * Proven ability to communicate architecture decisions to non-technical stakeholders. * Practical experience using AI-assisted tools in data design, development, and documentation, and designing data so AI-enabled tools can use it reliably. * Healthcare experience, particularly with EMR/EHR data, revenue cycle, supply chain, or perioperative analytics, preferred. * Familiarity with healthcare data standards and coding systems: HL7 v2, FHIR, X12 837/835, CPT, ICD- 10, DRG, preferred. * Experience with Azure Synapse Analytics and Microsoft Fabric, including migration planning from existing Synapse or Azure SQL architectures, preferred. * Power BI experience at the semantic model level - DAX, composite models, incremental refresh, and gateway configuration, preferred. * Strong Python beyond PySpark - modular, testable code rather than notebook scripts, preferred. * Experience with Unity Catalog, Purview, or comparable governance and cataloging tooling, preferred. * Infrastructure-as-code experience (Terraform, Bicep, or ARM templates), preferred. * Streaming or near-real-time ingestion experience (Event Hubs, Structured Streaming, Auto Loader), preferred. * Relevant certification: Azure Data Engineer Associate, Azure Solutions Architect Expert, or Databricks Certified Data Engineer Professional, preferred., * Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field - or equivalent practical experience., Employment eligibility will be verified through the U.S. Department of Homeland Security's E-Verify system. All applicants must provide valid documentation to establish identity and authorization to work in the United States, as required by federal law. ## Description About the Role We are seeking a Senior Data Architect to own the design and evolution of our enterprise data platform. This role sets the architectural direction for how clinical, financial, supply chain, and operational data moves from source systems into a governed analytics layer that leadership relies on to run the business., Architecture & Platform Strategy * Own the target-state architecture for the enterprise data platform, including ingestion patterns, medallion layering, storage design, and the analytics serving layer. * Define and document standards for pipeline design, naming, partitioning, data typing, slowly changing dimensions, and incremental load patterns. * Evaluate platform options and make build-versus-buy and tooling recommendations with clear cost, performance, and maintainability tradeoffs. * Drive the roadmap for platform modernization - consolidating legacy extracts, reducing point-to- point integrations, and planning migration paths without disrupting existing reporting. * Design for cost control: cluster sizing and autoscaling policy, job scheduling, storage tiering, and monitoring of spend against workload value. Data Engineering & Pipeline Development * Design, build, and optimize orchestration in Azure Data Factory - parameterized and metadata- driven pipelines, linked services, integration runtimes, dependency management, and failure handling with retry and alerting. * Develop production-grade transformation logic in Databricks using PySpark and Spark SQL, including Delta Lake tables, MERGE-based upserts, schema evolution, partitioning strategy, and Z- ordering or liquid clustering for query performance. * Tune Spark workloads: diagnose skew, spill, and shuffle problems; right-size clusters; and reduce job runtime and cost without sacrificing correctness. * Build ingestion from heterogeneous sources - on-premises SQL Server, flat-file and SFTP feeds, REST APIs, and vendor extracts - with reliable change detection and watermarking. * Implement CI/CD for data assets using Git-based source control, environment promotion, and automated deployment of notebooks, pipelines, and schema changes. * Establish data quality controls: reconciliation checks against source, row-count and grain validation, duplicate and fan-out detection, and a regression baseline of known-good results so metric drift is caught before stakeholders are impacted. Data Modeling & Governance * Design dimensional and semantic models that support analytics without pushing business logic into individual reports; establish single-source-of-truth definitions for core metrics. * Partner with analysts on semantic layer design, ensuring grain, relationships, and measure logic are correct before reports are built on top. * Implement data lineage, cataloging, and documentation so platform knowledge does not live only in * one person's head. * Design access controls and data protection appropriate to protected health information - row-level security, masking, least-privilege service principals, and secrets managed in Key Vault. * Ensure platform design supports HIPAA compliance, auditability, and retention requirements. Leadership & Collaboration * Serve as the senior technical reference for data engineering and modeling practices. * Use AI-assisted tooling in your own design, development, documentation, and data quality work, and help the team do the same. * Translate ambiguous business needs from clinical, revenue cycle, and finance stakeholders into architectural requirements. * Present architecture proposals, risks, and tradeoffs to IT and executive leadership in terms they can act on. * Participate in change control and release governance for platform changes affecting production reporting.