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.

Essential Functions:

• 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

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global’s Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

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 -dbt certification

-familiarity with AWS