Quantiphi - Senior Data Engineer - ETL / Python

Role : Senior Data Engineer.

Experience Level : 4 to 7 Years.

Work location : Mumbai, Bangalore, Trivandrum (Hybrid).

Role & Responsibilities :

• Work with business users and other stakeholders to understand business processes.
• Ability to design and implement Dimensional and Fact tables.
• Identify and implement data transformation / cleansing requirements.
• Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse.
• Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions.
• Design, develop and maintain ETL workflows and mappings using the appropriate data load technique.
• Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.
• Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.
• Analyze and resolve problems and provides technical assistance as necessary.
• Partner with the BI team to evaluate, design, and develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.
• Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.
• Leverage transactional information, and data from ERP, CRM, and HRIS applications to model, extract and transform into reporting & analytics.
• Define and document the use of BI through user experience / use cases, prototypes, tests, and deploy BI solutions.
• Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, and quality issues, and continuously validate reports, and dashboards and suggest improvements.
• Train business end-users, IT analysts, and developers.

Required Skills :

(ref : hirist.tech)