KSM (Katz, Sapper & Miller) · 6 hours ago
Senior Data Engineer
Indianapolis
Full-time
Onsite
Senior Level
7+ years expKSM, one of the top 50 largest independent advisory, tax, and audit firms in the United States, is seeking a Senior Data Engineer. The role involves designing and maintaining the enterprise data platform, developing robust data pipelines, and collaborating with teams to ensure data quality and governance.
AccountingProfessional Services
Responsibilities
Design, build, and maintain KSM’s enterprise data platform using Databricks, Microsoft SQL Server, and Power BI, supporting analytics, reporting, and operational workloads
Lead the modernization of KSM’s SQL Server environment, including database upgrades, performance tuning, and adoption of newer SQL features and best practices
Develop and maintain robust, scalable data pipelines for ingesting, transforming, and serving data from internal and external systems
Partner with the software development team to support data-related needs, including writing and optimizing stored procedures, views, queries, and data models
Design and manage data models, warehouses, and lakehouse structures that enable reliable analytics and self-service reporting
Implement and monitor data quality, reliability, and governance controls to ensure trusted and auditable data across the firm
Collaborate with analytics and business teams to translate requirements into effective technical solutions
Support AI/ML and advanced analytics initiatives by ensuring data is well-structured, accessible, and performant (not as a primary ML engineer)
Troubleshoot and resolve complex data and performance issues across SQL Server, Databricks, and downstream tools
Serve as a senior technical resource and mentor, helping set data engineering standards and best practices across the organization
Monitor data quality and integrity, establishing processes for data validation and error handling
Automate and optimize data workflows to enhance efficiency, reliability, and scalability
Troubleshoot and resolve data-related issues promptly, maintaining system health and performance
Qualification
Required
Strong hands-on experience with Databricks, including Spark-based data pipelines, Delta Lake / Lakehouse architectures, and performance optimization
Experience designing and maintaining enterprise data platforms that support analytics, reporting, and downstream applications
Advanced proficiency with Microsoft SQL Server, including writing and optimizing stored procedures, views, complex queries, indexing, and performance tuning
Experience supporting SQL Server upgrades and modernization initiatives
Advanced SQL skills and proficiency in Python for data engineering and automation
Experience building and maintaining ETL / ELT pipelines and data transformations across multiple data sources
Strong understanding of data modeling for both relational and analytical workloads
Experience integrating data platforms with Power BI or similar business intelligence tools
Knowledge of data quality, governance, security, and access control best practices
Ability to troubleshoot and resolve complex data and performance issues across data platforms
7+ years of experience in data engineering, data platform development, or a related field
Proven experience designing, building, and supporting enterprise data solutions in production environments
Experience working closely with analytics, reporting, and application development teams
Exceptional problem-solving and analytical abilities
Excellent communication and collaboration skills, with the ability to lead and mentor teams
Knowledge of compliance frameworks and best practices in data governance
Preferred
Experience supporting both analytics teams and application development teams in a data engineering or platform role
Familiarity with cloud-based data platforms (AWS and/or Azure) and modern data tooling
Experience with DevOps or CI/CD practices for data pipelines and database deployments
Exposure to AI/ML or generative AI initiatives from a data enablement perspective
Prior experience in professional services, financial services, or regulated environments preferred, but not required
Relevant certifications (Databricks, Microsoft, AWS) are a plus but not required
Company
KSM (Katz, Sapper & Miller)
KSM (Katz, Sapper & Miller) is a nationally recognized advisory, tax, and audit firm.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
T
Tim Cook
CEO and President
Recent News
Seattle TechFlash
2025-05-17
Inside INdiana Business
2025-03-01
Cincinnati Business Courier
2025-02-25
Company data provided by crunchbase