"Alerted.org

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 activity (such as Twitter, LinkedIn, and Doximity), web interactions (clicks, banners), and third-party data sources like Amazon and Hulu. Experience in digital domains—particularly within digital agencies or creative firms—is highly valued. The position requires familiarity with Azure Data Factory and related Azure services for orchestrating data workflows. The data engineer will support API-based ingestion into Snowflake and manage file-based data outputs that feed into internal platforms or are delivered to clients for campaign measurement and performance analysis.

This role focuses on the middleware integration layer, not on building ingestion pipelines, but rather on performing complex KPI calculations and data transformations within Snowflake using Python. The successful candidate will have experience extracting, transforming, and aggregating data from multiple file formats to uncover key performance indicators. Familiarity with platforms such as Navigator or Media OS is a plus, as is experience supporting measurement campaigns and delivering data to clients in structured formats.

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

- 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. - 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.