Deputy Manager/Manager - Data Engineer

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