• Hybrid Senior Data Engineer

    Insight Global (Hartford, CT)


    Job Description

    Modernize legacy data assets by migrating and re-engineering them into modern cloud solutions (AWS, GCP, Snowflake) for scalability, security, and cost efficiency.

     

    Design, develop, and optimize ETL/ELT pipelines for structured and unstructured data, ensuring resilience and high performance.

     

    Build and manage data pipelines leveraging cloud services such as AWS Glue, EMR, Redshift; GCP BigQuery, Dataflow; and Snowflake.

     

    Curate and publish Data Products to support analytics, visualization, machine learning, and Generative AI use cases.

     

    Implement DataOps practices for automated deployments, CI/CD integration, and continuous delivery of data solutions.

     

    Integrate AI/ML models into data pipelines, enabling real-time scoring, feature engineering, and model retraining workflows.

     

    Enable Generative AI capabilities by embedding LLMs into data workflows for intelligent automation and advanced insights.

     

    Develop and deploy AI Agents for automated decision-making and conversational analytics.

     

    Lead Proof of Concepts (POCs) and pilot initiatives for emerging technologies—beyond GenAI—such as real-time streaming, AI agents, and next-gen data platforms.

     

    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

     

    7+ years of experience in data analysis, transformation, and development, with ideally 2+ years in the insurance or a related industry.

     

    5+ years of strong proficiency in SQL, Python, and ETL tools such as Informatica IDMC for data integration and transformation.

     

    3+ years of experience developing and deploying large-scale data and analytics applications on cloud platforms such as AWS, GCP and Snowflake.

     

    Experience in small or medium-scale Generative AI (GenAI) integration within data workflows or enterprise solutions.

     

    3+ years of expertise in designing and optimizing data models for Data Warehouses, Data Marts, and Data Fabric, including dimensional modeling, semantic layers, metadata management, and integration for scalable, governed, and high-performance analytics. 3+ years of experience in Agile methodologies, including Scrum and Kanban frameworks.

     

    Knowledge of data observability (metrics, tracing, logs) and monitoring frameworks.

     

    Exposure to metadata management (catalogs, glossary) and data lineage tools.

     

    Familiarity with containerization & orchestration (Docker, Kubernetes).