Who Can Apply
- Candidates must be legally authorized to work in Canada
Job Description
Insight Global is supporting a client in the retail / interconnected commerce and analytics space seeking a Senior Data Engineer for a 6 month contract engagement. This role is a backfill supporting a key stakeholder group focused on building and scaling ETL pipelines that power analytics and business decision making.
You will sit closely with business partners while working hand in hand with technology teams, contributing to both business as usual operations and new data initiatives. The environment emphasizes data quality, scalability, and practical, real world analytics.
The client operates primarily on a GCP-based stack, though candidates with strong Python, SQL, and data modeling experience from AWS or Azure environments are also encouraged to apply.
Day to Day Responsibilities
Business as Usual (BAU) Support
• Monitor and support existing ETL pipelines and data jobs
• Investigate and resolve job failures, data quality issues, or unmet thresholds
• Identify upstream data issues and collaborate with technology teams to remediate gaps
• Ensure data accuracy, availability, and performance across datasets
Enhancements & Optimizations
• Add new transformations, logic, and data attributes to existing pipelines
• Improve data models and warehouse structures to support analytics use cases
• Optimize SQL queries and ETL workflows for performance and scalability
New Projects & Pipeline Development
• Build new data pipelines and transformations from scratch
• Gather and clarify business requirements by working directly with stakeholders
• Translate business needs into technical solutions and validated data outputs
• Partner with IT teams to confirm data availability, submitting and tracking Jira requests when needed
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
• 3–5+ years of experience in data engineering or a closely related role
• Strong hands on experience with Python and advanced SQL
• Experience designing and supporting ETL pipelines and data transformations
• Solid data modeling experience (dimensional modeling; Snowflake, BigQuery, or similar)
• Proven ability to analyze data flows and validate where data originates, moves, and is consumed
• Experience working with cloud-based data platforms (GCP preferred; AWS or Azure acceptable)
• Comfortable operating on the business side while collaborating with technical teams
• Strong communication skills for requirements gathering and stakeholder interaction
• Ability to work fully remote while supporting EST hours
Candidates with slightly less experience may still be considered if they demonstrate strong technical depth and hands-on capability.
Nice to Have Skills & Experience
• Experience with Google BigQuery, GBQ stored procedures, or GCP-native data tools
• Familiarity with Snowflake and modern cloud data warehouses
• Experience supporting analytics, marketing, or customer data use cases
• Exposure to large-scale retail, clickstream, or customer experience datasets
• Prior experience in agile development environments using Jira
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.