USNLX Virtual Jobs

USNLX Virtual Careers

Job Information

Reyes Holdings Remote ETL Developer/Architect - RBD in Rosemont, Illinois

Remote ETL Developer/Architect - RBD

  • Job ID #:51039

  • Position Type:Full Time

  • Location:Rosemont, IL

  • Shift:1st

  • Department:Information Technology and Technical Support

  • Education Required:Bachelors Degree

  • Experience Required:3 - 5 Years

Position Description:

Position Summary:

The ETL Architect is responsible for designing, developing, and supporting data ingestion and transformation solutions that will be utilized in reporting, analytics, or within other applications. The position will also perform data analysis, construct technical designs, communicate with team members and business stakeholders, and support existing data ingestion and transformation pipelines. This position will also coordinate and review the work activities of offshore development and support resources.

Position Responsibilities may include, but not limited to:

  • Responsible for the design, development, and support of data ingestion and transformation solutions.

  • Perform data analysis and create data models for peer review.

  • Provide guidance and direction to offshore support/development resources.

  • Communicate with other BI team members, offshore team members, and cross-IT staff on support and project activities.

  • Assist with task identification and effort estimates for ETL development.

  • Assist with risk and issue identification.

  • Provide off-hour/weekend support (on a rotating basis).

  • Other projects or duties as assigned.

Position Requirements:

Required Skills and Experience:

  • Bachelor’s Degree in Computer Science, Information Systems, or in a related discipline.

  • 4+ years of ETL development experience.

  • 2+ years of ETL design experience.

  • Design and development experience utilizing scheduling/automation tools preferably in the Azure environment.

  • Strong communication skills, including written and verbal communication skills.

  • Strong problem solving and analytical skills.

  • Strong ETL design skills.

  • Excellent ETL development skills utilizing an ETL tool, preferably utilizing Azure Data Factory.

  • Excellent SQL skills.

  • Strong understanding of Dimensional Modeling and other modeling techniques.

  • Strong understanding of SDLC best practices with an emphasis on DW/BI/Analytics practices.

  • This position must pass a post-offer background and drug test.

Preferred Skills and Experience:

  • Experience with orchestration in the Azure environment.

  • Snowflake data warehouse experience.

  • Azure DevOps experience.

  • GitHub experience.

  • MS Power BI experience.

  • Azure Blob Storage / ADLS experience with Data Storage, Analysis.

  • Data modeling experience.

  • Experience working with both structured and semi-structured data sources.

  • JavaScript and Python for stored procedures and scripting.

  • Experience leading offshore resources.

  • Microsoft Azure, Snowflake, and other relevant certifications.

Physical Demands and Work Environment :

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Due to the nature of our business in regard to such things as delivery schedules, order inputs, selection, and Department of Transportation Hours of Service, overtime, attendance and punctuality are essential job functions. Should an individual in this classification not be able to adhere to this requirement due to a disability, they should contact their Human Resources department to see what, if any, reasonable accommodation may be made.


As an Equal Opportunity Employer, Reyes Holdings companies will recruit and select applicants for employment solely on the basis of their qualifications. Our Practices and Procedures, including those relating to wages, benefits, transfers, promotions, terminations and self-development opportunities, will be administered without regard to race, color, religion, sex, sexual orientation and gender identity, age, national origin, disability, or protected veteran status and all other classes protected by the Federal and State Government. Drug Free Employer.