• KPMG
  • New York, NY
  • Jul 14, 2020
Full time Accounting

Job Description

The KPMG Advisory practice is currently our fastest growing practice. We are seeing tremendous client demand, and looking forward we don't anticipate that slowing down. In this ever-changing market environment, our professionals must be adaptable and thrive in a collaborative, team-driven culture. At KPMG, our people are our number one priority. With a wealth of learning and career development opportunities, a world-class training facility and leading market tools, we make sure our people continue to grow both professionally and personally. If you're looking for a firm with a strong team connection where you can be your whole self, have an impact, advance your skills, deepen your experiences, and have the flexibility and access to constantly find new areas of inspiration and expand your capabilities, then consider a career in Advisory.

KPMG is currently seeking a Manager in Deal Advisory and Strategy Analytics for our Deal Advisory practice.


  • Develop ETL pipelines, physical and logical data models to support reports, dashboards, and KPIs for internal and external stakeholders to meet business requirements
  • Problem solving with SQL and conduct root cause analysis on reporting and data issues; conduct performance tuning as needed
  • Monitor scheduled jobs and processes in our production environment to ensure successful completion and design processes to aid in troubleshooting
  • Assist with building prototype solutions as necessary or performing ad-hoc analysis to answer business questions
  • Create report user groups, setting-up RBAC (Role Based Access Control) for users, including implementing row-level security on data when needed
  • Adhere to our analytics best practices including code reviews, testing, and documentation


  • Minimum five years' of recent experience with writing complex SQL queries
  • Associate's degree from an accredited college/university; Bachelor's degree preferred
  • Excellent understanding of the Microsoft stack (SSRS, SSIS, SSAS, Excel, and Power BI) and working with PaaS and IaaS within Microsoft Azure
  • Strong understanding of data modeling and data warehouse concepts
  • Professional experience with data visualization tools, such as Power BI or Tableau
  • Strong communication skills and ability to work independently and on part of a team
  • Ability to travel up to 80-100%
  • Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future

KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please.