Essential Duties and Responsibilities

- Pipeline Development: Design, build, and monitor ADF pipelines, dataflows, and triggers to automate ingestion and transformation of data from multiple systems.
- SQL Development: Write and maintain stored procedures, views, and reporting tables; tune queries for optimal performance.
- Data Modeling: Design and implement star/snowflake schemas to enable productive reporting and analytics.
- Data Correlation: Analyze cross-system data relationships to create unified reporting views and metrics.
- Automation: Develop Python scripts for validation, reconciliation, and process automation where needed.
- Data Quality: Implement validation checks, reconciliation processes, and alert to maintain data accuracy and reliability.

• Documentation: Create detailed technical documentation for pipelines, data models, and schedules.

- Stakeholder Collaboration: Work closely with finance, supply chain, and operations teams to translate requirements into scalable solutions that deliver measurable business value.





Qualifications Education and Experience

- Bachelors degree in Computer Science, Data Engineering, or related field.
- 5+ years of experience in data engineering, ETL, or database development.
- Proven hands-on experience with Azure Data Factory, Azure SQL Database/Synapse, and Azure Data Lake.

Knowledge, Skills, and Abilities

• Advanced SQL development skills, including stored procedures, functions, indexing, and performance tuning.

• Expertise in star and snowflake schema design for analytical data models.

• Familiarity with data governance, security, and best practices in Azure environments.

• Experience using Python scripting for data transformation and workflow automation.

• Strong understanding of ETL/ELT design patterns and incremental loading strategies.

• Excellent problem-solving, critical-thinking, and communication skills.

📌 Azure Data Engineer (Pune)
🏢 Sunbrilo Technology
📍 Pune