Senior Data Warehouse Developer

TEKsystems

City of Rochester (NY)

Hybrid

USD 69,000 - 76,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, dental & vision
401(k) Retirement Plan
Short and long-term disability
Health Spending Account (HSA)
Time Off/Leave
Employee Assistance Program

Job summary

TEKsystems in Rochester, NY is seeking a Data Warehouse Developer on a contract-to-hire basis. The role focuses on design, development, maintenance, and optimization of enterprise data warehouse solutions and ETL pipelines that support analytics and reporting.

The ideal candidate has deep SQL Server expertise and hands-on ETL development experience with Informatica IDMC. Epic and Denodo knowledge are a plus; Healthcare data environments and MDM concepts are advantageous.

Qualifications

  • Deep expertise in Microsoft SQL Server and modern ETL development practices.
  • Experience with Informatica is required; knowledge of Epic or Denodo is a plus.
  • Certifications for Epic or Denodo are nice to have, but Informatica is required.

Responsibilities

  • Design, develop, maintain, and optimize enterprise data warehouse solutions and ETL pipelines.
  • Troubleshoot complex technical issues and mentor junior team members.
  • Work independently to deliver scalable data integration solutions.

Skills

SQL
Informatica IDMC
ETL development
Epic
Denodo

Tools

Informatica IDMC
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 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)

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.

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.

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 • United States

Hybrid
USD 69,000 - 76,000
Sr Data Warehouse Developer
Sr Data Warehouse Developer

University of Rochester • City of Rochester (NY)

On-site
USD 86,482 - 129,723
Senior Data Warehouse Architect & ETL Lead
Senior Data Warehouse Architect & ETL Lead

University of Rochester • City of Rochester (NY)

On-site
USD 86,482 - 129,723
Sr Data Warehouse Developer
Sr Data Warehouse Developer

University of Rochester • San Antonio (TX)

On-site
USD 87,000 - 130,000
Sr Data Analyst
Sr Data Analyst

Randstad USA • Eden Prairie (MN)

Remote
USD 34,000 - 48,000
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
Senior Data Engineer
Senior Data Engineer

Optum • Raleigh (NC)

Hybrid
USD 92,000 - 164,000
Benefits package
Equity stock purchase
401k contributions
Senior Data Engineer
Senior Data Engineer

The Hanover Insurance Group • Worcester (MA)

Remote
USD 105,000 - 130,000
Data Warehouse Engineer
Data Warehouse Engineer

Codeworks, Inc. • Madison (WI)

Hybrid
USD 48,216 - 61,992
HRIS Specialist
HRIS Specialist

Talentify • City of Glens Falls (NY)

On-site
USD 41,000 - 53,000
Medical benefits
Dental & vision
401(k) plan
+5