Nicholas Diehl Email & Phone Number

Indianapolis, In, Us

Indianapolis, In, Us

Downers Grove, Il, Us

Downers Grove, Il, Us

Downers Grove, Il, Us

Portage, Michigan, Us

Portage, Michigan, Us

• Partnered with one of the world’s largest offshore drilling contractors to develop a modern data platform utilizing Azure Synapse, Azure Databricks, Azure Data Factory, Power BI, and other Azure Services.• Engagement and delivery lead on the 3rd largest client by annual revenue that more than doubled their engagement scope after realizing success with operational and safety reporting• Co-authored end to end Azure DevOps pipelines to enable CI/CD deployments to Dev/Test/Prod for ARM templates, ADF pipelines, Databricks, and semantic models • Trained several teammates and clients how to develop in the Azure architecture across Azure Data Factory, Databricks, and Power BI

Chicago, Illinois, Us

•Led a seven person data analytics team, prioritized incoming work for analysts, and aligned deadlines and compliance needs of a complex matrix organization in support of 90+ consultants•Implemented automated Net Revenue Reporting by gather information from multiple source systems and centralizing the information with MS Technologies (SQL Server, Tabular Models, etc) allowing for the creation of over $1.6MM in new revenue •Coordinating and developing with three other scrum teams to create a platform for over 100 client hospital systems which leverages a BI layer utilizing a mixture of Power BI / Azure Analysis Services as well as Azure SQL DB, Snowflake, Azure Functions, and Azure Data Factory to serve both application and self-service BI workflows, eliminating code duplication and accelerating new report development•Coordinated complex analytics projects for over 100 client hospital systems by working with senior leaders and service area leads, providing value that grew the team from three to seven people over the course of one year •Created a firmwide sales enablement tool and SDLC process with guidance from Crowe’s Chief of Data and business vertical partners that aggregates Net Fee Revenue and Sales Pipeline for four industry verticals, used by hundreds of senior leaders to identify cross-selling opportunities across clients •Consolidated two work intake processes into our Azure DevOps environment by leveraging Power Apps and Power Automate, improving response rate for requests and simplifying the client user experience•Created a semantic model with Power BI and a corresponding App to guide analytics for 40+ healthcare consulting engagements and trained users 30+ how to leverage self-service BI and Power Query to help reduce analytics requests by 10% and serve as a data analytics center of excellence for consultants

Chicago, Illinois, Us

• Bridged the gap between consulting and our Revenue Cycle Analytics (RCA) scrum team helping to translate business requirements and perform user acceptance testing• Managed consulting engagement teams that worked with some of the largest non-for-profit health systems explaining monthly Net Revenue results to CFOs and Directors• Trained hundreds of clients and internal staff how to use and analyze results from the RCA application as well as how to extract results via SQL

Chicago, Illinois, Us

• Co-created and validated the largest SQL data warehouse at Crowe Healthcare history, ingesting and reporting data from over 110 health systems and 1,150 facilities nationwide• Extracted data and calculated analytics from our SQL data warehouse while working with our market leaders to create quarterly thought leadership articles featured in outlets like HFMA• Led consulting engagements across the US for some of the largest non-for-profit health systems explaining monthly Net Revenue results to CFOs and Directors• Trained several clients and internal staff how to use and analyze results from the RCA application

Chicago, Illinois, Us

• Extracted data and calculated analytics from our SQL data warehouse while working with our market leaders to create quarterly thought leadership articles featured in outlets like HFMA• Prepared monthly deliverables for Net Revenue reporting engagements • Reduced software implementation time with writing macros in Excel and automated PowerPoint deliverables for time sensitive consulting engagements