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.