Data Engineer

Software Guidance & Assistance, Inc. (SGA, Inc.); Hartford (CT); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Software Guidance & Assistance, Inc. (SGA, Inc.) is seeking a Data Engineer for a Right to Hire opportunity in Hartford, CT. This role involves building and maintaining data assets while collaborating closely with technical teams to facilitate business solutions.

Candidates should have experience with database technologies, strong ETL process knowledge, and proficiency in at least one scripting language. The position also includes a hybrid work schedule, requiring onsite presence three days a week. Passion for data and problem-solving skills are essential.

Qualifications

• Experience with database technologies is required.
• Understanding of ETL processes and data movement concepts is necessary.
• Familiarity with at least one scripting language is a must.
• Strong troubleshooting, analytical, and problem-solving skills are essential.
• Excellent written and verbal communication skills are required.
• Proven ability to work effectively in collaborative environments.
• Passion for working with data and driving data-driven decisions is desired.
• Exposure to GenAI concepts is a plus.
• Understanding of object-oriented design principles is preferred.

Responsibilities

• Build and maintain data assets and scalable data pipelines.
• Gather requirements from technical teams and business stakeholders.
• Design, develop, automate, and support enterprise ETL processes.
• Create logical and physical database models.
• Modify and enhance existing databases.
• Troubleshoot issues and implement necessary fixes.
• Collaborate within an agile team to deliver solutions.

Skills

Database technologies

ETL processes

Scripting language

Troubleshooting

Analytical skills

Problem-solving

Communication skills

Collaborative environments

Data-driven decisions

GenAI concepts

Education

Bachelor’s degree

Job description

Software Guidance & Assistance, Inc. (SGA) is seeking a Data Engineer for a Right to Hire opportunity with one of our premier Insurance clients in Hartford, CT.

We're looking for a hands‑on Data Engineer to join a high‑performing team focused on delivering meaningful business value through custom data and software solutions. This individual will work closely with both technology and investment professionals in a fast‑paced agile environment, helping solve real‑world business problems through modern data engineering practices.

This is a great opportunity for someone who enjoys understanding business challenges, building creative solutions, and working on highly visible, business‑critical systems.

What You’ll Be Doing:

• Build and maintain data assets and scalable data pipelines aligned with modern software development principles for analytical consumption
• Partner with technical teams and business stakeholders to gather requirements and define best practices around data storage, transformation, and usage
• Design, develop, automate, and support enterprise ETL processes
• Create logical and physical database models and database descriptions
• Modify and enhance existing databases and data management systems
• Troubleshoot issues, test databases/programs, and implement necessary fixes and improvements
• Work collaboratively within an agile team environment to deliver high‑quality solutions

What We’re Looking For:

• Experience working with database technologies
• Strong understanding of ETL processes and data movement concepts
• Experience with at least one scripting language
• Strong troubleshooting, analytical, and problem‑solving skills
• Strong written and verbal communication skills
• Proven ability to work effectively in collaborative environments
• Passion for working with data and helping drive data‑driven business decisions
• Exposure to or knowledge of GenAI concepts is a plus
• Understanding of object‑oriented design principles is preferred

Additional Details:

• Hybrid schedule with onsite expectations in Hartford, CT three days per week (Tuesday through Thursday)
• Bachelor’s degree required

SGA is a technology and resource solutions provider driven to stand out. We are a women‑owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let’s work better together, we mean it. You’ll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work.

Please find us at https://sgainc.com/.

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.