Senior Data Engineer

Job Description:

• 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
• Demonstrates mastery of a wide application of professional principles, theories and concepts. Troubleshoots and provides solutions for unusually complex problems.
• Solutions are imaginative, thorough and practicable. Contributes to the development of new and innovative solutions.
• Demonstrates self-reliance by (on occasion) working without appreciable direction toward long-range goals and objectives.
• Determines and pursues courses of action necessary to obtain desired results.
• Contributes to the productivity of the organization through the completion of projects associated with departmental objectives.
• Impact of decisions can be broad depending on the number of projects affected and may impact departmental resources, timeframes and budgets.
• May be a primary point of contact with vendors and consultants engaged in supporting the work activities of the group.
• Communicates formally and informally to management and fellow team members.
• Owns communication between RCA client service delivery teams and analysts. Owns performance and quality of applications and data for client support systems.
• Influences design and development of new software products or major enhancements to existing software for clients and business partners.

Required Knowledge, Skills, and Abilities

• Experience developing and/or maintaining applications in Microsoft Access and VBA Advanced SQL Server skills – SQL Query Development and Performance Tuning (DBA Experience also helpful)
• Extensive experience with relational databases RDBMS (Microsoft, Oracle, MySQL, PostgreSQL)
• Experience with scripting languages (VBScript, PowerShell) preferred
• Experience working with ETL processes
• Retail analytics support or direct retail experience is preferred
• Skilled in Agile and SCRUM development methodologies (Kanban)
• Excellent communication skills
• Experience in project management is a plus

Education + Experience

• BS / MS / Equivalent Training / Certification and 3+ years of relevant experience

Job Description:

Hands-on technical role to support our audit team through client data conversion and the support, development, and delivery of audit tools and reports. Ideal candidate combines experience with Microsoft Access application development VBA, Project management, Comfort with very large datasets (preferably SQL server) and business understanding to mine data and automate workflows focused on identifying anomalies and errors in our client’s business transactions.

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 Collaborate with business process owners to identify opportunities; define business requirements, design solutions to map to and in support of new or existing business processes and / or workflows.

Rapidly implement technical solutions designed to maximize operational efficiency and productivity. Perform Data validation to ensure accuracy and quality of data Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards. 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 and management, Corporate Functions

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
• Knowledge is extended to the development of solutions for a business area. Contributes to cross- departmental strategy and solutions. May lead teams
• Demonstrates mastery of a wide application of professional principles, theories and concepts. Troubleshoots and provides solutions for unusually complex problems.
• Solutions are imaginative, thorough and practicable. Contributes to the development of new and innovative solutions.
• Demonstrates self-reliance by (on occasion) working without appreciable direction toward long-range goals and objectives. Assignments may be self-initiated and agreed upon with management.
• Determines and pursues courses of action necessary to obtain desired results.
• Contributes to the productivity of the organization through the completion of projects associated with departmental objectives.
• Impact of decisions can be broad depending on the number of projects affected and may impact departmental resources, timeframes and budgets.
• May be a primary point of contact with 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 RCA client service delivery teams and analysts. Owns performance and quality of applications and data for client support systems.
• Influences design and development of new software products or major enhancements to existing software for clients and business partners.

Required Knowledge, Skills, and Abilities

• Experience developing and/or maintaining applications in Microsoft Access and VBA Advanced SQL Server skills – SQL Query Development and Performance Tuning (DBA Experience also helpful)
• Extensive experience with relational databases RDBMS (Microsoft, Oracle, MySQL, PostgreSQL)
• Experience with scripting languages (VBScript, PowerShell) preferred
• Experience working with ETL processes
• Retail analytics support or direct retail experience is preferred
• Skilled in Agile and SCRUM development methodologies (Kanban)
• Excellent communication skills
• Mentors and coaches problem solving and troubleshooting
• Experience in project management is a plus

Education + Experience

• BS / MS / Equivalent Training / Certification and 5+ years of relevant experience

Job Description:

•  Manage high transactional MySQL databases servicing OLTP and DSS applications 
• Monitor and tune SQLs and databases performance 
•  System deployment, maintenance, upgrade, and patching management 
•  Manage mission critical database replication environments 
•  Provide supports to the Service Engineers to solve customers' issues 
•  Enforce architectural governance, deployment standards and best practices  Act in incident management to resolve active incidents 
•  Work on projects, tickets, deployments, and releasesPerform any other duties as assigned by  management from time to time 

Required Knowledge, Skills, and Abilities

• Strong proficiency in MySQL database management, performance tuning and troubleshooting  Experience with MySQL internal architecture, demonstrated experience with MySQL  
•  database design, implementation, performance tuning, and capacity planning.  Hands on experience with MySQL replication, Aurora MySQL, and MySQL backup and  recovery strategies 
• Hands on experience in monitoring and performance tuning of problem SQLs and databases  Experience in database HA strategies and implementations 
• Good scripting ability and working experience of Shell scripting or Python 
• Experience in designing and automating repetitive processes 
• Amazon cloud services such as Aurora MySQL, DynamoDB, Ec2 instance, S3, OpenSearch  Service, and CloudWatch is added advantage 
• Experience managing MongoDB and DynamoDB 
• Experience in operational support in multiple situations (escalated or major incident) 
• Have creative ability, credibility and independence 

Education + Experience

• Minimum 5 years of experience in MySQL 5.7 or above Database Administration

Job Description:

At Leapfrog, our mission is to be a role model technology company. We want to be trusted partners, world-class engineers, and creative innovators for our clients. We have built awesome software products across various verticals and take pride in our craftsmanship which has produced greater results in the software industry and the overall ecosystem.
As a Senior Data Engineer, you will closely work with to build data processing, data warehousing infrastructure, and data visualization systems. You will be part of a learning culture where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.

• Follow software development best practices and industry standards to deliver a robust system.
• Write analytical queries based on business requirements.
• Design database schema based on the product requirements.
• Optimize database query. Maintained ETL workflows and SQL scripts for data transformation and analysis.
• Engage and participate in all stages of the Software Development life cycle process: Planning, design, development, testing, and deployment.
• Prepare flow diagram and technical documentation.
• Work and collaborate independently or in a team.

Required Knowledge, Skills, and Abilities

• Well-versed and experienced with at least one of the programming languages (Preferred: Python, JavaScript, etc).
• Strong knowledge of OLTP and OLAP database design, best practices, and database architecture with experience in Data Warehouse design and data analysis.
• Must have hands-on experience in ETL, data transformation, functions, stored procedures, triggers, etc.
• Strong computing foundation and fundamentals.
• End to end understanding of software components and architectural layers - frontend, backend, REST APIs, OLTP, OLAP databases, etc.
• Strong analytical and problem-solving skills and well-versed with fundamental programming concepts and/or data structures and algorithms.
• Familiarity with Linux systems and the command-line interface.
• Proficient working knowledge of GIT and GIT based development workflows.
• Willingness to learn, contribute, lead, and grow with us.

Preferable Skills:

• Knowledge of Power BI, Tableau, and any other visualization tools.
• Experience with database administration.
• Working knowledge of Docker, containers, and cloud-native infrastructure.
• Familiarity with ETL automation tools like Apache Airflow, Pentaho DI, SSIS, etc.
• Familiarity with cloud services and platforms like AWS.
• Good command in spoken and written communication (in English) .

Education + Experience

• At least 4 -5 years of experience in software development using relational databases & SQL (PL/SQL, T-SQL is preferred).

Job Description:

• Create, Administer, Monitor, and Maintain multiple AWS Aurora-Postgres database
• Create, Administer ,Monitor and Maintain Oracle database.
• Good Knowledge of Cursor and Store Procedure
• Work on new and existing logical/physical database designs for applications and infrastructure.  
• Implement relational databases, tables, and table changes.  
• Support application development for problem solving and performance tuning.  
• Plan and implement disaster recovery processes.  
• Be willing to be on-call and occasionally work odd hours to help meet customer service level agreements and to support application and database deployments. 

Required Knowledge, Skills, and Abilities

• Familiarity with relational databases (PostgreSQL a plus).  
• Knowledge of SQL Command Syntax, Data Definition Syntax, and Query Syntax.  
• Familiarity with data modeling concepts.  
• Ability to develop queries to extract information based on compounded search criteria.  
• Clear understanding of Data Structures.  
• Experience with variety of Amazon Web Services is a plus  

Education + Experience

• 1+ years of proven experience in software development, data base maintenance, and system maintenance.  
• 1+ years of experience with relational databases
• Recent graduates are also welcome to apply. 

Job Description:

• Create Reports, Layouts and Validations using HANA SQL Complex Queries (Create Procedures, Functions and So on..)
• Work on Queries for fetching data as per requirement and also validate data with system.
• Work on data set and perform different task to debug errors in system and reports.
• Create procedures and connect with Crystal Report and design Layouts and Reports on CR.
• Other task like Create Validations for system, Generate alert, Build Dashboards or Graphs, Create Customize Authorizations, Auto Updation etc.. 

Required Knowledge, Skills, and Abilities

• Proven work experience as a Database developer
• In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
• Hands-on experience with SQL, DDL, DML, DCL 
• Joining writing store procedure and views 
• Excellent analytical and organizational skills
• An ability to understand front-end users' requirements and a problem-solving attitude 

Education + Experience

• Bachelor’s degree in Computer Science, Engineering or a related subject
• 2+ years full-time work experience HANA 

Job Description:

Are you looking for the next step in your career, where you can drive your personal and professional development and ambitions forward? 
We are a leading, multinational company with many years of experience in our industry, and are excited to announce that we are looking for an experienced Data Engineer to join our team. 

Job description…

We are looking for a high-potential, enthusiastic SQL Data Engineer with a strong desire to build a career in data analysis, database design and application solutions. Reporting directly to our UK-based Technology team, you will provide support to our global operation in the delivery of data analysis, conversion, and application development to our core audit functions.
Duties will include assisting with data loads, using T-SQL to analyze data, front-end code changes, data housekeeping, data administration, and supporting the Data Services team as a whole.  Your contribution will grow in line with your experience and skills, becoming increasingly involved in the core service functions and client delivery.  A self-starter with a deep commitment to the highest standards of quality and customer service. We are offering a fantastic career opportunity, working for a leading international financial services organization, serving the world’s largest organizations.

Required Knowledge, Skills, and Abilities

• 1-2 years of previous experience in a similar role
• Data analysis and conversion skills using Microsoft SQL Server is essential
• An understanding of relational database design and build
• Schema design, normalising data, indexing, query performance analysis
• Ability to analyse complex data to identify patterns and detect anomalies
• Assisting with ETL design and implementation projects
• Knowledge or experience in one or more of the key technologies below would be preferable:
• Microsoft SQL Server (SQL Server Management Studio, Stored Procedure writing etc)  T-SQL
• Programming languages (C#, VB, Python etc)
• Use of Python to manipulate and import data
• Front end application design in Microsoft Access with advanced VBA
• SSRS report design
• Experience of ETL/automation advantageous but not essential (SSIS/Prefect/Azure)
• A self-starter who can drive projects with minimal guidance
• Meeting stakeholders to agree system requirements
• Someone who is enthusiastic and eager to learn 
• Very good command of English and excellent communication skills

Education + Experience

• 1-2 years of previous experience in a similar role