Data Engineer

Randa Accessories•Rosemont, IL

74d•Hybrid

About The Position

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.

Requirements

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
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

Responsibilities

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.

Benefits

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