Data Analyst

Company Description

PatientFi® is a technology-based, point-of-sale financing company in Irvine, CA that partners with healthcare providers to offer patients a friendly payment solution for out-of-pocket medical and dental procedures. The company serves various healthcare specialties, including plastic surgery, dermatology, ophthalmology, dentistry, fertility, and medical spas. PatientFi's mission is to expand patient access to elective healthcare treatments by removing the cost barrier and providing patients with a convenient payment option.

Responsibilities 

• Gather requirements to build and maintain data analyses, risk triggers / rules, visualizations and interactive dashboards that will drive business decisions and risk monitoring (in BI tools, web analytics platforms, and excel) 
• Facilitate the analytical needs of the business, collaborate in the design of diagnostic solutions, and deliver outstanding data products and insights 
• Use internal and external analytics tools, SQL, and scripting languages to access and analyze multivariate data 
• Perform deep analyses to help us understand our data better and help build out robust risk management and monitoring tools and reports for the business 
• Use emerging tech and tools to evaluate trends and develop actionable insights 
• Use data to independently uncover problems and business opportunities 
• Support data migrations in order to automate repeatable tasks and KPI tracking throughout the business 
• Track and analyze performance of various business and risk segments and programs to evaluate effectiveness 
• Build analysis, data visualizations, and multi-functional reporting that provides critical support to the operations and decision-making of the organization 
• Help translate business functional requirements into technical specifications and, conversely, technical approaches into easily digestible terms 
• Provide analytics expertise to key business partners regarding data & analytics 
• Support Commercial, Marketing & Risk teams with process improvements for optimized delivery of diverse data requests 
• Support business partners in adopting reporting solutions and business intelligence tools for self-service 
• Write LookML and SQL queries and build dashboards in Looker 
• Systematically identify issues with data quality and help find solutions to address 
• Assist with ad-hoc projects and tasks as necessary 

Desired Skills/Education

• Bachelor’s degree or equivalent experience
• 2-4 years of experience in data analytics 
• 2-4 years of experience in designing and authoring reports/dashboards using Looker (or similar tools like Tableau, Power BI) is required.
• Proven proficiency and flexibility to perform analysis in SQL, Excel, BI tools, or whatever is best suited for the problem 
• Proven proficiency in basic statistics
• Strong communication skills 
• Proven experience with web analytics tools 
• Proven experience with business intelligence tools (Looker Required) and relational databases
• Prior experience with Data Science languages like Python, and/or R is preferred.
• Familiarity with ETL, data warehousing, and data modeling
• Expert SQL skills for complex querying, analysis, performance optimization, and persisting data 
• Experience demonstrating analytical concepts to craft an actionable story for technical and non-technical audiences
• Understanding of data warehousing concepts, design, modeling, data engineering
• Skilled in analyzing, interpreting and summarizing data 
• Very structured, detail-oriented and excellent data visualization skills

The requirements listed below are representative, but not all inclusive, of the knowledge, skill, and/or ability required.