Source description
About the role
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
More at Sonata Software