Job Description
Overview:
Insight Global is seeking a Data Engineer to support the migration from WhereScape to Coalesce and build scalable, production‑grade data pipelines on Snowflake. This role is deeply technical and focused on ELT development, refactoring legacy workflows, and modernizing the data platform.
Responsibilities:
• Build, refactor, and optimize Snowflake ELT pipelines using Coalesce.
• Translate existing WhereScape jobs into Coalesce components, ensuring logic parity and improved maintainability.
• Develop efficient, reusable Python scripts for automation, data processing, and orchestration.
• Implement scalable data models, transformations, and performance‑optimized SQL.
• Partner with architects and data engineers to align pipelines with new platform standards.
• Support testing, validation, documentation, and productionizing of migrated pipelines.
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/.
Required Skills & Experience
• 4+ years of hands‑on experience as a Data Engineer.
• 3+ years of experience with Snowflake (SQL, modeling, performance tuning).
• Experience developing objects in Snowpark (snowflake framework)
• 1+ years of Hands‑on experience with Coalesce (or other metadata‑driven ELT tools).
• Strong Python development experience (automation, transformations, pandas, NumPy).
• Background working on platform migrations or modernization projects.
• Orchestration tool experience like airflow or astronomer or similar tools
• On call support on rotation
Nice to Have Skills & Experience
• Experience with cloud platforms and cloud-based data technologies
• Experience with Databricks, big query, and/or redshift
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.