Senior Data Engineer

Katz, Sapper & Miller • Full-time • Indianapolis, United States of America • 2w ago

Job Description:

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.

Key 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.

Required Qualifications:

Technical Expertise:

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.

Experience:

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.
Exposure to advanced analytics or AI/ML initiatives from a data engineering or data platform perspective is a plus.

Skills:

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 Qualifications

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.

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.

Related Jobs

Geotechnical Project Engineer

S&ME • Full-time • Indianapolis, IN, US • 3d ago

Engineering

Position: Geotechnical Project Engineer Requisition Number: 2026-1180-02 . Are you a Geotechnical Project Engineer seeking a challenging opportunity to grow your career with a firm committed to our employees and providin...

3d ago

Apply

Senior Security Engineer

Katz, Sapper & Miller • Full-time • Indianapolis, United States of America • 4d ago

Engineering

Job Description: 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...

4d ago

Apply

Construction Materials Engineering Technician

S&ME • Full-time • Indianapolis, IN, US • 1w ago

Engineering

Construction Materials Engineering Technician Requisition Number: 2026-1180-01 Are you launching your career or seeking a fresh challenge as a seasoned technician? S&ME is searching for motivated, full-time Construct...

1w ago

Apply

Senior Product Engineer - Seating

IMMI • Full-time • Westfield, IN, US • 1m ago

Engineering

Job Description IMMI is seeking a Senior Product Engineer to join our Seating Team. The Senior Product Engineer operates as a subject matter expert for team inquiries and cross-departmental trainings. Oversees the design...

1m ago

Apply

Spark Summer Intern - Civil / Environmental Engineering

S&ME • Full-time • Indianapolis, IN, US • 4m ago

Engineering

Position: 2026 Spark Summer Intern - Civil / Environmental Engineering Requisition Number: 2025-2950-03 S&ME is a leading, employee-owned, multi-disciplined professional services firm that responds to clients with in...

4m ago

Apply

Delivery Driver: Indianapolis, IN

Jasper Engines & Transmissions • Branch Operations Indianpolis, 1908 Stout Field W Dr, Indianapolis, Indiana, United States of America • 3d ago

Transportation

Delivery Driver: Indianapolis, IN **Offering a $2,000 Sign on Bonus** Join one of our 50+ branch locations throughout the United States and become a part of the JASPER family. JASPER is the nation’s largest re-manufactur...

3d ago

Apply

Delivery Driver: Indianapolis, IN

Jasper Holdings, Inc. • Branch Operations Indianpolis, 1908 Stout Field W Dr, Indianapolis, Indiana, United States of America • 3d ago

Transportation

3d ago

Apply

Staff Controls Auditor - IT Risk Advisory Services

Katz, Sapper & Miller • Full-time • Indianapolis, United States of America • 6d ago

Finance & Accounting Sales

6d ago

Apply

Talent Acquisition Specialist

IMMI • Full-time • Westfield, IN, US • 1w ago

Human Resources (HR)

Job Description About the Company IMMI® is the trusted, global leader in safety solutions, helping to protect millions of lives every day. For over sixty years, IMMI has led the way in developing, designing, testing and...

1w ago

Apply

HR Generalist

Katz, Sapper & Miller • Full-time • Indianapolis, United States of America • 1w ago

Human Resources (HR)

1w ago

Apply