[Hiring] Data Architect 2 @Kodiak Solutions

Role Description

In this role, you will be responsible for defining, designing, and implementing data architecture patterns and frameworks that enable trusted, governed, and business-ready data and support AI-enabled use cases. The primary focus is to support, enable, and accelerate product development initiatives and broader organization by:

• Defining enterprise data management standards
• Developing models and architectures
• Establishing governance practices
• Optimizing automated data flows across cloud data platforms and modern transformation frameworks

As a Data Architect, you will:

• Evaluate and recommend technology capabilities that align with Kodiak Solutions standards, particularly across Microsoft Azure, Snowflake, Data Build Tool (dbt), Sigma, Acceldata, and related data governance, observability, and analytics platforms
• Build an expert understanding of Kodiak Solutions’ flagship products and the data capabilities required to support them
• Define reusable data products, semantic models, and architecture patterns that accelerate product development and analytics delivery
• Establish data contracts, schema standards, and integration patterns to improve reliability across source systems and consuming applications
• Lead metadata, lineage, catalog, and data observability strategy to improve discoverability, trust, reuse, and regulatory readiness
• Define AI-ready data standards, including data quality, access controls, lineage, privacy safeguards, and governance requirements for AI/LLM-enabled use cases
• Uphold and evolve enterprise data management standards
• Collaborate with data domain teams to refine requirements and design domain-specific data products
• Enforce and establish standards and data governance practices and maintain the data catalog
• Lead Proof-of-concept initiatives for new architecture approaches
• Lead engineering teams through conceptual, logical, and physical data modeling from requirements through implementation, including entity and relationship definition, normalization and denormalization decisions, naming standards, data types, keys, constraints, and model documentation
• Optimize and manage ELT/ETL data flows, transformation models, semantic layers, and performance patterns to improve reliability, efficiency, and accuracy
• Evaluate and recommend technologies aligned with Kodiak Solutions standards, including Snowflake, Azure data services, dbt, Sigma, Acceldata, data catalogs, data observability tools, and AI-enabled data services
• Collaborate with the Sr. Data Architect, enterprise architecture function, team leads, and data engineers to provide oversight and execute on a long-term data vision
• Partner with data engineering, analytics, product, security, and governance teams to support trusted self-service analytics and AI/LLM-ready data products

Qualifications

• 10+ years of experience across data architecture, data engineering, or analytics engineering
• Expert-level Snowflake experience spanning semantic views and integrations; security controls, including row-level security (RLS), masking policies, and role management; and performance and cost optimization
• Extensive experience in data architecture, with a focus on designing and implementing data frameworks
• Familiarity with Medallion and Lambda architecture patterns
• Proficiency in developing data models, architecture, and governance procedures
• Familiarity with modeling techniques for online transaction processing (OLTP) systems and with dimensional modeling for analytics
• Experience with data modeling and design tools such as Erwin, ER Studio, or comparable modeling platforms
• Expert level experience with dbt, including incremental model design, custom materialization, and test harness strategy
• Hands-on or architectural exposure to Sigma, Acceldata, Collibra, or related data stack is a plus
• Experience designing, implementing, or operating SQL Server
• Experience with CosmosDB or MongoDB is a plus