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