Data Engineer

Position- Data Engineer

Location-Mumbai

Total Experience 4+ years

Domain/Vertical Insurance and / or Finance (preferred)

Qualifications Educational MSc/MCS/BE/B.Sc : Computer Science / Maths / IT

Certifications Data Engineering / Analytics / Databases etc.

Experience

3-5 years of experience in a similar role

Experience into PowerBI is mandatory

Experience with Databases (Postgres, SQL Server, Oracle, MySQL)

Experience with cloud software (AWS - primary, Azure or Google - secondary but

acceptable).

Data Engineering/Warehousing experience (current)

SQL advanced coding Experience

KEY ACCOUNTABILITIES / KRAS / KPIS:

ETL: Develop and maintain the ETL processes:

Identify, analyse, design and maintain the data sources and pipelines.

Do necessary checks to ensure that the tables loaded balances back to the operational system in terms of control totals and record counts as per Audit requirements.

Develop and maintain procedures and standards for processes e.g. (Extraction and loading of data, Coding and naming standards, Scheduling of data related scripts and jobs, Develop Change control standards)

Database maintenance:

Identifying potential improvements to the design of the database and warehouses and ETL processes.

Maintain security and access to the database.

Monitor the database and tables space usage.

Archive historical data and delete unused tables.

DB performance monitoring and performance.

Data Statistics and Reporting.

Effective Project Delivery:

Participate in Metropolitan Health projects: e.g:

Migration

Upgrades

New system developments and projects.

Internal and external auditing if required.

Effective project delivery - Delivery of projects on time within the agreed budgets.

Ensure Continuous Service Improvement (CSI).

Achieving Operational Excellence.

Innovation:

Promote new techniques and Data tools that shape the future of the Data in the business, i.e. Unstructured data, Data Lakes, Apache Hadoop/ Spark/Hive/Kafka.

Objectives:

Team Relationship management - Engaging and partnering with other IT and Business teams.

Ensuring effective service delivery to our Business Partners.

Manage own performance and development.

Learn, grow, and enjoy contributing to a platform and team which aims at growing the business and solving complex problems.

Technical Mandatory Skills:

3-5+ years experience in a similar role.

Experience into PowerBI is mandatory

Experience with Databases (Postgres, SQL Server, Oracle, MySQL)

Experience with cloud software (Amazon Web Services - primary, Azure or Google - secondary but acceptable).

Data Engineering/Warehousing experience (current).

Engagement with internal stakeholders with regards to setting up controls (processes and standards).

SQL advanced coding.

Preferred Skills:

Python or Java coding (advantageous)

Database administration (advantageous).

Basic Linux shell scripting (advantageous).

Understanding of data.

Bigger picture and attention to detail orientation.

Ability to present information best aligned to business needs.

Analytical skills, problem solving.

Initiative, take responsibility for challenges, persistence (come up with solutions).

Flexibility with regards to thinking (different perspectives).

Interested candidates kindly write to me

Shraddha Sharma

[Confidential Information]

6354277612