Data Engineer

Job Description

We are seeking a skilled Snowflake Data Engineer to join our team in developing a centralized data management hub that supports digital marketing analytics and campaign measurement. This role is critical in transforming diverse digital datasets into actionable insights for internal platforms and external clients. The ideal candidate will have hands-on experience with Snowflake as the core data platform, along with strong proficiency in SQL for writing, diagnosing, and optimizing complex stored procedures. The role involves developing and tuning SQL-based logic and leveraging Python to perform advanced data processing, including the creation of custom KPIs and analytics workflows. The engineer will work with a variety of digital marketing datasets, including social media.

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 [email protected] 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/.

Skills and Requirements

Required Qualifications

• 8 years' experience in Data Engineering

• Proven experience with Snowflake as a primary data warehouse platform.

• Strong proficiency in SQL with the ability to write, diagnose, and optimize complex stored procedures.

• Hands-on experience with Python for data transformation and KPI development.

• Familiarity with Azure Data Services, especially Azure Data Factory.

• Experience working with digital marketing datasets, including social media, web analytics, and demand-side platforms.

• Understanding of digital advertising ecosystems, including campaign measurement and media performance metrics.

• Experience with API-based data ingestion and integration workflows.

• Background in working with digital agencies or creative firms is a strong plus. • Exposure to platforms such as Navigator or Media OS.

• Experience working in middleware or integration layers supporting multiple downstream products.

• Familiarity with text-based data outputs and documentation generation for client delivery.