CGI · 3 hours ago
Data Engineer
Indianapolis, IN
Full-time
Onsite
Mid Level
$63K/yr - $121K/yr
3+ years expCGI is a leading IT and business consulting services firm, and they are seeking a motivated Data Engineer to support the modernization of clients' insurance agency and policy admin data platforms. This role involves building scalable data pipelines, integrating key systems, and contributing to real-time analytics and predictive modeling while collaborating with cross-functional teams.
AnalyticsApplication Performance ManagementBusiness IntelligenceConsultingCyber SecurityFinanceInformation TechnologyTechnical Support
Responsibilities
Participate in the transition from legacy systems to modern cloud-based data platforms (e.g., AWS, Azure)
Migrate key insurance data (policy) from Applied Epic and Guidewire into unified data warehouses/lakes for advanced analytics
Architect Insurance Data Ecosystem
Design scalable data architectures that support future-state personal lines insurance workflows, omnichannel engagement, and predictive analytics
Integrate Applied Epic, Guidewire, and Salesforce FSC data for 360° customer and policyholder insights
Prepare structured datasets for actuarial modeling, underwriting automation, and customer segmentation using ML and AI tools
Collaborate with data scientists to deploy models into production environments and monitor model performance over time
Build real-time and event-driven data pipelines to support dynamic pricing, and customer notifications
Leverage tools like Kafka, AWS Kinesis, or Pub/Sub for real-time processing across policyholder journeys
Implement automated data cataloging, lineage tracking, and access controls aligned with NAIC, GDPR, and CCPA requirements
Use metadata management and data observability tools to ensure future scalability, trust, and transparency
Enable APIs and data layers to support partnerships and embedded insurance models
Collaborate with third-party Insurtech platforms, MGAs, and distribution partners through secure data integrations
Develop reusable, curated datasets and data marts that empower underwriters, and business analysts
Create training content and documentation to promote self-service data usage across business units
Integrate Salesforce FSC with internal insurance systems to deliver hyper-personalized customer communications and retention strategies
Build data layers that power cross-sell/up-sell recommendations and lifecycle marketing based on claims or policy behavior
Adopt agile methodologies for iterative data delivery and implement CI/CD pipelines for data deployments
Participate in automation in testing, monitoring, and documentation of data products and pipelines
Qualification
Required
3–5 years of professional experience as a Data Engineer, preferably in the insurance or financial services industry
Strong domain knowledge of Personal Lines Insurance (Auto, Homeowners, Renters, etc.), including policy lifecycle, Renewal, billing, and underwriting
Hands-on experience working with Applied Epic and Guidewire (Policy Center, Billing Center, or Claim Center)
Understanding Insurance data structures, workflows, and APIs specific to insurance operations and customer engagement
Proficient in SQL and one or more programming languages like Python, Scala, or Java for data transformation and scripting
Experience building ETL/ELT pipelines using tools such as dbt, Talend, Informatica, or custom frameworks
Working knowledge of cloud-based data platforms (e.g., AWS Glue/Redshift, Azure Data Factory/Synapse, GCP BigQuery)
Ability to design and implement insurance data models across policy, claims, customer, and finance domains
Experience with dimensional modeling, normalization/denormalization, and building data marts for reporting/analytics
Knowledge of data governance best practices including data quality, lineage, access control, and metadata management
Familiarity with regulatory and compliance frameworks (e.g., GDPR, CCPA, HIPAA, NAIC standards)
Experience enabling BI tools such as Power BI, Tableau, or Looker by delivering clean, high-quality data sets
Ability to collaborate with analytics and reporting teams to support KPIs and business insights
Strong communication skills to collaborate with business stakeholders, product owners, and cross-functional IT teams
Ability to work in agile development environments and participate in sprint planning, retrospectives, and stand-ups
Preferred
Familiarity with Salesforce Financial Services Cloud (FSC) or core Salesforce CRM data models (nice to have but preferred)
Exposure to streaming and event-driven architecture (e.g., Kafka, Kinesis, Spark Streaming) is a plus
Benefits
Competitive compensation
Comprehensive insurance options
Matching contributions through the 401(k) plan and the share purchase plan
Paid time off for vacation, holidays, and sick time
Paid parental leave
Learning opportunities and tuition assistance
Wellness and Well-being programs
Company
CGI
CGI is an IT and business consulting services firm that offers consulting, cyber security, cloud, and IT services.
10001+ employees
H1B Sponsorship
CGI has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (775)
2024 (762)
2023 (795)
2022 (940)
2021 (846)
2020 (582)
Funding
Current Stage
Public CompanyTotal Funding
$1.2B2025-03-12Post Ipo Debt· $650M
2024-09-03Post Ipo Debt· $550.87M
1998-10-06IPO
Leadership Team
François Boulanger
President and Chief Executive Officer at CGI
Raymond McMann
VP, Global Oil & Gas Industry
Recent News
2026-01-13
syncni.com
2026-01-09
Company data provided by crunchbase