Remote Data Engineer (GCP, Bigquery, SSIS)

Data Engineer

We are seeking a Data Engineer to lead a critical initiative focused on migrating a government reporting application that requires heavy data transfers using SSIS from on-prem to GCP cloud. In this role, you will design and implement robust ETL pipelines leveraging SSIS and cloud technologies to ensure accurate, secure, and scalable data processing for regulatory reporting. The position involves developing and optimizing complex data workflows, integrating data from multiple sources, and ensuring compliance with government standards. You will collaborate closely with cross-functional teams to migrate and transform data efficiently, while documenting SQL logic to support the reporting data layer. The ideal candidate will have deep expertise in SSIS, strong experience creating ETL pipelines in cloud environments such as GCP, and advanced SQL skills for analysis and optimization. Familiarity with government reporting requirements and performance tuning for large-scale data operations is essential. Experience with BigQuery or similar cloud data warehouses and knowledge of AI-driven automation tools for ETL processes are highly desirable. This is an opportunity to contribute to a strategic modernization effort that enhances scalability, reliability, and compliance for a leading healthcare insurance client.

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.

Skills and Requirements:

• 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
• Strong experience with SSIS and creating ETL pipelines