• Ingestion Engineer (Intl Remote)

    Insight Global (Boston, MA)


    Job Description

    A global law firm with nearly 1,400 lawyers and more than 3,000 employees across 19 offices in the United States, Europe, and Asia is looking to build out a data lake to encompass both internal and external data. The role is a long-term contract and is remote. The firm is widely recognized for its expertise in corporate law, litigation, intellectual property, life sciences, technology, and venture capital, advising on transformative deals, IPOs, and complex regulatory matters. The firm has earned numerous workplace accolades, including being named to Fortune’s Best Companies to Work For and receiving honors such as Best Workplaces for Women, Best Workplaces for Flexibility, Best Workplaces for Giving Back, and Best Workplaces for Parents.

     

    The firm is looking to hire an Ingestion Engineer to join their team building this greenfield data lake. The engineer will be responsible for implementing and maintaining the ingestion pipelines that move data from source applications directly into the Bronze layer of the data lake (95% of time) or S3 bucket (5%). This is schema-led ingestion with no transformations in Bronze, ensuring data is auditable and traceable back to the source application. They are ingesting data from vendor applications directly into the bronze layer, so we they are not doing API integrations.

    Key Responsibilities

    Data Ingestion

     

    -Build and manage ingestion workflows from vendor applications into the Bronze data lake layer.

     

    -Ensure ingestion processes are reliable, auditable, and aligned with schema standards.

     

    Tool Expertise

     

    -Use Qlik Replicate for applications on SQL Server.

     

    -Use Fivetran for SaaS applications (API-based ingestion).

     

    Monitoring & Maintenance

     

    -Monitor ingestion jobs, troubleshoot issues, and ensure real-time change capture.

     

    -Maintain logs for auditability and compliance.

     

    Collaboration

     

    -Work under guidance from the Lead Data Engineer and coordinate with platform teams.

     

    Scalability

     

    -Support ingestion for ~75 known third-party applications and data sources.

    Compensation:

    $15/hr to $20/hr.

     

    Exact compensation may vary based on several factors, including location, skills, experience, and education.

     

    Employees in this role will enjoy a comprehensive benefits package starting on day one of employment, including options for medical, dental, and vision insurance. Eligibility to enroll in the 401(k) retirement plan begins after 90 days of employment. Additionally, employees in this role will have access to paid sick leave and other paid time off benefits as required under the applicable law of the worksite location.

     

    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 [email protected] 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/.

     

    Skills and Requirements

     

    - 3-5+ years of experience in data ingestion or ETL/ELT processes

     

    - Hands-on experience with Qlik Replicate and Fivetran or similar vendor led tool (Semarchy xDM, Realtio, Matillion, Hevo Data, Airbyte, etc)

    - Strong understanding of schema-led ingestion and data lake architectures

    - Familiarity with cloud storage (e.g., S3) and basic data governance principles - law firm background

     

    -Experience with change data capture (CDC) and log-based ingestion.

     

    -Knowledge of data cataloging and data quality tools.

     

    -Exposure to Lakehouse architectures and integration with downstream systems.