Data Architect

We’re KSM, one of the top 50 largest independent advisory, tax, and audit firms in the United States. But more than our size, it’s our people and culture that set us apart. We believe great things happen when people are supported, challenged, and given the freedom to do their very best work. That’s why we’ve built a workplace where your career and personal life can thrive together – where you have the flexibility to manage your time, the resources to grow, and a team that genuinely cares about your success.

We’ve been employee‑owned since 2001, giving every team member a stake in our collective success. This ownership mentality fosters a culture of collaboration, curiosity, and excellence – where new ideas are welcomed, different perspectives are valued, and you’re encouraged to explore what excites you most. Whether you’re expanding your skills, tackling new challenges, or making an impact beyond the office, we provide the resources and support to help you grow in the direction that’s right for you.

At KSM, your contributions matter – not just to the firm, but to your colleagues, clients, and the communities we serve across the U.S. If you’re looking for a place where you can do meaningful work, build lasting relationships, and grow in ways that align with what’s most important to you, we’d love to meet you.

Katz, Sapper & Miller (KSM) is transforming into a data‑driven, AI‑empowered firm. The Data Architect will lead the design and implementation of KSM’s enterprise data lakehouse on Databricks, enabling analytics, automation, and AI across the organization. This role combines strategic vision and hands‑on technical execution, ensuring data is modeled, governed, and leveraged as a strategic asset.

• Design KSM’s Databricks‑based lakehouse architecture, integrating structured, semi‑structured, and unstructured data from diverse enterprise systems.
• Define the end‑to‑end data architecture blueprint, covering ingestion, storage, modeling, governance, and access.
• Develop and implement data governance, lineage, and quality frameworks that ensure scalability, compliance, and trust.
• Create and maintain enterprise data models (conceptual, logical, and physical) to support analytics, BI, and AI use cases.
• Collaborate with data teams to design high‑performance ETL/ELT pipelines, Delta Live Tables, and streaming data processes.
• Optimize Databricks compute and storage performance, applying cost and performance best practices.
• Implement CI/CD standards for data pipelines and infrastructure‑as‑code to ensure consistent, automated deployments.
• Enable discoverability and access through effective metadata management and Unity Catalog.
• Partner with business and IT stakeholders to align data architecture decisions with firm‑wide analytics and AI strategy.
• Evaluate emerging technologies in data platforms, AI integration, and cloud infrastructure to guide KSM’s data evolution.

• 7+ years of experience in data architecture, data engineering, or enterprise data design.
• Proven experience designing Databricks or other modern lakehouse architectures.
• Deep expertise in data modeling, ETL/ELT design, and governance frameworks.
• Strong understanding of modern data architecture patterns, including medallion architecture, data mesh, and real‑time streaming.
• Proficiency in SQL, Python, PySpark, and orchestration tools (e.g., Airflow, dbt, or similar).
• Experience implementing CI/CD and infrastructure‑as‑code for data platforms using Terraform.
• Familiarity with Power BI or similar BI/analytics tools.
• Demonstrated ability to collaborate effectively across technical and business teams to deliver measurable results.
• Excellent communication and documentation skills with the ability to explain complex technical concepts clearly.

• Experience implementing Unity Catalog and Delta Sharing for governed data access.
• Exposure to machine learning and AI integration within data pipelines.
• Background in professional services or multi‑entity organizations.
• Certifications in Databricks or Data Engineering.

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, color, sex, sexual orientation, gender identity, disability, genetic information, national origin, race, religion, veteran status, or any other protected category.

KSM only accepts resumes directly submitted by a candidate and referrals submitted by current KSM employees. Unsolicited resumes or candidate profiles sent by staffing agencies and fee‑based referral services will not be considered outside of a signed KSM vendor contract. KSM will not pay a fee to recruiters or agencies that do not have a signed KSM vendor contract.