Senior Data Engineer

Description

Need for a data engineer/analyst to assist with a significant policy administration system and accounting system conversion. The role requires strong SQL skills for data cleanup, normalization, and migration to a new relational system, with a preference for an on-site candidate with 8-10+ years of experience. The project is expected to last 12-24 months, with a two-stage interview process and a potential start date in four to six weeks.

Key points

1. Client: A life insurance company in Beechwood with a small team, managing significant assets, and currently using a 26-year-old policy administration system that needs replacement.

2. Role Purpose: They are seeking a Data Analyst/Engineer to clean up their "hot mess" legacy database, normalize data, identify errors and duplicates, and prepare for conversion to a new policy administration system (PAS).

3. Key Responsibilities: The person will be crucial for data conversion between the new PAS vendor and data, including source-to-target mapping, and will identify data cleanup tasks for staff.

4. Required Skills: The ideal candidate needs to be a SQL expert (querying, stored procedures, some development), possess strong data analysis skills, and have excellent communication. Life insurance experience is a "nice to have.".

5. Technical Environment: The current system is Microsoft SQL, but very old, with the original application written in VB and some VB.NET. They also have a lot of data in Microsoft Access that needs to be dismantled and converted.

6. Experience Level: They require a sr level individual with 8-10+ years of experience, someone who can work independently without extensive hand-holding.

7. Work Arrangement: The position is primarily five days a week on-site in Beechwood (8 AM - 4:30 PM, with Friday flexibility), with some occasional remote work possible once trust is established.

8. Project Scope: The role is expected to be a long-term contract (12-24 months) due to the extensive data cleanup, conversion, and future work on dismantling Access programs and a new accounting system.

9. Interview Process: The interview process will involve a two-stage approach: an initial screening via Teams, followed by an in-person interview, potentially with a panel.

10. Hiring Timeline: Aiming to make a decision within two to three weeks of receiving resumes.

Skills

Data, Sql, Data Analysis, SQL Server, SQL Development, SQL Query, Access Database, Excel, Stored Procedures, Crystal Reports, Data modeling, Life Insurance, Data warehouse

Top Skills Details

Data,Sql,Data Analysis,SQL Server,SQL Development,SQL Query,Access Database,Excel,Stored Procedures

Additional Skills & Qualifications

Excellent Communication

Experience Level

Expert Level

This is a Contract position based out of Beachwood, OH.

The pay range for this position is $60.00 - $75.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

This is a fully onsite position in Beachwood,OH.

This position is anticipated to close on Jul 18, 2026.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.