Joe Searle

Experience

• 

  City of Overland Park

  Sept 2001 - Sept 2002

  Police Officer
• 

  Farmers Insurance

  Sept 2002 - Jun 2014

  Responsible for assisting with the maintenance of a staffing model supporting appoximately 1,200 employees. Designed and maintained a SharePoint site for the Auto line of business. Responsible for various recurring reports, ad hoc data extractions and analysis. Organized data in a logical manner that the end user could understand using visual and statistical techniques with tools such as Microsoft Excel and Access, OBIEE, and IBM's Cognos. Provided recommendations regarding analysis and trending information. Show less Develop functional requirements for internal customers, including Senior Leadership, to deliver reporting solutions and complete special projects. Responsible for various recurring reports, ad hoc data extractions and analysis. Organize data in a logical manner that the end user can understand using visual and statistical techniques with tools such as Microsoft Excel and Access, Statsoft's Statistica, and IBM's Cognos. Provide recommendations regarding analysis and trending information and co-champion large analytics projects Show less

  • Claims Administration Manager

    May 2013 - Jun 2014

  • Casualty Claims Supervisor

    Jan 2012 - May 2013

  • Business Analyst I

    Jul 2008 - Jan 2012

  • Claim Quality Assurance Supervisor

    Oct 2006 - Jun 2008

  • Claims Supervisor

    Jun 2005 - Oct 2006

  • Office Claims Rep/CLD

    Sept 2002 - Jun 2005
• 

  AIG

  Jun 2014 - Oct 2019

  Senior Business Analyst/Claims Operations Manager
• 

  Kiewit

  Oct 2019 - Feb 2023

  Senior Data Analyst/Data Domain Lead
• 

  TFL

  Sept 2022 - now

  Manage a team of data engineers. Support Azure pipelines in data factory. Work with Azure dedicated SQL pools and Azure SQL databases. Support over 150 Power BI dashboards. Design and build new Power BI dashboards using data visualization best practices. In the process of designing and building a new data lakehouse that will house our on prem structured and unstructured data in a cloud solution. Build logging and data validation processes to ensure accuracy and validity of our data pipelines using Python and Azure Synapse Analytics. Use SQL and Python to handle ad hoc data request and data migration processes. Work closely with our Senior Leadership Team to ensure our data strategies are aligned with Company goals. Show less Formerly know as Tickets For Less and Ticket Solutions. Responsible for converting legacy processes to new data pipelines in Azure Synapse Analytics/Azure Data Factory. Design and create a new data warehouse in Azure dedicated SQL pool using Python. Create, maintain and update stored procedures in a SQL Server environment. Work with executive stakeholders to understand and assist in building a data and analytics strategy. Gather and analyze requirements for complex net new Power BI dashboards. Build Power BI templates so new dashboards can be set up in production very quickly. Use data to tell a story to the both external and internal stakeholders. Show less

  • Lead Data Engineer

    Sept 2023 - now

  • Data Engineer III

    Sept 2022 - now