Find your career

Find Your Career

Choose your

Practice Area

Manager, Deal Advisory and Strategy Analytics, Power BI Developer

New York, New York

Share

Apply now

Manager, Deal Advisory and Strategy Analytics, Power BI Developer

Requisition #: 49396

Practice Area: Advisory

Location: New York, NY

Known for being a great place to work and build a career, KPMG provides audit, tax and advisory services for organizations in today's most important industries. Our growth is driven by delivering real results for our clients. It's also enabled by our culture, which encourages individual development, embraces an inclusive environment, rewards innovative excellence and supports our communities. With qualities like those, it's no wonder we're consistently ranked among the best companies to work for by Fortune Magazine, Consulting Magazine, Working Mother Magazine, Diversity Inc. and others. If you're as passionate about your future as we are, join our team.

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

Responsibilities:

  • 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

Qualifications:

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

Apply now