KSM (Katz, Sapper & Miller)

Advisory, tax, and audit firm providing visionary people with inspiration and insight to achieve great things.

Data Architect

Data EngineerData EngineerFull TimeRemoteTeam 201-500Since 1923H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

28 days ago

Salary

Not specified

Bachelor Degree7 yrs expEnglishPy SparkPythonSQLTerraformUnity

Job Description

• Define and maintain KSM’s Databricks lakehouse architecture, including ingestion, storage, transformation, modeling, and access patterns • Establish clear, repeatable design standards for Bronze, Silver, and Gold data layers to ensure consistency and reuse • Design architecture that supports structured, semi-structured, and unstructured data across enterprise systems • Design and implement data governance, lineage, and quality frameworks that ensure data is trusted, auditable, and scalable • Enable discoverability, access control, and metadata management using Databricks Unity Catalog and related tooling • Partner with data and analytics teams to define validation standards, reconciliation processes, and ownership models • Partner closely with the Senior Data Engineer to translate architectural standards into production-ready pipelines • Review and validate data pipelines, models, and workflows to ensure alignment with architectural best practices • Support teams by providing guidance, patterns, and examples rather than one-off solutions • Define best practices for Databricks compute and storage optimization, balancing performance and cost • Establish architectural patterns that promote reliability, scalability, and operational simplicity • Collaborate on monitoring, alerting, and operational standards to ensure platform health • Define and support CI/CD standards for data pipelines and lakehouse infrastructure • Partner with engineering teams to implement Infrastructure as Code (IaC) using tools such as Terraform • Ensure consistent, automated deployments across development, test, and production environments • Align data architecture decisions with firm-wide analytics, automation, and AI strategy • Help prioritize architectural investments that deliver near-term value while supporting long-term growth • Evaluate emerging data platform capabilities thoughtfully, focusing on practical adoption rather than experimentation for its own sake.

Job Requirements

  • 7+ years of experience in data architecture, data engineering, or enterprise data platform design
  • Proven experience designing and implementing Databricks or similar modern lakehouse architectures
  • Strong understanding of modern data architecture patterns, including medallion architecture and real-time or near-real-time data processing
  • Deep expertise in data modeling (conceptual, logical, and physical) for analytics and BI use cases
  • Hands-on experience with SQL, Python, and PySpark
  • Experience implementing data governance, lineage, and quality frameworks
  • Familiarity with Power BI or similar BI and analytics tools
  • Strong collaboration skills with the ability to work effectively across technical and business teams
  • Excellent communication and documentation skills, with the ability to clearly explain architectural decisions.

Benefits

  • flexibility to manage your time
  • resources to grow
  • team that genuinely cares about your success

Related Categories

Related Job Pages

More Data Engineer Jobs

Data Migration Engineer

Vineskills

We streamline your law firm with Filevine, so you can focus on what really matters.

Data Engineer28 days ago
Full TimeRemoteTeam 1-10H1B No Sponsor

Data Migration Engineer leading complex data migrations at Vineskills

AWSCloudETLMySQLPostgresPythonSQLSSIS
United States
$74.4K - $120K / year

Lead Data Engineer (Databricks)

Rearc

Rearc is a boutique Cloud Software & Services firm with engineers that have years of experience shaping the cloud journey of large scale enterprises. Our engineers are skilled at planning application migrations to the cloud and building cloud-native application environments and patterns for the future. We build strategic partnerships with our enterprise customers to enable long term success in the cloud.

Data Engineer28 days ago
Full TimeRemoteTeam 51Since 2016

As a Lead Data Engineer, you'll optimize data workflows, manage data engineering projects, mentor junior engineers, and ensure robust data solutions meet business needs.

Apache AirflowSparkAws RedshiftAzure Synapse AnalyticsDatabricksGoogle Bigquery
United States
Full TimeRemoteTeam 1-10Since 2023H1B No Sponsor

Healthcare Data Engineer developing scalable healthcare data systems for Habitat Health

AirflowAzureCloudPythonSQL
California
$135K - $155K / year
Data Engineer28 days ago
Full TimeRemoteTeam 10,001+Since 1954H1B Sponsor

Senior Data Engineer supporting customer analytics and data solutions

AWSCloudETLNumpyOraclePandasPostgresPythonSQLTableau
United States
$110.5K - $149.5K / year