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