Talent.com
Data and Integration Architect
Data and Integration ArchitectCayuse • Chicago, IL, US
Data and Integration Architect

Data and Integration Architect

Cayuse • Chicago, IL, US
[job_card.variable_hours_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

Job Description

The exciting world of scientific research is fueled by people with a passion for solving complex problems. At Cayuse, we are committed to our customers' success by empowering organizations to conduct globally connected research that advances their impact on science, discovery and society. We build on that commitment with proven, integrated and easy-to-use technology that delivers exceptional value, and world class service and support that accelerates outcomes.

But we are more than just an empowering platform powered by advanced technologies. We are a collaboration of exceptional, highly skilled people with multi-disciplinary expertise, and are building our team to support our ambitious growth plans. Cayuse's foundational strength comes from our customer and employee focused values and commitment to industry-leading solutions. It's an exciting time to become a key member of our growing team.

The Data & Integration Architect at Cayuse is a key technical leader responsible for designing and evolving our multi-tenant SaaS platform's suite-wide data architecture and integration strategy. This role transcends traditional data pipeline and ETL-focused responsibilities, emphasizing a holistic approach to data modeling, API-driven integrations, governance, and scalable architecture patterns. The Data & Integration Architect collaborates with engineering, product, peers in the architecture team, and other stakeholders to create innovative data and integration solutions that deliver a seamless experience for customers while ensuring adherence to best practices in governance, compliance, quality, and performance.

The ideal candidate will have a strong background in data architecture and a broad understanding of modern integration patterns, enabling seamless data exchange between systems, applications, and external services. This is an opportunity to shape the future of Cayuse's data and integration landscape, ensuring reliability, scalability, security, and business alignment across all products.

Key Responsibilities Strategic Data & Integration Leadership

  • Define and drive a comprehensive data and integration strategy aligned with SaaS multi-tenancy, security, and scalability requirements.
  • Collaborate with product management, engineering leadership, fellow architects, and business stakeholders to design interoperable and future-proof data and integration solutions.
  • Establish and evolve the suite's conceptual, logical, and physical data models, ensuring consistency, flexibility, and efficiency across products.

Data Architecture & Governance

  • Develop a unified data model for the suite, defining common entities and relationships across multiple product domains.
  • Define extensible data architectures, supporting multi-tenant and customer-specific configurations (e.g., custom form definitions) without compromising performance.
  • Lead the development of governance frameworks, ensuring data quality, security, and compliance (including regulatory considerations such as HITRUST, HIPAA, GDPR, and FedRAMP where applicable).
  • Guide decisions on database and data management solutions tailored to specific use cases, considering performance, scalability, and cost-effectiveness.
  • Design dynamic data extension mechanisms to support customer-specific tenant requirements (e.g., custom form definitions).

    • Integration & API Strategy

  • Design and standardize suite-wide API and data exchange patterns, ensuring seamless integration between products and external ecosystems.
  • Define and advocate for event-driven architectures, ensuring scalable and decoupled integrations across Cayuse's platforms.
  • Partner with engineering teams to implement high-performance, scalable APIs for both internal and external use cases, ensuring data consistency and efficiency.
  • Support decisions on data ingress, egress, synchronization, and replication across the suite.
  • Partner with stakeholders to ensure alignment between governance and operational data practices.

    • Collaboration & Enablement

  • Balance strategic vision with tactical execution, actively engaging in architecture and design reviews, providing technical leadership and best practices to engineering teams. Balance strategic vision with tactical execution, actively engaging in developing and implementing data models, patterns, and solutions to ensure alignment with suite-wide objectives.
  • Deliver reusable data and integration patterns, accelerating product development and improving system maintainability.
  • Educate and mentor engineers, product teams, and stakeholders on modern data architectures, API design, and integration principles. Work closely with the Data Products Engineering and Data Operations teams to translate the data strategy and roadmap into actionable deliverables, providing technical guidance throughout the development lifecycle.

    • Execution & Operational Support

  • Drive hands-on efforts in conceptual, logical, and physical modeling for complex or strategic use cases.
  • Partner with SREs and DevOps teams to optimize data infrastructure and integration reliability, scalability, and security.
  • Provide expert guidance on ensuring data quality and integrity across the entire data lifecycle, including customer onboarding, synchronization, and transformation.
  • Define monitoring, observability, and data lineage strategies, ensuring transparency and operational efficiency.

    • Skills and Qualifications Required

  • Demonstrated success as a Data Architect, Integration Architect, or in a similar role, within a multi-tenant SaaS environment.
  • Expertise in data modeling at all levels (conceptual, logical, and physical), including experience with dynamic and extensible models.
  • Proficiency in database and data management technologies, including relational (e.g., Postgres) and cloud-native solutions (e.g., Snowflake, AWS RDS).
  • Deep understanding of API design principles, including REST, bulk file-based, asynchronous, and event-driven architectures (e.g., Kafka, AWS EventBridge).
  • Deep understanding of data warehouses, including design, optimization, and best practices for analytics.
  • Experience designing and implementing scalable, tenant-aware data architectures.
  • Strong grasp of modern integration patterns, including API gateways, data streaming, and hybrid batch-stream processing.
  • Knowledge of modern data governance practices including data security, lineage, observability, and compliance requirements.
  • Excellent collaboration, communication, and influence skills, with experience working across product, architecture, engineering, and operational teams.

    • Preferred

  • Familiarity with AWS data services (e.g., Glue, S3, Athena) and tools like Matillion for data pipeline development.
  • Familiarity with advanced analytics tools and platforms such as Tableau, Microsoft Power BI, Amazon QuickSight, SiSense, and Sigma.
  • Hands-on experience with modern data pipeline orchestration tools (e.g., Apache Airflow, AWS Step Functions, Matillion).
  • Experience designing data strategies for hybrid SaaS products transitioning from legacy solutions.
  • Knowledge of domain-driven design and its application to data architecture.
  • Experience designing and implementing data quality capabilities with orchestration tools (e.g., Apache Airflow, AWS Step Functions) and data observability platforms (e.g., Monte Carlo, Datafold).

    • Key Outcomes

  • Suite-wide data model established, ensuring consistency and flexibility.
  • Scalable API and integration patterns implemented across Cayuse's platform.
  • Clear Data & Integration roadmap defined and aligned with business objectives as well as the Cayuse SaaS Platform Plane and the Cayuse Data Plane.
  • Governance frameworks adopted, improving data quality, compliance, and security.
  • Reduced time-to-delivery for product teams, leveraging reusable data and integration patterns.
  • Successful deployment of at least one major Data Plane capability within 12 months.
  • Increased adoption of shared platform services, reducing duplication and improving suite cohesion.
  • Measurable improvements in data quality, scalability, and maintainability, tracked through defined KPIs.

    • Benefits

  • Competitive Medical Benefits (PPO + HSA available)
  • Vision, Dental, Short-Term Disability fully covered by Cayuse
  • Unlimited PTO + Holidays + Flexible Work Schedule
  • Remote Work Stipend
  • Equal Paid Parental Leave
  • 401k with Employer Matching
  • Quarterly Wellness Reimbursement
  • Remote Work Environment, supporting the Ultimate Employee Experience

    • Cayuse does not accept agency resumes. Please do not forward resumes to our jobs alias or any Cayuse employees. Cayuse is not responsible for any fees related to unsolicited resumes.

    Our culture is one of inclusion and belonging where everyone feels respected, treated justly, supported and nourished. We all share responsibility for creating and sustaining a work environment where differences are celebrated and we are empowered to strive for excellence. We're proud to be an equal opportunity employer and actively seek to recruit, develop, and retain a diverse and talented workforce.

    [job_alerts.create_a_job]

    Integration Architect • Chicago, IL, US

    [internal_linking.similar_jobs]
    Lead Analytics Engineer, Data Architecture

    Lead Analytics Engineer, Data Architecture

    Vizient, Inc. • Chicago, IL, United States
    [job_card.full_time]
    When you're the best, we're the best.We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents. We provide extensive opportunities for ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Databricks Solutions Architect

    Databricks Solutions Architect

    Medium • Chicago, IL, United States
    [job_card.full_time]
    Wavicle Data Solutions is a founder‑led, high‑growth consulting firm helping organizations unlock the full potential of cloud, data, and AI. We’re known for delivering real business results through ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Application Architect - AI & ML

    Senior Application Architect - AI & ML

    Aon • Chicago, IL, United States
    [job_card.full_time] +1
    Architect for Global Studio is responsible for end-to-end technical strategy and technical designs in partnership with Global Enterprise Architecture. This role will work across Aon Solution Lines t...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Architect I

    Data Architect I

    Ann & Robert H. Lurie Children's Hospital of Chicago • Chicago, IL, United States
    [job_card.full_time] +1
    The Data Architect I will be responsible for designing, creating, deploying and managing ETL jobs or other data applications / solutions in a hybrid (on-premises and cloud) data environment.This ro...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Architect

    Data Architect

    TechDigital Group • Chicago, IL, United States
    [job_card.full_time]
    Responsible for ensuring that the data management and governance frameworks are in place and adhered to.Responsible for architecting data engineering pipelines including data acquisition, ingestion...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Architect

    Data Architect

    Tata Consultancy Services • Chicago, IL, United States
    [job_card.full_time]
    Data Architect – Tata Consultancy Services.Join us as a Data Architect at Tata Consultancy Services to design enterprise‑wide data architecture strategies across multiple domains.Proficiency in SQL...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Architect I

    Data Architect I

    Children’s Research Fund • Chicago, IL, United States
    [job_card.full_time] +1
    Lurie Children’s Hospital of Chicago provides superior pediatric care in a setting that offers the latest benefits and innovations in medical technology, research and family-friendly design.As the ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Azure Integration Architect (Middleware / Integration experience (any platform)

    Azure Integration Architect (Middleware / Integration experience (any platform)

    Capgemini • Chicago, IL, United States
    [job_card.full_time]
    Job Description - Azure Integration Architect (Middleware / Integration experience (any platform) (082225).Azure Integration Architect (Middleware / Integration experience (any platform) - 082225.About...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Databricks Architect

    Databricks Architect

    Cushman & Wakefield • Chicago, IL, United States
    [job_card.full_time]
    Cushman & Wakefield is seeking a highly skilled Architect – Data Engineering to play a pivotal role in designing scalable, secure, and high-performing data solutions across the enterprise.Reporting...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Architect

    Data Architect

    EY • Chicago, IL, United States
    [job_card.full_time]
    At EY, we’re all in to shape your future with confidence.We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Platform Architect — RDARR & BCBS 239

    Senior Data Platform Architect — RDARR & BCBS 239

    KellyMitchell Group • Chicago, IL, United States
    [job_card.full_time]
    A contract consulting firm is seeking a Senior Solution Architect (ServiceNow IRM) in Chicago, Illinois.The role requires substantial expertise in data architecture, with a focus on BCBS 239 standa...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Architect

    Data Architect

    Mastek • Chicago, IL, United States
    [job_card.full_time]
    Job Title : Architect / Senior Data Engineer.We are seeking a highly skilled Architect / Senior Data Engineer to design, build, and optimize our modern data ecosystem. The ideal candidate will have d...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Databricks Architect

    Databricks Architect

    Cushman Wakefield Multifamily • Chicago, IL, United States
    [job_card.full_time]
    Cushman & Wakefield is seeking a highly skilled Architect – Data Engineering to play a pivotal role in designing scalable, secure, and high‑performing data solutions across the enterprise.Reporting...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Senior Data Architect — AI Data Platform, Flexible Location

    Senior Data Architect — AI Data Platform, Flexible Location

    Cuesta Partners • Chicago, IL, United States
    [job_card.full_time]
    A business consulting firm in Chicago seeks a Data Architect to lead transformational data programs.This role requires expertise in business data modeling, modern data delivery patterns, and master...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Hybrid Data Architect I : ETL and Analytics

    Hybrid Data Architect I : ETL and Analytics

    Ann & Robert H. Lurie Children's Hospital of Chicago • Chicago, IL, United States
    [job_card.full_time]
    A pediatric healthcare institution located in Chicago is seeking a Data Architect I responsible for designing and managing ETL jobs and data applications. You will work with various data sources, en...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    PIM & Data Integration Solutions Architect

    PIM & Data Integration Solutions Architect

    Flywheel Digital • Chicago, IL, United States
    [job_card.full_time]
    A leading digital commerce solutions provider is seeking a Syndigo Solutions Architect based in Chicago.In this role, you will focus on strategy and implementation for Syndigo platforms, managing t...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Presales Data Platform Architect - AI & Integration

    Senior Presales Data Platform Architect - AI & Integration

    Jobs via Dice • Chicago, IL, United States
    [job_card.full_time]
    A leader in cloud-based solutions is seeking a Sr Data Platform Solution Consultant in Chicago.This role involves driving innovative solutions utilizing ServiceNow's data platform and engaging with...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Data Architect

    Data Architect

    Akkodis group • Chicago, IL, United States
    [job_card.full_time]
    Responsible for designing scalable data models and implementing ETL pipelines to integrate data from multiple sources.Data Architect job responsibilities include : . Designing and implementing logical...[show_more]
    [last_updated.last_updated_30] • [promoted]