15 Nov
|
Sunbrilo Technology
|
Pune
15 Nov
Sunbrilo Technology
Pune
## Job highlights
- 5+ years in data engineering with expertise in Azure Data Factory, Azure SQL Database/Synapse, Azure Data Lake, advanced SQL development, star/snowflake schema design, and Python scripting
- Design and monitor ADF pipelines, develop SQL procedures, implement data models, automate processes with Python, ensure data quality, and collaborate with stakeholders 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 efficient 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.
• Solid 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