Data Analyst II

Lead Data Analyst - Onsite 5x Daily - Raleigh, NC
Position Details

• Job Type: Contract-to-Hire
• Duration: 6 months until perm
• Location: Raleigh, NC | On-site required during contract | Hybrid (3 days onsite) after conversion
• Experience Level: Expert
• Compensation/Benefits: 45.00 - 52/hr + Pension Plan upon conversion

We are seeking a technical contributor and team leader within its corporate data and reporting function. This role plays a critical part in supporting enterprise reporting, BI initiatives, and data governance as executive demand for analytics and Tableau visualizations continues to grow. This is a lead-level data role with hands-on responsibility for ETL development, reporting, database design, and data migration, while also providing day-to-day leadership for a small team of analysts.

What You'll Do
As a Data Analyst II, you'll design, build, and maintain SSIS-based ETL pipelines, optimize SQL for reporting and BI dashboards, and support enterprise reporting solutions using SSRS, Tableau, and Power BI. You'll lead data initiatives including data mapping, migration, and database design, ensuring data accuracy, consistency, and performance. You'll support the full lifecycle of data projects, from requirements gathering and technical design through development, testing, and deployment, working within an Agile/Scrum environment using Azure DevOps. You'll also contribute to data governance efforts by helping build and maintain a data catalog that supports data quality and usability across the organization. This role includes technical leadership responsibilities, with oversight of a small team of 2-5 people depending on project needs. You'll collaborate closely with business stakeholders, including non-technical leaders, to translate analytics and reporting needs into scalable technical solutions-particularly as Tableau usage expands at the executive level. You will report to the Data Administration Supervisor, but you are expected to operate with a high degree of autonomy and ownership.

What We're Looking For
We're looking for a technically strong, experienced data professional who can lead projects and people while staying hands-on.
Required experience includes:

• Strong SQL expertise for querying, performance tuning, and reporting
• Hands-on experience building SSIS ETL pipelines
• Experience with SSRS reporting
• Strong Tableau visualization experience
• Experience leading large-scale data migration efforts
• Proven performance across the full data project lifecycle, from requirements through delivery

Additional qualifications:

• Prior experience leading or mentoring small data teams (2-5 people)
• Comfortable interfacing with business and executive stakeholders
• Experience working in Agile/Scrum environments using Azure DevOps
• Strong problem-solving, communication, and analytical skills
• Exposure to database design and modeling concepts (PowerDesigner experience is a plus but not required)

Work Environment & Benefits
This role is fully on-site in Raleigh, NC during the six-month contract period. Upon conversion to a full-time employee, the team follows a hybrid model (3 days on-site per week). Long-term stability and is one of the few organizations that still offers a pension plan to full-time employees. The organization has a strong track record of employee retention and has historically not conducted layoffs.
Interview Process

1. IKM technical assessment
2. A virtual one-hour interview with the Data Administration Supervisor, focused on deep technical discussion
3. A final on-site interview with the data team

Job Type & Location
This is a Contract to Hire position based out of Raleigh, NC.
Pay and Benefits
The pay range for this position is $45.00 - $52.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)
Workplace Type
This is a fully onsite position in Raleigh,NC.
Application Deadline
This position is anticipated to close on Jan 30, 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.