Technical Business Analyst Internship

Posted Yesterday
Be an Early Applicant
Hartford, CT, USA
In-Office
25-25 Hourly
Internship
Insurance
The Role
Technical Business Analyst Intern will analyze and document data flows across Talcott’s annuity business applications. Responsibilities include tracing financial transactions from source systems to Finance and Actuarial feeds, writing SQL and Python queries, reconciling data, documenting lineage and mappings, translating business events into technical requirements, and recommending improvements to data quality and controls. The role collaborates with Software Engineering, Business Analysis, Finance, and Actuarial teams in a hybrid Hartford environment.
Summary Generated by Built In

Talcott Financial Group* is an international life insurance company committed to providing comprehensive risk solutions to its customers. Whether it’s providing peace of mind for policyholders approaching retirement, or helping insurers solve complex risk and capital challenges, Talcott delivers practical solutions that support long-term stability for policyholders and clients.
Talcott offers the strength of an established organization with the mindset and approach of a modern platform. The enterprise is supported by a proven track record of well-executed transactions, investment-grade financial strength ratings, and strong financial position, with over $136 billion in assets under management. Talcott also benefits from a strategic partnership with Sixth Street, a leading global investment firm managing over $135 billion in assets.

Talcott’s approach to business is disciplined, transparent, and multi-channel, spanning retail annuities, block and flow reinsurance, and legal entity acquisitions. We have offices in Bermuda, the Cayman Islands, Connecticut, New York, and North Carolina.

Talcott's Summer Internship Program gives students a dynamic, rewarding opportunity to take on real business challenges. Over this fast-paced ten-week program, students work side by side with our industry professionals. The internship is hybrid, with onsite work at our contemporary Hartford, Connecticut campus on Tuesday, Wednesday and Thursday. Interns take on business assignments that build their technical expertise, business knowledge and leadership skills. Beyond hands-on learning, the program offers a full calendar of enrichment activities and frequent social events where interns meet members of our leadership team and colleagues across many disciplines.

 

Talcott is seeking a Technical Business Analyst Intern to join our Information Technology department. The intern will learn how data moves across Talcott's retail annuity platform. This role sits where annuity operations, finance and data meet. The goal is to tie that data to the downstream enterprise feeds that support Finance and Actuarial. The ideal candidate is curious about both the business and the data behind it. They will see the flow of a financial business event, such as a premium deposit, withdrawal, surrender, annuitization or commission payment, from the source system all the way to the general ledger and actuarial reporting. The intern will work closely with Software Engineers, Business Analysts, and Finance and Actuarial partners. This internship will work onsite in Hartford. CT. office on a hybrid work arrangement.

 

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

 

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

Compensation:

 

This range represents the minimum and maximum annual base salary we reasonably expect to pay for this role at the time of posting. The actual base pay could vary and may be above or below the listed range. The base pay is based on factors including but not limited to experience, competence, and demonstration of proficiencies essential for the role. The base pay is just one component of Talcott’s total annual compensation for employees. Other compensation may include annual bonuses, long-term incentives and recognition.

 

*This role is not eligible for visa sponsorship. Applicants must be authorized to work in the United States on a full-time basis without current or future visa sponsorship.

 

**Talcott Financial Group is an equal employment employer. All qualified applicants will receive consideration without regard to race, color, sex, religion, age, national origin, disability, veteran status, sexual orientation, gender identity or expression, marital status, ancestry or citizenship status, genetic information, pregnancy status or any other characteristic protected by law. Talcott Resolution maintains a drug-free workplace. For more information regarding our Privacy Policy, please go to https://talcott.com/onlineprivacypolicy/onlineprivacypolicy.html

Skills Required

  • Currently pursuing a Bachelor's degree in Information Systems, Data Analytics, Computer Science, or a related field
  • Working knowledge of SQL
  • Eagerness to learn Python, Microsoft Fabric, Power BI, and Azure data tools
  • Strong analytical mindset and attention to detail
  • Ability to connect data patterns to business outcomes
  • Ability to explain technical findings in business terms
  • Excellent written and verbal communication skills
  • Ability to work effectively on a team and independently
  • Interest in insurance, annuities, or financial services
  • Previous internship experience
  • Drive for continuous learning and growth
  • Strong work ethic and willingness to meet business deliverables
  • Ability to work autonomously while managing competing priorities
  • Authorization to work in the United States without current or future visa sponsorship
  • Ability to work onsite in Hartford, Connecticut, Tuesday through Thursday under a hybrid arrangement
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Windsor, CT
313 Employees
Year Founded: 2018

What We Do

As an international life insurance group, Talcott Financial Group creatively designs and expertly delivers responsive solutions that meet our clients’ strategic needs. Our experienced team and the breadth of our capabilities enable us to operate with speed, clarity, and reliability, solving even the most complex business objectives.

Similar Jobs

Pfizer Logo Pfizer

Director, QSEO AI Transformation Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Remote or Hybrid
8 Locations
121990 Employees
177K-294K Annually

Pfizer Logo Pfizer

Vice President, Integrated Medicines Business - East

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
In-Office or Remote
2 Locations
121990 Employees
300K-500K Annually

DraftKings Logo DraftKings

Lifecycle Associate

Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Remote or Hybrid
United States
6400 Employees
54K-68K Annually

DraftKings Logo DraftKings

Associate, Market Operations

Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Remote or Hybrid
United States
6400 Employees
62K-77K Annually

Similar Companies Hiring

MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account