Data Analyst

PatientFi

About The Position

The Data Analyst role involves gathering requirements to build and maintain data analyses, risk triggers/rules, visualizations, and interactive dashboards that drive business decisions and risk monitoring, utilizing BI tools, web analytics platforms, and Excel. This position facilitates the analytical needs of the business, collaborates in the design of diagnostic solutions, and delivers data products and insights. The analyst will use internal and external analytics tools, SQL, and scripting languages to access and analyze multivariate data, performing deep analyses to understand data better and build robust risk management and monitoring tools and reports. The role also requires using emerging technologies to evaluate trends, developing actionable insights, and independently uncovering problems and business opportunities. Key responsibilities include supporting data migrations to automate repeatable tasks and KPI tracking, tracking and analyzing the performance of various business and risk segments, and building analysis, data visualizations, and multi-functional reporting. The Data Analyst will help translate business functional requirements into technical specifications and provide analytics expertise to key business partners. Additionally, the role supports Commercial, Marketing & Risk teams with process improvements, assists business partners in adopting reporting solutions and business intelligence tools for self-service, writes LookML and SQL queries, builds dashboards in Looker, systematically identifies data quality issues, and assists with ad-hoc projects.

Requirements

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
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

Nice To Haves

Prior experience with Data Science languages like Python, and/or R is preferred
Familiarity with ETL, data warehousing, and data modeling

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