Senior Data Warehouse Developer

TEKsystems

United States

Hybrid

USD 69,000 - 76,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

TEKsystems seeks a Data Warehouse Developer to join our Data Management & Operations team in Rochester, NY. You will design, develop, maintain, and optimize enterprise data warehouse solutions and ETL pipelines that power analytics, reporting, and data initiatives across the organization.

The ideal candidate brings deep Microsoft SQL Server expertise and hands-on ETL development experience, with Informatica IDMC required; familiarity with Epic, Denodo, and MDM concepts is a plus.

Qualifications

  • Expert-level data warehousing and ETL development experience.
  • Proficient with Microsoft SQL Server.
  • Informatica IDMC is required; Epic/Denodo knowledge is a plus.

Responsibilities

  • Design, develop, maintain, and optimize enterprise data warehouse solutions.
  • Build and optimize ETL pipelines for analytics and reporting.
  • Mentor junior team members and troubleshoot complex technical issues.

Skills

SQL
Informatica IDMC
ETL development
Epic
Denodo

Job description

Description

Type: Contract-to-Hire (6-month contract with conversion opportunity)

Salary Upon Conversion: Approximately $100,000 - $105,000

Position Summary

Data Warehouse Developer to join our Data Management & Operations team. This individual will play a critical role in the design, development, maintenance, and optimization of enterprise data warehouse solutions and ETL pipelines that support analytics, reporting, and organizational data initiatives.

The ideal candidate will bring deep expertise in Microsoft SQL Server and modern ETL development practices, along with the ability to work independently, troubleshoot complex technical issues, and mentor junior team members. Experience with Informatica is required, while knowledge of Epic, Denodo, healthcare data environments, and Master Data Management (MDM) concepts is a plus.

This role is best suited for a hands-on technical professional who enjoys solving complex data integration challenges and building scalable data solutions.

Skills

Sql, Informatica IDMC, etl development, epic, Denodo

Top Skills Details

Sql,Informatica IDMC,etl development

Additional Skills & Qualifications

Experience with or certifications for Epic or Denodo are nice to have, but much easier for URMC to train than Informatica which is why that is required

Experience Level

Expert Level

Job Type & Location

This is a Contract to Hire position based out of Rochester, NY.

Pay and Benefits

The pay range for this position is $50.00 - $55.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your jobclassification and length of employment. Benefits are subject to change and may besubject to specific elections, plan, or program terms. If eligible, the benefitsavailable for this temporary role may include the following:Medical, dental & visionCritical Illness, Accident, and Hospital401(k) Retirement Plan Pre-tax and Roth post-tax contributions availableLife Insurance (Voluntary Life & AD&D for the employee and dependents)Short and long-term disabilityHealth Spending Account (HSA)Transportation benefitsEmployee Assistance ProgramTime Off/Leave (PTO, Vacation or Sick Leave)

Job Type & Location

This is a Contract to Hire position based out of Rochester, NY.

Application Deadline

This position is anticipated to close on Nov 13, 2026.

Workplace Type

This is a hybrid position in Rochester,NY.

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

Were 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. Were 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. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Warehouse Developer
Senior Data Warehouse Developer

TEKsystems • City of Rochester (NY)

Hybrid
USD 69,000 - 76,000
Medical, dental & vision
401(k) Retirement Plan
Short and long-term disability
+3
Enterprise Data Analytics Manager
Enterprise Data Analytics Manager

TEKsystems • City of Rochester (NY)

On-site
USD 41,000 - 59,000
Medical, dental & vision
401(k) Retirement Plan
Life Insurance
+4
Medical Billing Assistant
Medical Billing Assistant

TEKsystems • City of Rochester (NY)

On-site
USD 25,000 - 26,000
Medical, dental & vision
401(k) Retirement Plan
Paid time off
IT Service Desk Analyst 1
IT Service Desk Analyst 1

TEKsystems • City of Rochester (NY)

On-site
USD 25,000 - 28,000
Senior Data Analyst
Senior Data Analyst

TEKsystems • Charlotte (NC)

Hybrid
USD 90,000 - 103,000
Medical, dental & vision
401(k)
Life Insurance
Medical Biller
Medical Biller

TEKsystems • City of Rochester (NY)

On-site
USD 22,000 - 25,000
Medical, dental & vision
401(k) Retirement Plan
Life Insurance
Digital IT Analyst
Digital IT Analyst

TEKsystems • City of Syracuse (NY)

On-site
USD 34,000 - 41,000
Medical, dental & vision
401(k) Retirement Plan
Short and long-term disability
+2
Sr. Oracle Cloud DBA
Sr. Oracle Cloud DBA

TEKsystems • Minneapolis (MN)

Hybrid
USD 120,000 - 150,000
Healthcare benefits
6% 401k match
Phone stipend
+1
Sr. Oracle Cloud DBA
Sr. Oracle Cloud DBA

TEKsystems • United States

Hybrid
USD 120,000 - 150,000
excellent company healthcare and benefi
6% 401k match
phone and parking stipend
Senior Database Engineer
Senior Database Engineer

TEKsystems • United States

Remote
USD 103,000 - 117,000
Medical, dental & vision
401(k) Retirement Plan
Life Insurance