Data Engineer

Randa Apparel & Accessories is one of the world’s leading fashion clothing and accessories companies, operating across 11 countries with a portfolio of 30 iconic brands, including Haggar, Levi’s, Tommy Hilfiger, Calvin Klein, Totes, Isotoner, and Columbia Sportswear. With over 100 years of industry leadership, RAA continues to produce exceptional products and services, delighting customers and empowering partners worldwide. From the #1 dress pant brand in North America to the #1 belt and wallet, RAA sets the standard for excellence and innovation

We empower our associates, create growth opportunities at every level, and strive to make RAA the best place to build a career. 

Want to work at a diverse, equitable, & inclusive workspace where associates are encouraged to bring their true, authentic selves?  

Apply today and fashion your future with RAA.

Location: Rosemont, IL

Schedule: Hybrid (3 days in-office / 2 days remote)

Position Summary:

The Data Engineer contributes to the design, development, and management of Randa Apparel & Accessories' large-scale database systems while supporting the strategic architectural vision of quality, scalability, performance, and function. 

Essential Job Functions:

• Develop solutions and contribute to development, leveraging Object-Oriented programming techniques (.Net), Software Development Lifecycles, Unit Test Techniques, and Debugging/Analytical Techniques.
• Design and develop data integration solutions with on-prem to cloud and vice versa architecture
• Collaborate with the team to develop database structures that fit into the overall architecture of the systems under development.
• Code, install, optimize, and debug database queries and stored procedures using appropriate tools and editors.
• Perform code reviews and provide feedback in a timely manner. 
• Promote collective code ownership for everyone to have visibility into the feature codebase.
• Present technical ideas and concepts in business-friendly language.
• Provide recommendations, analysis, and evaluation of systems improvements, optimization, development, and maintenance efforts, including capacity planning.
• Identify and correct performance bottlenecks related to SQL code.
• Support timely production releases and adherence to release activities.
• Contribute to the data retention strategy.

Minimum Qualifications:

• 1-3 years of proven hands-on AWS development experience in the realm of:
  • Data processing with near real-time flows
  • Highly available architecture (Lambda, Python, S3 event management, Redshift (or other), Aurora (serverless/other), Redis\ElastiCache
• 1-3 years in a commercial-grade business applications environment, leveraging the following: 
  • SQL Server, T-SQL, SSIS, stored procedures, user-defined functions, and table functions
  • Managing design risk
• 1-3 years leveraging OO programming techniques 
  • Software development lifecycles, Unit test techniques, debugging/analytical techniques

Required Skills:

• MS SQL Server - T-SQL
• SQL Server Integration Services (SSIS)
• Adept at creating stored procedures, views, user-defined functions, table functions
• Python, C#, Java
• Cloud Knowledge - AWS (Amazon Web Services) (GLUE, Redshift, Lambda, Kinesis)
• Reporting: Tableau, Power BI
• Analysis: OLAP
• Excellent communication, verbal and writing skills
• Minimal oversight required

What we Offer: 

• Competitive base salary.
• Hybrid work schedule.
• Three weeks of paid time off within the first year of employment.
• Company provided life insurance, short-term disability, long-term disability, and paid parental leave. 
• Health, vision, and dental insurance options with low employee contributions.  
• Commuter benefit plan.  
• Optional supplemental life insurance, pet insurance, and accident & critical illness insurance offered at a group discount rate. 
• 401(k). 
• Unlimited access to our award-winning online fitness, and wellness program.
• A great place to work, fast-paced, with terrific career growth