Lead Assistant Manager - Azure Data Engineer

Mployee.me; Dadri; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Mployee.me is seeking a data integration specialist in India to design, develop, test, and deploy ETL and data workflow solutions using SSIS, ADF, Databricks, Matillion, Airflow, and Sqoop. The role emphasizes collaboration with business users to derive data models and ensure scalable data architectures.

You will produce documentation, perform data analysis, and may lead a project with multiple consultants while staying current with the latest data integration technologies and best practices.

Responsibilities

• Design, develop, test, and deploy data integration processes (batch or real-time).
• Create functional & technical documentation – e.g. ETL architecture documentation, unit testing plans and results, data integration specifications, data testing plans.
• Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models.
• Perform data analysis to validate data models and to confirm ability to meet business needs.
• May serve as project or DI lead, overseeing multiple consultants from various competencies.
• Stays current with emerging and changing technologies to best recommend and implement beneficial technologies.
• Ensures proper execution/creation of methodology, training, templates, resource plans and engagement review processes.
• Coach team members to ensure understanding on projects and tasks, providing effective feedback and promoting growth opportunities.
• Coordinate with project manager, client business staff, client technical staff and project developers in data architecture best practices.
• Architect, design, develop and set direction for enterprise self-service analytic solutions, BI reports, visualizations and best practice standards.
• Toolsets include but not limited to: SQL Server Analysis and Reporting Services, Microsoft Power BI, Tableau and Qlik.
• Work with report team to identify, design and implement a reporting user experience that is consistent and intuitive across environments.

Tools

SSIS

Azure Data Factory

Databricks

Matillion

Airflow

Sqoop

Job description

• Design, develop, test, and deploy data integration processes (batch or real-time) using tools such as Microsoft SSIS, Azure Data Factory, Databricks, Matillion, Airflow, Sqoop, etc.
• Create functional & technical documentation – e.g. ETL architecture documentation, unit testing plans and results, data integration specifications, data testing plans, etc.
• Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.
• Perform data analysis to validate data models and to confirm ability to meet business needs.
• May serve as project or DI lead, overseeing multiple consultants from various competencies.
• Stays current with emerging and changing technologies to best recommend and implement beneficial technologies and approaches for Data Integration.
• Ensures proper execution/creation of methodology, training, templates, resource plans and engagement review processes.
• Coach team members to ensure understanding on projects and tasks, providing effective feedback (critical and positive) and promoting growth opportunities when appropriate.
• Coordinate and consult with the project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.
• Architect, design, develop and set direction for enterprise self-service analytic solutions, business intelligence reports, visualizations and best practice standards.
• Toolsets include but not limited to: SQL Server Analysis and Reporting Services, Microsoft Power BI, Tableau and Qlik.
• Work with report team to identify, design and implement a reporting user experience that is consistent and intuitive across environments, across report methods, defines security and meets usability and scalability best practices