Centralizing data in Snowflake enables AMN Healthcare’s analysts to explore staffing opportunities by city, region and specialty. “Our analytics team can easily write queries that join data from Salesforce and PeopleSoft without hopping between databases,” Melendez says.
Numerous departments and teams at AMN Healthcare rely on Microsoft Power BI and Snowflake for data-driven dashboards and reports. For example, AMN Healthcare’s business review dashboard keeps sales leaders informed about key metrics that impact client success. Candidate dashboards help staffing experts fill open positions with talent from nearby markets to minimize relocation expenses. Operations teams monitor job runtime performance with less back and forth. According to Melendez, “We can put that data in Snowflake and provide an operational dashboard instead of having to contact the DBA team.”
Client-facing dashboards provide visibility for tracking successful placements, average rates by position, and cost of doing business with AMN Healthcare. Rapidly responding to clients’ time-sensitive ad hoc reporting requests is also easier with Snowflake. “When strikes occur, clients need near real-time dashboards to staff up quickly,” Melendez says.