Responsibilities Analyze complex and ambiguous business requirements and partner with product, analytics, and engineering teams to design scalable data solutions Design, develop, and optimize complex SQL transformations and data pipelines in Snowflake and Databricks using Delta Lake and PySpark Collaborate with frontend engineers to design or modify schema for optimal software performance Advanced database administration and development including stored procedures, user define functions, triggers and ELT/ETL packages using PySpark, SQL, and Python for large-scale data processing, as well as, security and roles Develop advanced Snowflake database objects including: Stored Procedures, User Defined Functions (UDFs), Views, Tasks, Streams, Dynamic Tables Design scalable data models (fact/dimension, star schema, normalized) to support reporting, analytics, and downstream applications. High competency level in MS Office with specific strengths in Excel (knowledge of VBA a plus) and PowerPoint Adheres to deadlines Advanced SQL programming skills, Redshift preferred (creating views, stored procedures, functions, etc.) Experience with Databricks, Snowflake (creating views, stored procedures, functions, etc.) Experience building scalable data pipelines using Databricks and Apache Spark (PySpark).