Levi, Ray & Shoup, Inc.

Careers

Added Mar 03, 2026 Data Warehouse Developer (45928) Madison, WI | Full-time Apply

For additional information on how we handle your data, see www.LRS.com/privacy

Benefits Link Button Image

What to do if you suspect fraud:

If you receive a suspicious offer or communication claiming to be from us, do not share any personal or financial information. You can notify us using our contact page at Contact Levi, Ray & Shoup, Inc.

IMPORTANT NOTES:

  • All legitimate correspondence from our recruiting team will only come from an email address ending in @lrs.com. We do not use generic domains like @gmail.com, @yahoo.com, or @outlook.com.
  • We never conduct interviews solely via text-based chat on Microsoft Teams, Telegram, or WhatsApp. All virtual interviews involve a scheduled video or phone call with a member of our team.
  • LRS will never ask a candidate for payment, fees, or to purchase equipment (e.g., laptops, software) as a condition of employment.
  • All genuine job opportunities are listed directly on our official careers portal at Careers.

Job Description

Codeworks, an LRS company, is seeking a Data Warehouse Developer for a Contract opportunity. This role offers the chance to apply your data integration and warehousing expertise in support of meaningful work for one of our client partners.

The Data Warehouse Developer III will design, develop, test, and implement ETL solutions using Informatica Intelligent Data Management Cloud (IDMC). This role supports scalable, secure data pipelines, metadata management, data quality, and continuous optimization within a data warehouse environment. The individual will work closely with business stakeholders and IT teams to translate requirements into well‑architected data integration solutions following enterprise best practices.

This role typically requires 4+ years of experience, including 3+ years of hands‑on IDMC work.

Primary Responsibilities

Data Integration & ETL Development

  • Develop and maintain ETL solutions using Informatica IDMC, including Taskflows, Mappings, parameterization, and reusable transformations.
  • Build secure, optimized data pipelines and ensure data accuracy, integrity, and consistency across environments.
  • Support migrations, including PowerCenter → IDMC modernization efforts.
  • Perform performance tuning for ETL workflows, SQL queries, and database operations.

Collaboration & Requirements

  • Work with business and technical teams to understand requirements and translate them into detailed ETL mapping and design specifications.
  • Ensure alignment with enterprise data warehousing standards, security requirements, and privacy regulations.
  • Participate in meetings, provide updates, and support solution planning and refinement.

Testing & Quality Assurance

  • Develop test plans, test cases, test procedures, and document results.
  • Identify defects and partner with teams to troubleshoot and resolve issues.
  • Support SDLC activities including system testing, integration testing, and validation.

Documentation & Operational Support

  • Maintain clear and accurate documentation for processes, mappings, and workflows.
  • Assist with troubleshooting ETL failures and performance bottlenecks.
  • Support metadata management, data repository updates, and continuous improvement efforts.

Required Skills & Experience- Approx. 4+ years, or equivalent experience

  • Experience designing, developing, and optimizing data warehousing solutions using Informatica IDMC.
  • Moderate to advanced knowledge of data warehousing concepts and data integration methodologies.
  • Strong SQL skills and experience with Oracle, DB2, or SQL Server.
  • Experience with Control‑M or similar job‑scheduling/automation tools.
  • Experience working with relational and dimensional data models.
  • Experience with slowly changing dimensions and common data warehousing patterns.
  • Ability to diagnose and resolve ETL and query performance issues.
  • Strong communication skills, including facilitating discussions with technical and business users.
  • Knowledge of SDLC processes and project methodologies (planning, analysis, design, testing, implementation, support).
  • Ability to collaborate effectively in large, cross‑functional organizations.
  • Strong organizational, analytical, and time‑management skills.
  • Ability to work independently while providing timely updates to leadership.
  • Proficiency with MS Office, Visio, Outlook, and Jira.
The base range for this contract position is $35.00 - $45.00 per hour, depending on experience. The range displayed reflects the minimum and maximum target for new hires of this position across all U.S. locations. Individual pay is determined by work location and additional job-related factors.

Codeworks, an LRS company, is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship, status or protected veteran status.

In some cases, Codeworks, an LRS company, uses generative artificial intelligence (“AI”) in support of our hiring processes. Codeworks takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out. Please contact AI.Questions@lrs.com with any questions.

 



What to do if you suspect fraud:

If you receive a suspicious offer or communication claiming to be from us, do not share any personal or financial information. You can notify us using our contact page at Contact Levi, Ray & Shoup, Inc.

IMPORTANT NOTES:

  • All legitimate correspondence from our recruiting team will only come from an email address ending in @lrs.com. We do not use generic domains like @gmail.com, @yahoo.com, or @outlook.com.
  • We never conduct interviews solely via text-based chat on Microsoft Teams, Telegram, or WhatsApp. All virtual interviews involve a scheduled video or phone call with a member of our team.
  • LRS will never ask a candidate for payment, fees, or to purchase equipment (e.g., laptops, software) as a condition of employment.
  • All genuine job opportunities are listed directly on our official careers portal at Careers.