Position: Lead Data Engineer
Company: ITernal Group
Experience required: 5y
English level: upper

UST Global® is looking for a highly-skilled, experienced Lead Data Engineer.

**Responsibilities:**
• Top level expert in one or more highly specialized areas of applications systems analysis and programming.
• Leads the solution delivery and implementation for programs and projects
• Interfaces with product owners and key stakeholders
• Works and implements an agile/scrum & DevOps processes, continuous integration and automated testing frameworks.
• Troubleshoot and resolve performance issues in the, server components, DB components.
• Works with Product Team to ensure user stories that are developer-ready, easy to understand, and testable.
• Writes custom code or scripts to do "destructive testing" to ensure adequate resiliency in production.
• Adheres to maintenance plans/timelines, project plans/timelines, support plan summaries and production requirements documents.
• Participates and leads in learning activities around modern software design and development core practices (communities of practice).
• Keep abreast of the current technologies and technological trends. Ability to learn and prototype new technologies, and recommend their appropriate use within the Company products.
• Reviews and discusses code from more senior engineers to understand best practices and design patterns.
• Increases business acumen by learning about other parts of the business.
• May be responsible for providing technical leadership in multiple phases of a project, ensuring coordination of assignments to IT resource management and escalating key decision points that deviate from the provided technical direction.
• Participates in design and review of technical design for development staff.
• Utilizes agile project management tools and concepts to ensure projects are delivered on time and on budget.
• Maintain knowledge of development methods, best practices and standards. Work closely with IT Security for to ensure all systems (internally hosted, cloud-based, etc.) follow industry standards and policies for safe-guarding data and access.

**Requirements:**
• Extensive knowledge and understanding of computer systems architecture and design, computer industry trends and project management.
• Need to have Experience in product support.
• Design, Development and Testing of Data extraction, transformation, and loading (ETL) processes from source to target system using Informatica / SSIS.
• Experience working with tools such as SSMS, TOAD, PL/SQL developer
• Should have knowledge in SSRS concepts
• Knowledge in various tuning operations to improve performance.
• Prepare HLD and LLD Documents
• Good knowledge in data extraction/ manipulation using SQL.
• Experience in performance tuning of SQL Queries and its functionalities.
• Datawarehouse domain experience (design and modelling to meet needs of complex global reporting solutions).
• Strong knowledge in ETL concepts
• Experience working within an agile framework like Scrum based development organization.
• Thorough knowledge of departmental procedures processes and work flows.
• Knowledge of standard languages, coding methods, company coding standards and quality requirements.
• Excellent oral and written communication skills required.
• Demonstrated abilities to successfully document and communicate software platform designs to all levels of staff (technical and non-technical).
• Ability to work constructively with other technical experts in a group setting.
• Knowledge of object-oriented development languages and web-related technologies.
• Ability to comprehend the consequences of various problem situations and address them, or refer them for appropriate decision making.
• Ability to effectively exchange information clearly and concisely, and present ideas, reports facts and other information, and respond to questions as appropriate.
• Demonstrated leadership abilities.
• Ability to make competent, independent decisions.
• Ability to manage technical services and software vendors.
• Ability and proficiency in the use of project management tools and techniques.
• Ability to maintain confidentiality.
• Ability to perform other assignments at locations outside the office.

**We offer:**
• Possibility to influence the development of the project
• Friendly professional staff and warm atmosphere
• The environment where you can implement your ideas
• Flexible schedule and opportunities to work remotely (8 hours workday)
• Paid vacation and sick leaves
• Participation in educational activities and thematic conferences
• Team parties and corporate events