Sr. Analytics Engineer Consultant

A client of Insight Global is looking for an Analytics Engineer Consultant to help modernize their analytics platform by migrating business logic from Looker to dbt and building a scalable analytics foundation in Snowflake.

This is a hands-on consulting role focused on building trusted, reusable data models that power reporting, self-service analytics, and AI.

Responsibilities
· Migrate business logic, calculations, and metrics from Looker into dbt.
· Design and develop scalable dbt models following analytics engineering best practices.
· Build and optimize data models in Snowflake.
· Partner with business stakeholders to understand and translate Marketing, Sales, and Finance reporting requirements into reusable data models.
· Standardize business logic and metric definitions to improve consistency and governance.
· Write clean, modular, and well-documented SQL and dbt code.
· Develop automated tests and documentation within dbt.
· Optimize Snowflake performance, cost, and query efficiency.
· Leverage AI-assisted development tools (Cursor, Claude Code, GitHub Copilot, etc.) to accelerate development, improve code quality, and automate repetitive engineering tasks.
· Participate in code reviews and ensure adherence to analytics engineering standards and 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/.

· 4–6 years of experience in Analytics Engineering, Data Engineering, or Business Intelligence.
· Strong hands-on experience with dbt Core, including optimizing dbt models and snapshots, and managing dbt projects.
· Strong experience with data governance in Snowflake.
· Expert-level SQL skills.
· Experience migrating or centralizing business logic from BI tools into dbt or similar transformation frameworks.
· Experience supporting one or more- marketing, sales/GTM, finance
· Experience staging raw data sources, building dimensional data models and analytics-ready datasets.

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.