Data Analyst

Key Responsibilities:

• Works independently within Data and Analytics with limited design help from manager or senior associates

• Advanced proficiency in SQL for querying, data manipulation, and optimization.

• Ability to write complex SQL queries, including subqueries, joins.

• Preferably 2 years experience with Snowflake. 

Ability to write complex SQL queries, including subqueries, joins.

• Leverage coding best practices and advanced techniques to ensure efficient execution of code against large datasets, ensuring code is repeatable and scalable

• Run, create and optimize standard processes to ensure metrics, reports and insights are delivered consistently to stakeholders with minimal manual intervention

• Leverage knowledge of data structures to prepare data for ingestion efforts, analysis, assembling data from disparate data sources for the creation of insights; accurately integrate new and complex data sources

• Review output of code for anomalies and perform analysis to determine cause, and work with Data, Analytics, Product and Technology counterparts to implement corrective measures

• Understands the concepts of quantitative and qualitative data and how to relate them to the customer to show value of analysis.

• Technical capabilities including SQL, BigQuery, R, Python, MS Excel / Google Sheets, Tableau, Looker

• Experience working as a team and collaborating with others on producing descriptive and diagnostic analysis