Data Engineer

Insight Global; Parsippany-Troy Hills (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

Insight Global in Parsippany, NJ seeks a seasoned Snowflake Data Engineer to build a centralized data hub for marketing analytics. You’ll transform diverse digital datasets into actionable insights for internal platforms and external clients, using Snowflake as the core data platform, with SQL and Python to write and optimize complex procedures, and Azure Data Factory for data movement.

The role emphasizes collaboration with digital marketing teams and agencies, delivering robust KPI workflows

Qualifications

• 8 years of data engineering experience.
• Proven Snowflake as primary data warehouse.
• Strong SQL to write, diagnose, and optimize procedures.
• Hands-on Python for data transformation and KPI development.
• Familiarity with Azure Data Services, especially Data Factory.
• Experience with digital marketing datasets and campaign metrics.

Responsibilities

• Develop a centralized data hub for marketing analytics.
• Transform diverse datasets into actionable insights for internal platforms and clients.
• Build and optimize KPI analytics workflows and data pipelines.
• Collaborate with digital marketing teams and agencies to deliver robust data solutions.

Skills

SQL proficiency

Python

Data modeling

KPI development

Tools

Snowflake

Azure Data Factory

APIs

Job description

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 [e-mail] 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.