Sr. Analytics Engineer

A client is seeking a Senior Analytics Engineer to join their growing Data & Analytics team! This person will be passionate about using data to create value and will have a strong background in data & analytics engineering. This person will be essential in increasing accessibility to data and empowering teams to make informed decisions. This person will partner directly with multiple product team functions and domains and will drive impact through their data strategy, vision, and architecture., * Design and implement large-scale data warehouses and data marts using Snowflake, Star, or Data Vault 2.0 schemas to enable product-focused insights

• Build and maintain data transformation pipelines using SQL frameworks like dbt to abstract model code from implementation
• Write complex SQL, including window functions and STRUCT/ARRAY manipulations, while adhering to performance best practices like clustering and incremental modeling
• Manage and optimize Airflow DAGs, including troubleshooting task failures and improving run times
• Implement metadata management, data lineage, and security principles such as "least-privilege" access and data retention policies
• Use a test-driven approach to design systems that trap poor quality data and trigger alerts within the data flow
• Partner with engineering, data science, and business stakeholders to own project scopes and mentor others on data best practices

Minimum 5 years of experience in data and analytics engineering with proficiency in Python and SQL within a Snowflake environment -Expertise in SQL, window functions, STRUCT/ARRAY manipulation, and query optimization -Minimum 3 years of experience with dbt - must be skilled in using dbt to build data transformation pipelines -Experience in owning large-scale data projects that showed significant impact across the organization by effectively partnering with engineering, data analysts, data scientists, and other business stakeholders. -Ability to mentor other stakeholders in Data Science/Analytics, PM, and Engineering on data best practices -Experience leading the design, implementation, and monitoring of large-scale data warehouses and data marts that enable clear insights -experience in promoting performance best practices for your tables and designing systems with a test-driven approach to trap bad data or highlight alerts as part of data flow -Understanding of ETL processes and tools to clean data for analysis

Nice to Have Skills & Experience

-dbt certification -familiarity with AWS

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.