Sr. Data Analyst -REMOTE Need resource in CanadaNEED STRONG IN SQL AND EXPERTISE IN LOOKML / LOOKER. SQL Query Optimization expertise is needed.
About the Role : Client is looking for curious data analysts who are deft at working with SQL and who are comfortable with a variety of databases and raw data formats.
We function in a fast-paced and friendly environment. You will collaborate and work with teams across the organization to ensure our data standards, pipelines and processes are held to high standards in order to guide finance, product, and marketing decisions.
This role is ideal for a highly technical, analytical and results-oriented professional with a passion for transforming healthcare data into actionable insights.
This individual is passionate and proficient in data storytelling and dashboard design with a proven ability to create visually compelling, interactive reports and dashboards to communicate meaningful data.
Responsibilities Monitor database content and provide recommendations to ensure that data quality, sanity, and accuracy are upheld Collaborate with a range of cross-functional stakeholders in multiple departments to understand data content, clarify business requirements, and formulate recommendations Perform intensive investigation and analysis of data anomalies and determine root causes Perform statistical analysis of large datasets Develop and manage monthly reporting for a range of internal customers Develop reporting tools & content to identify data outliers and issues Develop Enterprise data pipelines & dashboards Build valuable insights for our stakeholders by performing the analytical work to enable fast and accurate attribution and adjudication of prescription claims and coupons as well as improve vendor & pharmacy relationships and maximize patient savings Monitor transaction performance, implement automated reporting and conduct deep dives on drivers behind trends and anomalies that impact GoodRx’s top key results dramaticallySkills & Qualifications The ideal candidate for this role is someone who enjoys both being in-the-weeds with data and synthesizing analyses for non-technical collaborators and product leadership Ability to work extensively with SQL Expertise in LookML - able to build complex Looker Visualization using custom scripts Experience working with AWS, dbt Proven ability to manipulate and interpret data to produce insights and recommendations across large / diverse datasets Ability to communicate complex ideas clearly and concisely, verbally and in writing Presentation-building skills (PowerPoint, Google Slides, etc.
and a good eye for concise data visualization (Excel, Google Charts, etc) Ability to triage suspected inconsistency with data and work through SQL scripts to determine root cause Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy Ability to define and manage overall schedule and availability for a variety of data sets Use of data mining techniques to extract information from data sets and identify correlations and patterns to help build and improve our products Knowledge of statistics and experience using one or more statistical packages for analyzing datasets (Excel, SPSS, SAS, etc.
Proven working experience as a Data Analyst or Business Data Analyst 4+ years in strategy, analytics or finance role supporting multiple stakeholders