Principal Enterprise Data Architect

JOHNSON HEALTH TECH TRADING INC • Village of Cottage Grove, WI

4h • Onsite

About The Position

Johnson Health Tech is seeking a Principal Enterprise Data Architect, a senior technical leader responsible for the architecture, design, implementation, and evolution of the company’s global enterprise data environment. This role will lead the technical design of the Databricks-based data platform, covering data integration, transformation, governance, and delivery from various enterprise sources like SAP, Microsoft Dynamics CRM, e-commerce, and operational systems. The position involves establishing technical standards and patterns for data movement across the organization, translating business and technology requirements into scalable solutions, and collaborating with global IT, data engineering, analytics, infrastructure, security, application, and business teams.

Requirements

• Bachelor’s degree in computer science, information systems, engineering, data management, or related field, or equivalent professional experience.
• At least 15 years of progressive experience in data architecture, data engineering, enterprise integration, software engineering, or related technical disciplines.
• Extensive experience designing and implementing enterprise-scale data platforms.
• Demonstrated experience serving as a senior architect, principal engineer, technical lead, or equivalent enterprise technical authority.
• Expert-level SQL skills and advanced proficiency in Python for data engineering, automation, integration, platform development, and ETL/ELT pipelines for large and complex enterprise data sets.
• Deep experience with Databricks, Apache Spark, Delta Lake, lakehouse architecture, data modeling, data warehousing, dimensional design, data lakes, and analytical data structures.
• Experience integrating ERP, CRM, e-commerce, manufacturing, financial, logistics, or other enterprise applications, including SAP, Microsoft Dynamics CRM, APIs, file-transfer methods, database connectivity, message-based integration, and cloud data-integration patterns.
• Experience with source control, automated deployment, testing, monitoring, modern software development practices, documentation, and repeatable technical standards.

Nice To Haves

• Master’s degree is preferred.
• Experience with Microsoft Azure, Amazon Web Services, hybrid cloud environments, Databricks Unity Catalog, governance, security, lineage, orchestration, and platform administration.
• Experience with Power BI, Tableau, data-product, data-mesh, domain-oriented, or federated data-architecture concepts.
• Experience with change data capture, event streaming, message queues, real-time data processing, DevOps, DataOps practices, and global enterprise environments with multinational deployment requirements.

Responsibilities

• Define and maintain the technical architecture for Johnson Health Tech’s global enterprise data environment, including the Databricks lakehouse platform and supporting cloud, integration, and data-processing components.
• Establish scalable architectural patterns and ensure architecture decisions support performance, scalability, reliability, security, maintainability, cost effectiveness, and appropriate emerging technology improvements.
• Lead the technical design and implementation of ETL and ELT pipelines connecting SAP, Microsoft Dynamics CRM, e-commerce systems, operational applications, external platforms, and other enterprise data sources.
• Establish reusable integration frameworks, ingestion patterns, and data-processing standards using SQL, Python, Databricks, Spark, APIs, and other integration technologies, and resolve data-platform performance, scalability, and reliability issues.
• Define enterprise data-modeling standards across raw, curated, analytical, and consumption-ready data layers.
• Design data structures that support reporting, analytics, data science, artificial intelligence, operational applications, and business planning, while promoting modular, reusable, testable, and consistent data-engineering practices.
• Serve as the senior technical authority for enterprise data architecture and data engineering.
• Establish and document architecture principles, development standards, naming conventions, integration patterns, and technical guardrails while providing guidance for complex data initiatives and critical platform components.
• Develop technical frameworks, documentation, reference architectures, and training materials required for global adoption of the data platform.
• Train and mentor regional technology teams to implement, operate, and extend the enterprise data environment within established architectural standards and local requirements.
• Incorporate data quality, lineage, observability, reconciliation, error handling, monitoring, and platform-performance requirements into platform and pipeline designs.
• Partner with data governance, cybersecurity, infrastructure, and application teams to ensure appropriate access controls, protection of sensitive data, and compliance with applicable privacy, security, retention, deployment, testing, release-management, disaster recovery, and business continuity requirements.
• Collaborate with enterprise application teams responsible for SAP, Dynamics CRM, e-commerce, manufacturing, logistics, finance, product, customer, and other operational systems, translating business requirements into actionable technical designs.
• Communicate complex technical decisions clearly, identify architectural risks and dependencies, influence technical decisions across teams, and partner with external vendors while maintaining ownership of the company’s architecture and technical standards.
• Other projects as needed.

Benefits

• Medical, dental, and vision insurance
• Company-paid life insurance and AD&D coverage
• 401(k) retirement savings plan
• Paid time off (PTO)
• FSA and HSA options
• Employee product discounts, wellness resources, and employee assistance programs

What This Job Offers

• Job Type: Full-time
• Career Level: Principal