Data Architect

Carex Consulting Group; Green Bay (WI); Hybrid; USD 140,000 - 210,000; Full time

Job summary

Carex Consulting Group is seeking a senior Data Architect to lead enterprise data strategy, architecture modernization, and cloud data platform transformation. You will define target-state data architecture, optimize Databricks environments, and steer legacy warehouse modernization across global operations.

This role requires deep hands-on expertise, enterprise architecture leadership, and the ability to translate complex technical decisions into actionable business strategies with executive

Qualifications

• 14+ years of data engineering/architecture experience.

Responsibilities

• Lead the development of enterprise-wide data strategy, architecture principles, technical standards, and phased modernization roadmaps.
• Assess current-state data architecture, identify gaps, and design scalable target-state solutions.
• Architect and optimize Databricks environments and data platforms.
• Establish CI/CD, automation, observability, and cloud cost management practices.
• Lead legacy data warehouse modernization efforts (Oracle, Informatica, OBIEE).
• Develop migration strategies, data modeling standards, and governance frameworks.
• Define data integration frameworks for batch, CDC, streaming, and APIs.
• Collaborate with BI to align semantic models and analytics platforms.
• Present modernization strategies to executives and stakeholders.

Skills

Data engineering

Enterprise architecture

Databricks

Data governance

Cloud platforms

Communication leadership

Architecture modeling

ADR creation

Tools

Databricks

Delta Lake

Unity Catalog

CI/CD

Terraform

Power BI

Job description

Data Architect – Data Strategy & Platform Modernization

Location: United States - Green Bay, WI preferred; remote within the U.S. (Central Time) with periodic onsite travel to Green Bay.

Summary

Carex is partnering with a Manufacturingindustry partner to hire an experienced Data Architect – Data Strategy & Platform Modernization to lead enterprise data strategy, architecture modernization, and cloud data platform transformation.

This senior-level role will define the target-state data architecture, optimize Databricks environments, and lead the modernization of legacy data warehouses and integration platforms. The ideal candidate brings deep hands-on technical expertise, strong enterprise architecture experience, and the ability to translate complex technical decisions into actionable business strategies.

This position requires a strategic technical leader who can collaborate with enterprise architects, data engineering teams, and executive stakeholders to establish scalable, secure, and governed data platforms supporting analytics, business intelligence, and AI initiatives.

What You’ll Do

• Lead the development of enterprise-wide data strategy, architecture principles, technical standards, and phased modernization roadmaps.

• Assess current-state data architecture, identify technical gaps, and design scalable target-state solutions across global business operations.

• Evaluate and recommend modern data architecture patterns, including medallion architecture, lakehouse, data mesh, and hybrid approaches.

• Architect and optimize Databricks environments, including Delta Lake, Unity Catalog, Workflows, Delta Live Tables, SQL warehouses, and serverless computing.

• Establish engineering best practices for CI/CD, infrastructure automation, observability, performance optimization, and cloud cost management.

• Lead legacy data warehouse modernization initiatives involving Oracle, Informatica, OBIEE, and related enterprise data technologies.

• Develop migration strategies encompassing dependency mapping, asset rationalization, phased migrations, parallel processing, reconciliation, and legacy system retirement.

• Define enterprise data modeling standards using dimensional modeling, Data Vault 2.0, medallion architectures, and domain-oriented data products.

• Design data integration frameworks supporting batch processing, change data capture (CDC), streaming, APIs, federation, and data sharing.

• Establish data governance frameworks covering metadata management, lineage, data quality, access controls, data contracts, and data product certification.

• Design Unity Catalog structures and implement security standards, including role-based and attribute-based access controls, data masking, and row- and column-level security.

• Collaborate with business intelligence teams to align semantic models, reporting architecture, and analytics platforms with enterprise data strategy.

• Assess data platform readiness for AI, generative AI, intelligent document processing, and advanced analytics initiatives.

• Develop architecture decision records, technical design documentation, and recommendations for architecture review boards.

• Lead technical workshops, architecture reviews, and executive presentations to communicate modernization strategies and architectural trade-offs.

• Provide technical guidance and design oversight to data engineers, data modelers, and globally distributed delivery teams.

• Partner with business and technology leaders to ensure architectural recommendations align with business objectives, operational requirements, and long-term scalability.

What You’ll Bring

• 14+ years of experience in data engineering, enterprise data architecture, or related technical disciplines.

• 5+ years of experience serving as a Lead or Principal Data Architect designing enterprise-scale cloud data platforms.

• Demonstrated experience leading an enterprise data strategy or modernization assessment from discovery through executive-approved target architecture and implementation roadmap.

• Deep hands-on expertise with Databricks, including Delta Lake, Unity Catalog, Workflows, Delta Live Tables, SQL warehouses, and compute optimization.

• Strong understanding of modern data architecture patterns, including lakehouse, medallion, data mesh, and domain-oriented architectures.

• Proven experience architecting migrations from legacy enterprise data warehouses and ETL platforms, such as Oracle, Informatica, or OBIEE, to modern cloud platforms.

• Experience developing migration strategies involving dependency analysis, workload rationalization, reconciliation, data validation, and phased cutover.

• Expertise in data modeling methodologies, including Data Vault 2.0, dimensional/star schemas, and enterprise data products.

• Strong knowledge of data governance, metadata management, lineage, data quality, catalog architecture, and enterprise security controls.

• Experience designing batch, CDC, streaming, event-driven, API-based, and federated data integration solutions.

• Enterprise architecture experience with AWS, Azure, or Google Cloud Platform, including exposure to multi-cloud environments.

• Proficiency with modern DataOps practices, Git/GitHub, CI/CD pipelines, Terraform, automated testing, and pipeline observability.

• Experience creating Architecture Decision Records (ADRs), participating in architecture review boards, and managing enterprise architecture standards.

• Excellent communication, stakeholder management, and technical leadership skills, including the ability to present complex architectural recommendations to senior executives.

• Ability to lead technical discussions, evaluate architectural trade-offs, and influence enterprise technology decisions.

• Must be based in the United States and available for periodic onsite meetings and workshops in Green Bay, Wisconsin.

Preferred Qualifications

• Databricks Data Engineer Professional, Databricks Solutions Architect, or relevant cloud architecture certifications.

• Experience with Power BI architecture, semantic models, Direct Lake, Import, DirectQuery, and enterprise BI modernization.

• Familiarity with federated data governance, hub-and-spoke operating models, and data mesh adoption.

• Experience designing AI-ready data platforms, generative AI architectures, conversational analytics, or intelligent document processing solutions.

• Exposure to Google Gemini, Vertex AI, or related AI technologies.

• Experience supporting manufacturing, consumer packaged goods, supply chain, quality management, or ERP data environments.

• Familiarity with Oracle EBS or Infor Optiva PLM.

• Knowledge of cloud FinOps practices, including cost attribution, chargeback/showback, and workload optimization.

• Experience collaborating with globally distributed engineering teams and offshore delivery organizations.

• TOGAF or equivalent enterprise architecture certification.

Carex Consulting Group is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity, or Veteran status.