NEW JOB OPENING
DATA WAREHOUSE ENGINEER
IN Chicago, IL, USA!

 

Date Posted: 04/23/2024
Hiring Organization: Rose International
Position Number: 462817
Job Title: Data Warehouse Engineer
Job Location: Chicago, IL, USA, 60604
Work Model: Hybrid
Shift: 8:30 am-5 pm CST; 3 days per week onsite
Employment Type: Temporary
Estimated Duration (In months): 13
Min Hourly Rate($): 60.00
Max Hourly Rate($): 70.00
Must Have Skills/Attributes: Banking/Financial, Data Mapping, Data Modeling, Data Warehouse, ETL, PL*SQL, Risk Management, SQL

 

Job Description

  • **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

  • **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

This position will work closely with projects and follow-on risk application development participating in full project life cycle. The candidate would have the opportunity to be involved in the design and development of many aspects of the Corporate Risk Data Warehouse utilizing Oracle SQL and pl/SQL, data warehouse / ETL tools and Unix Scripts. In addition to design and development, this candidate is expected to be a lead technical resource for this division helping to set standards and practices for production support and maintenance of technical disciplines such as these that are new to this department. Ideally this candidate will also have previous well-rounded experience with business application development as well as a recent solid concentration on data warehouses, ETL processing and business intelligence tools. The data warehouse ETL processes will interface with numerous clients'' corporate transaction systems to gather information for the warehouse.

Qualifications:
• Experienced both in the specific business domain and the software engineering domain. These candidates are not only technology intensive but also possess experience of the specific business area.
• Have worked on similar projects and have a proven history of delivering high impact business solutions in the specific business area. Responsible for the technical vision, high-level architecture, design, and implementation of complex systems and applications.
• Ability to interact and communicate effectively with senior level business teams to ensure optimal results.
• Aside from the business specific knowledge, the individuals will also possess a complete understanding and mastery of the enterprise software development lifecycle.

1. Tasks & Responsibilities:
• Specifically, this candidate should be able to perform in the following activities:
• Strong in SQL and Data warehouse concepts – Hands on experience working in a Datawarehouse environment
• Write complex SQLs to analyze/profile datasets and identify patterns
• Recommend solutions based on data analysis
• Demonstrate strong analytical and problem-solving skills and be quick to identify design related concerns

2. Provide Data Requirements
• Collaborate with Subject Matter experts and Business partners in gathering data requirements
• Work independently and demonstrate strong understanding of existing Data model and ETL processes
• Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping
• Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline
• Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.
• Demonstrate strong negotiation skills while working with developers and architects to solve data needs.

3. Validate the accuracy, integrity and quality of Data developed

4. Support defects triage
• Participate in the SIT, UAT defects triage and help set up a defect resolution path
• Assess defects on their impacts and help set up priorities

5. Guide the production support team on unforeseen issues, ETL abends

 

Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).

 

Apply Now

Send me a reminder to complete this application

 

About Rose

  • Founded in 1993
  • Office Locations Across the U.S.
  • 150+ Clients: Corporations and Government Agencies
  • Employee Oriented Company
  • Challenging Assignments Across the U.S.
  • Continuous Professional Development

Any time I did have a question and called, the phone was always answered, and my question/concern was immediately resolved.

Sally, Consultant

You are customer service oriented. No matter whether it was the Recruiter or someone in Human Resources/Payroll, you were responsive. That to me is key!

Tonya, Consultant

I believe the best thing that Rose HR has going for it is the incredible responsiveness. Everyone is very quick to reply to any concerns, and contacts the contracted employees very quickly and efficiently.

Kevin, Consultant

I had a very positive experience working for Rose. The entire process is very efficient and easy.

Joanne, Consultant

Rose International maintained good communication during assignments and are very informative through email and phone calls.

Sade, Consultant

EMPLOYEE COMMENTS

  • We want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.