Senior Data Engineer - Azure/SSIS/SQL

Role/Title : Senior Data Engineer Experience : 6-10 Years' experience Location : Pune Notice period : 0-30days only Key Skills : SSIS, SQL, Azure Synapse Job Summary : As a Senior Data Engineer, you will support the European Market using the Windows & Azure suite of Analytics & Data platforms.

The focus of the role is on the technical aspects and implementation of data gathering, integration and database design.

Job Responsibilities : Data Ingestion and Integration: Collaborate with Product Owners and analysts to understand data requirements & design, develop, and maintain data pipelines for ingesting, transforming, and integrating data from various sources into Azure Data Services.

Data Modelling: Assist in designing and implementing data models, data warehouses, and databases in Azure Synapse Analytics, Azure Data Lake Storage, and other Azure services.

Data Transformation: Develop ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS), Azure Synapse Pipelines, or other relevant tools to prepare data for analysis and reporting.

Data Quality and Governance: Implement data quality checks and data governance practices to ensure the accuracy, consistency, and security of data assets.

Monitoring and Optimization: Monitor and optimize data pipelines and workflows for performance, scalability, and cost Maintain comprehensive documentation of processes, including data lineage, data dictionaries, and pipeline schedules.

Collaboration: Work closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand their data needs and deliver solutions accordingly.

Azure Services: Stay updated on Azure data services and best practices to recommend and implement improvements in our data architecture and processes.

Skills Required : 6-10 years of experience in Data Warehousing with On-Premises or Cloud technologies.

Strong practical experience of developing ETL packages using SSIS.

Strong practical experience with T-SQL or any variant from other RDBMS.

Knowledge of Power BI, concentrating on Data Modelling rather than visualizations Graduate degree educated in computer science or a relevant subject.

Strong analytical and problem-solving skills.

Strong communication skills in dealing with internal customers from a range of functional areas.

Willingness to work flexible working hours according to project requirements.

Technical documentation skills.

Fluent in English.

Preferred Qualifications : Oracle PL/SQL.

Experience in working on Azure Services like Azure Synapse Analytics, Azure Data Lake.

Working experience with Azure DevOps paired with knowledge of Agile and/or Scrum methods of delivery.

Languages: French, Italian, or Spanish would be an advantage.

Agile certification.

(ref:hirist.tech)