Advanced Analytics Lead

At Crowe, you have the opportunity to deliver innovative solutions to today's complex business issues. Crowe's accounting, consulting, and technology personnel are widely recognized for their in-depth expertise and understanding of sophisticated process frameworks and enabling technologies, along with their commitment to delivering measurable results that help clients build business value. Our focus on emerging technology solutions along with our commitment to internal career growth and exceptional client value has resulted in a firm that is routinely recognized as a "Best Place to Work." We are 75 years strong and still growing. Come grow with us!

Job Description:

As an Advanced Analytics Lead at Crowe, you will provide critical solution development across a broad portfolio of external clients and industries. You retain a combination of functional knowledge and execution skills in leveraging SQL, SSAS Tabular, Power BI, and other Microsoft BI stack products. A solid background in accounting, finance, and business operations is a huge plus. Additionally, you have strong critical thinking and analytical skills with a proven track record in executing solutions from planning to delivery. You understand basic agile methodologies and are committed to the continuous improvement of your solutions. Use your business acumen and technical expertise to provide thought leadership to clients by demonstrating thought leadership through strategic advice. We don't want order-takers - we want trusted advisors.

At Crowe, you will join the Advanced Analytics team comprised of synergistic, high-functioning problem solvers with extensive consulting and industry experience. The team thrives on helping clients solve their complex business issues accurately, creatively, and expeditiously. Providing an excellent client experience, timely delivery, and communication are critical elements to success in this role.

Specific responsibilities include but are not limited to the following:

• Perform duties related to business analysis, such as scoping, documentation, project management, and related activities to establish an engagement blueprint.
• Interface and communicate with subject matter experts of varied backgrounds, including c-suite executives, to properly assess business intelligence requirements and execution strategy.
• Rapidly develop diverse POCs from various data sources and systems.
• Clean, transform and blend large and disparate data sources while leveraging SQL EDW, M, and DAX best practices.
• Leverage Tabular Editor, ALM Toolkit, and DAX Studio to quickly and efficiently perform model operations across complex deliverables.
• Perform ad-hoc data discovery using tools such as Power BI, SQL, or Excel.
• Create visually stunning and salient reports using tools such as Power BI or Tableau (additional tools are a major plus).
• Deploy, provision, and manage Power BI workspaces and deliverables.
• Possess effective writing and communication skills for audiences of diverse business and technical backgrounds.
• Balance multiple projects with attention to detail while meeting deadlines.
• Continuously improve processes with advancements in the MSBI platform.

Qualifications

• Bachelor's degree; MBA a huge plus.
• Interviewing for both Manager and Senior Manager Level.
• 10-15+ years of experience in a data analyst, developer, architect, or similar position.
• 8+ years of advanced experience with DAX, M, SQL, and Power BI.
• 10+ years of experience in creating dashboards and deploying to clients.
• 1.5+ years of experience in leveraging ETL SaaS tools (Talent, Stitch, Hevo, etc.,) or ADF Integration.
• 5+ years of experience in Power BI Service delivery and Admin role and responsibility.
• Expert knowledge of creating and optimizing dimensional models.
• Expert skills in Microsoft Excel and Outlook, strong skills in PowerPoint.
• Strong track record of developing high-quality models on-premise or in the cloud.

We expect the candidate to uphold Crowe's values of Care, Trust, Courage, and Stewardship. These values define who we are. We expect all of our people to act ethically and with integrity at all times.