Sr. Consultant, Data Architect

Introduction

At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk

Your role and responsibilities

As a Solution Data Architect within IBM Consulting's Data & AI practice, you will operate at the intersection of enterprise architecture, cloud data platform delivery, and client leadership. In this role, you will serve as the primary technical authority on large-scale, complex engagements - owning end-to-end architecture decisions, guiding a high-performing delivery team, and building trusted relationships with client stakeholders to drive measurable outcomes. This is a senior, client-facing role for an architect who is equally comfortable whiteboarding a platform strategy with an executive and diving deep into technical design with an engineering team.

· Serve as the primary technical point of contact for client stakeholders and executives; lead engagement planning, sprint ceremonies, and executive status reporting

· Proactively identify and communicate risks, blockers, and scope changes with proposed resolutions; partner with project managers and practice leadership on delivery health

· Own end-to-end Snowflake platform architecture including objects, governance models, and security at SnowPro Advanced: Architect depth

· Architect Bronze/Silver/Gold medallion data models optimized for Snowflake performance and downstream BI consumption

· Design and govern API strategy for exposing data products, including integrations with internal applications, external partners, and SaaS platforms via API-driven and event-based patterns on AWS (API Gateway, Lambda, EventBridge, SQS)

· Implement secure API authentication patterns including OAuth2 and token-based access; manage API lifecycle and cataloging aligned to enterprise standards

· Translate healthcare payer business requirements - spanning claims, member, provider, eligibility, and care management domains - into scalable data and integration architectures that comply with HIPAA, PHI/PII protection policies, and payer-specific regulatory standards

· Lead dbt model design including materialization strategy, macros, packages, snapshots, and testing; establish GitLab CI/CD pipelines and enforce coding and documentation standards

· Architect Snowflake-AWS integrations across S3, IAM, VPC, PrivateLink, and Glue; monitor pipeline SLAs and costs and lead root-cause analysis for incidents; support migration of legacy data feeds to modern cloud-based, event-driven architectures

· Manage and mentor data and analytics engineers; drive enablement on Snowflake, dbt, and GitLab best practices and contribute reusable accelerators to the broader practice

This role can be performed from anywhere in the US

Required technical and professional expertise

• 8+ years in data engineering, data warehousing, or solution architecture roles

• Client-facing consulting or professional services delivery experience with concurrent stakeholder and team management

• 3+ years hands-on Snowflake experience: warehouse management, clustering, RBAC, security model, Streams, Tasks, and Dynamic Tables

• dbt Core or Cloud: materialization strategies, macros, packages, snapshots, and testing framework

• GitLab CI/CD: pipeline configuration, merge request workflows, and dbt integration

• AWS production experience: S3, Glue, IAM, VPC, PrivateLink, and Secrets Manager

• SQL and Python proficiency for pipeline development and automation

• Healthcare payer domain knowledge spanning claims, member, provider, eligibility, care/case management, and risk adjustment

• Familiarity with HIPAA, PHI/PII data protection requirements, and secure healthcare data integration standards

Preferred technical and professional experience

• Snowflake SnowPro Advanced: Architect certification

• AWS Certified Data Analytics - Specialty or equivalent

• Snowflake Cortex AI/ML functions and agentic data workflows

• Snowflake Iceberg tables and external volume architecture

• Terraform for Snowflake and AWS infrastructure-as-code

• Event-driven integration patterns: EventBridge, Kinesis, SQS for operational and analytic data movement

• Enterprise metadata, lineage, and data governance tooling

• Experience designing secure healthcare APIs with strict PHI/PII access controls

IBM is committed to creating a diverse environment and is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, caste, genetics, pregnancy, disability, neurodivergence, age, veteran status, or other characteristics. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.