What are the responsibilities and job description for the Data Engineer position at Randa Corp?
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 innovationWe 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, ILSchedule: 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 architectureCollaborate 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 flowsHighly available architecture (Lambda, Python, S3 event management, Redshift (or other), Aurora (serverless/other), Redis ElastiCache1-3 years in a commercial-grade business applications environment, leveraging the following: SQL Server, T-SQL, SSIS, stored procedures, user-defined functions, and table functionsManaging design risk1-3 years leveraging OO programming techniques Software development lifecycles, Unit test techniques, debugging/analytical techniquesRequired Skills:MS SQL Server - T-SQLSQL Server Integration Services (SSIS)Adept at creating stored procedures, views, user-defined functions, table functionsPython, C#, JavaCloud Knowledge - AWS (Amazon Web Services) (GLUE, Redshift, Lambda, Kinesis)Reporting: Tableau, Power BIAnalysis: OLAPExcellent communication, verbal and writing skillsMinimal oversight requiredWhat 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“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.”
Salary : $90,000 - $105,000