Software Engineer - SQL Developer - SQL | ETL | VBA

Software Engineer (COE Retail - India)

Hands-on technical role to support US, India and Canada based engineering and audit teams through client data conversion and the development, delivery and support of audit tools, audit data and reports. Ideal candidate combines experience with Microsoft Access application development (VBA), project management, handling of very large datasets (preferably SQL server) and business understanding to mine data and automate workflows focused on identifying anomalies and errors in our clients business transactions whilst possessing excellent written and verbal communication skills.

Essential Functions:

Perform complex data mining, forensic analysis, and aggregation; commingle multiple datasets to develop a streamlined, efficient representation of transaction lifecycles. Data mining for advanced analysis of data; presented in reports and/or interactive auditing tools.

Rapidly implement technical solutions designed to maximize operational efficiency and productivity. Perform Data validation to ensure accuracy, completeness, and quality of data. Perform large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards. Perform full life cycle project ownership from analysis to development to delivery of audit solutions. Contribute to documentation initiatives as needed. Contribute to group knowledge and best practices. Interacts with Auditors and other end users, other analysts, management, and corporate departments.

Key Responsibilities:

• Strong analytical/problem solving skills, Strong communication skills, ability to translate end user needs into an IT solution, Excellent organizational skills and attention to detail is critical to the success of all candidates
• Ability to recognize inefficiencies in processes (operational or technical) and the ability to design solutions to address these issues. Mastery working with large datasets
• Solutions are imaginative, thorough, and practicable. Contributes to the development of new and innovative solution
• Demonstrates self-reliance by (on occasion) working without appreciable direction towards long-range goals and objectives. Assignments may be self-initiated and agreed upon with management
• Contributes to the productivity of the organization through the completion of projects associated with departmental objectives
• May be a primary point of contact with other engineers, vendors and consultants engaged in supporting the work activities of the group
• Communicates formally and informally to management. May also conduct briefings and participate in meetings with internal and external partners or collaborators
• Owns communication between client service delivery teams and analysts
• Owns performance and quality of applications and data for client support systems

Requirements:

• BTech / MCA / Equivalent Training / Certification and 5+ years of relevant experience
• Experience developing and/or maintaining applications in Advanced SQL Server skills SQL Query Development and Performance Tuning (DBA Experience also helpful). Any programming experience (especially Microsoft VB / VBA) would be an added advantage
• Extensive experience with relational databases RDBMS (Microsoft, Oracle, MySQL, PostgreSQL)
• Experience with scripting languages (VBScript, PowerShell) preferred
• Experience working with ETL processes
• Any .Net C#, Java & VB.Net Web &/or Windows Development would be an advantage
• Excellent verbal and written communication skills
• Skilled in Agile and SCRUM development methodologies (Kanban)
• Lives problem solving and troubleshooting
• Comfort in working with team members that are remote and located in the US, India, or other geographies
• Experience working across multiple clients on multiple projects simultaneously
• Stakeholder Management - collaborates, takes ownership & accountability
• Ability to work within a matrix organization
• Strong organizational skills and adaptive capacity for rapidly changing priorities and workloads
• Experience in project management is a plus