Senior Data Analyst (SQL / Snowflake / Tableau/Data Warehouse)

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

SCD - Slowly Changing Dimensions
Late Arriving Dimensions
DataWarehousing Concepts
DataModelling
SQL Coding

Job Details

Job Title: Senior Data Analyst (SQL / Snowflake / Tableau/Data Warehouse)
Location: Remote (Dallas Tx) -
Contract: C2C
Visa: No OPT/CPT
Exp: 12+ Years
Must Have Experience: (SQL / Snowflake / Tableau/Data Warehousing)
Key Skills to look for... (Client Expectations in below skills)
  • SCD - Slowly Changing Dimensions
  • Late Arriving Dimensions
  • Data Warehousing Concepts
  • Data Modelling
  • Data Warehousing
  • Live SQL Coding
Key skills to work: Working with SQL, Large/Diverse data sets, Presentation skills, statistical packages for analysing datasets & Tableau or similar reporting tools.
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. The duties and responsibilities of a data analyst include more than collecting and analyzing data. They also have to make this data accessible to those who need the information to streamline business processes. In general, the day-to-day activities of a data analyst may include the following:
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
  • Collaborate with Data Engineering to create Enterprise level data sets
  • 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
  • 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
  • Analyze utilization patterns of client's core product to inform product and marketing decisions and strategic planning
  • Monitor transaction performance, implement automated reporting and conduct deep dives on drivers behind trends and anomalies that impact Client top key results dramatically
Skills & 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
  • 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
  • Nice to have: Experience with writing LookML and Looker and/or Tableau and experience with DBT
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.