Deputy Manager/Manager - Data Engineer

Key Skills

AWS, Business Intelligence, Data Modeling, Data Visualization, Data Warehousing, ETL/ELT technologies, MySQL, Oracle, PowerBI, Python Programming, RDBMS, Scrum Agile Methodology, Snowflake, SQL, SQL Server

Job Description

Role:

Data Engineering & Quality Management: Design, implementation, and management of data platform, data pipelines to help fulfill data access and aggregation functionality for users in cloud environment.

Responsibility:

• Key responsibility is to design and develop data warehouse and BI platform including the architecture, prototyping and development of data extract, transformation, cleansing and integration of structured and unstructured data
• Transform raw data into useful information and insights utilizing Analytics, Business Intelligence (BI) and visualization tools
• Provide technical expertise to design efficient solutions to consolidate data from other data systems (Oracle/MySQL/PostgreSQL/SQL Server/object storage etc), Enterprise Applications and 3rd party API
• Develop optimal design of data warehouse environments, analyzing complex distributed data deployments and making recommendations to optimize performance
• Design and develop database and application interfaces between various internal and external systems to efficiently and effective capture and integrate data
• Organize, optimize and debug data-driven reporting, BI and analytics applications
• Document & maintain data dictionary for data from various sources to enable data democratization - Work with business stakeholders to support their data needs and technical teams to replicate from their data sources.

Competency Requirement:

Technical/Functional:

• Hands-on experience with data architecture, design and development of data warehousing solutions
• Programming experience using Python - Extensive technicalexperience with SQL on RDBMS (Oracle/MySQL/PostgreSQL) and Data warehouse schema definitions (Snowflake), data modeling, security and design
• Strong analytical skills with ability to synthesize data to design and deliver meaningful solutions
• Experience implementing Reporting, BI, Visualization and Analytics tools such Power BI / AWS QuickSight / Cognos
• Good level of knowledge of database performance and tuning, troubleshooting and query optimization and tuning
• Good knowledge next generation ETL/ELT tools and data consolidation frameworks that enable capabilities within the data ecosystem.
• Ability to work independently or within a team, proactively, in a fast-paced AGILE-SCRUM environment.

Educational Qualification:

• B.E / B. Tech in Computer Science/IT