Data Engineer

Location

Rosemont, IL

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

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.

• Develop solutions and contribute to development, leveraging Object-Oriented programming techniques (.Net), Software Development Life cycles, 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.

• 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 lasti
    
    Cache)
• 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 life cycles, Unit test techniques, debugging/analytical techniques

• 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

• 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

“The statements in this job description are intended to describe the general nature and level of work being performed by people assigned to this work. This is not an exhaustive list of all duties and responsibilities. Randa management reserves the right to amend and change responsibilities to meet business and organizational needs as necessary.”