> Markdown version of [/jobs/ext/603727-sr-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/603727-sr-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr. Analytics Engineer - **Company:** Insight Global - **Location:** Santa Monica, CA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Data Analysis, Acceptance Test-Driven Development, Big Data, Data Infrastructure, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Retention, Data Vault Modeling, Python (Programming Language), Meta-Data Management, Query Optimization, SQL Databases, Data Streaming, Snowflake, Data Strategy, Data Lineage, Data Analytics - **Published:** June 12, 2026 - **Apply:** https://dejobs.org/x/x/13797297AA0C4AFEB69368AAD74A820A/job/ ## About the Role 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 ## Description 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/. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)