Infor

We are looking for a Data Analyst to develop MS-SQL queries and procedures, Visual Basic Application Developers. The Data Analyst will create custom reports, maintain, customize, and build queries to generate the reports. Must have the ability to demonstrate initiative to lead projects with minimal direction and lead other staff as vital.

Job Description: Below are some of the responsibilities an SQL developer or programmer is expected to assume in their position

• Create / modify SQL queries, including joining and cross-referencing cells from several tables
• Troubleshooting and problem-solving using JavaScript or Selenium or other programming languages
• Develop, modify and implement business logic within stored procedures
• Build appropriate and useful reporting deliverables with the help of database analytical tools to analyse performance and generate reports
• Crafting the RPA project using SQL, VB, VBA, Alteryx platform
• Analyse existing SQL queries for performance improvements
• Develop procedures and scripts for data migration
• Identifying issues and proposing improvement
• Review and interpret ongoing business report requirements
• Research required data
• Suggest new queries

• Required Qualifications and Skill Sets:
• Desired:
• Degree in computer science with work experience ranging between 1 to 3 years
• Proficient in database procedures, Microsoft SQL Server concepts and data management
• Exposure to Macro, MS Excel, scripting, SQL VB & VBA Programming
• Good understanding of DB structure, Queries builder, Form Designing and Report Designing in MS Access
• Team player
• Critical thinker and problem-solving skills
• Self-Starter with Sense of ownership
• Effective Time Management
• Excellent Communication Skills
• Optional & as an added advantage:
• Exposure to standard database management tools and software (i.e., MS Access, Oracle Database, phpMyAdmin etc)
• Hands-on Experience in Alteryx, RPA (Automation Anywhere, UI Path etc)