Remote Data Engineer (GCP, BigQuery, Teradata)

We are looking for a Data Engineer to join a high-impact cloud migration project for a leading healthcare insurance client. This role will be instrumental in transitioning a complex data ecosystem from Teradata to Google Cloud Platform (GCP), with a focus on BigQuery. The environment includes thousands of legacy SQL statements written in Teradata that must be carefully analyzed, translated, and optimized for migration to GCP using BigQuery. The ideal candidate will not only have deep technical expertise in SQL and cloud data platforms but also a forward-thinking mindset to explore and implement AI-powered tools that can accelerate and automate parts of the migration process. This is a unique opportunity to contribute to a strategic modernization effort that will improve scalability, performance, and long-term data agility for the client. There is another effort happening in tandem where this team is reverse engineering one of the existing reports that is going to be rebuild in another application owned by a different team. This Data Engineer may be involved in writing SQL documentation to build the data layer of this report as it migrates. 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 - 5+ years of experience as a Data Engineer - Hands-on experience with GCP data services, including BigQuery and related tools - Strong expertise with SQL ability to write complex queries - Previous experience with Teradata - Familiarity with AI/ML tools or platforms that support code translation, refactoring, or performance tuning such as Copilot or Cursor AI - Excellent analytical and problem-solving skills, with a focus on data accuracy, performance, and integrity Benefit packages for this role will start on the 31st 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. Apply tot his job Apply To this Job