Advanced Analytics Lead

Your Journey at Crowe Starts Here: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 roleSpecific 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 cloudWe 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.The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Crowe, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $137,887.00 to $292,639.00 per year.Our Benefits:At Crowe, we know that great people are what makes a great firm. We value our people and offer employees a comprehensive benefits package. Learn more about what working at Crowe can mean for you!How You Can Grow:We will nurture your talent in an inclusive culture that values diversity. You will have the chance to meet on a consistent basis with your Career Coach that will guide you in your career goals and aspirations. Learn more about where talent can prosper!More about Crowe:Crowe (www.crowe.com) is one of the largest public accounting, consulting and technology firms in the United States. Crowe uses its deep industry expertise to provide audit services to public and private entities while also helping clients reach their goals with tax, advisory, risk and performance services. Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Global, one of the largest global accounting networks in the world. The network consists of more than 200 independent accounting and advisory services firms in more than 130 countries around the world.Crowe LLP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.Crowe LLP does not accept unsolicited candidates, referrals or resumes from any staffing agency, recruiting service, sourcing entity or any other third-party paid service at any time. Any referrals, resumes or candidates submitted to Crowe, or any employee or owner of Crowe without a pre-existing agreement signed by both parties covering the submission will be considered the property of Crowe, and free of charge.