Levi, Ray & Shoup, Inc.

Careers

Added May 12, 2026 Data Warehouse Developer (46120) Remote, Remote | 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 skills in support of meaningful work for one of our client partners.

This role is responsible for designing, developing, testing, and implementing ETL solutions using Informatica IDMC. Key responsibilities include developing scalable, secure, and efficient data pipelines using Data Integration (DI), taskflows, mappings, parameter files, and reusable transformations. The role also supports metadata management, maintains data quality and integrity, and contributes to continuous improvement within the IDMC and data warehouse environment.

  • Knowledge of data warehouse best practice standards
  • Experience supporting PowerCenter to Informatica IDMC migrations
  • Experience designing, developing, and testing solutions using Informatica IDMC
  • Proficiency in writing, reviewing, and analyzing complex SQL queries across Oracle, DB2, and SQL Server environments
  • Hands-on experience using Control-M for job scheduling and workflow automation
  • Experience working with relational and dimensional data models
  • Experience working with slowly changing dimensions (SCDs)
  • Ability to identify, analyze, and address ETL and database query performance issues
  • Effective verbal and written communication skills, including experience facilitating discussions with both technical and business stakeholders
  • Knowledge of the project development life cycle, including planning, analysis, design, development, testing, implementation, and support
  • Experience gathering, documenting, and validating business and technical requirements
  • Demonstrated ability to collaborate effectively and contribute as part of a team
  • Experience working within large or complex organizations to support project outcomes
  • Ability to manage and contribute to short‑ and long‑term projects
  • Strong organizational and time management skills
  • Strong analytical and problem‑solving abilities
  • Ability to work independently while communicating progress, challenges, and support needs appropriately
  • Proficiency with Microsoft Office (including Outlook and Visio) and Jira
The base range for this contract position is $38.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.