Data-Driven Tech Business Analyst Intern - Hybrid (Hartford)

Talcott Financial Group; Coltville (CT); Hybrid; USD 25,000 - 36,000; Full time

Job summary

Talcott Financial Group in Hartford, CT seeks a Technical Business Analyst Intern for our Information Technology department. The role blends business analysis with data movement across our retail annuity platform, from source systems to general ledger and actuarial reporting, in a hybrid, on-site environment.

The intern will collaborate with Software Engineers, Business Analysts, and Finance/Actuarial teams to document data lineage, map business events to requirements, and help improve data

Qualifications

• Student pursuing a Bachelor's degree in Information Systems, Data Analytics, Computer Science or a related field
• Working knowledge of SQL and an eagerness to learn Python, MS Fabric, Power BI and Azure data tools
• Strong analytical mindset and attention to detail, with the ability to connect data patterns to business outcomes
• Interest in insurance, annuities or financial services is a plus
• Ability to explain technical findings in business terms
• Excellent written and verbal communication skills
• Team-oriented with the ability to work independently
• Previous internship experience is preferred
• Drive for continuous learning and growth
• Strong work ethic and willingness to "do what it takes" to meet business deliverables
• Ability to work autonomously while managing competing priorities

Responsibilities

• Leverage SQL, Python, Azure and MS Fabric to analyze, validate and document data flows for Talcott's Business Applications portfolio.
• Analyze data to understand how business transactions are captured, transformed and stored
• Trace financial business events end to end, from source systems to downstream Finance (general ledger, sub-ledger) and Actuarial feeds, and identify gaps, breaks and reconciliation issues
• Translate financial business events into Finance requirements, data mapping documents and technical specifications
• Write SQL queries and use Python, Azure and MS Fabric to profile and reconcile data across systems
• Document data lineage, field-level mappings and business rules that connect operational data to enterprise reporting
• Recommend improvements to data quality, controls and process efficiency

Skills

SQL

Python

MS Fabric

Power BI

Azure data tools

Education

Bachelor's degree in Information Systems, Data Analytics, Computer Science or a related field

Job description

Talcott Financial Group in Hartford, CT seeks a Technical Business Analyst Intern for our Information Technology department. The role blends business analysis with data movement across our retail annuity platform, from source systems to general ledger and actuarial reporting, in a hybrid, on-site environment.

The intern will collaborate with Software Engineers, Business Analysts, and Finance/Actuarial teams to document data lineage, map business events to requirements, and help improve data