Azure Data Engineer

Job Description

At Impressico, you will play a key role in designing, building, and optimizing enterprise-scale data solutions across complex Azure environments. Your work will directly impact clients’ data strategies, enabling scalable, high-performance data pipelines and analytics platforms.

• Design and Build Data Pipelines: Architect, implement, and maintain robust, high-throughput ETL/ELT pipelines for batch and real-time streaming workloads using Azure Data Factory, Databricks, Synapse Analytics, and other cloud-native services.
• Azure Cloud Expertise: Leverage deep experience with Azure cloud technologies—including Azure Data Lake, Azure SQL Database, Azure Synapse Analytics, Azure Databricks, etc. —to deliver hybrid and enterprise-scale data solutions.
• Data Modeling & Optimization: Apply advanced relational and dimensional modeling techniques to optimize data structures, query performance, and downstream analytics.
• Programming & Automation: Use Python and SQL to interact with diverse data sources and sinks (Relational, NoSQL, Blob Storage, streaming platforms) and automate data processing workflows.
• Scalable & Reliable Infrastructure: Build scalable, resilient, and maintainable data infrastructure, ensuring efficient extraction, transformation, and loading from heterogeneous sources.
• Data Migration & Validation: Lead complex data migration initiatives across databases and cloud platforms, performing rigorous testing, reconciliation, and validation to ensure data integrity.
• Stakeholder Collaboration: Partner with internal teams and external clients to troubleshoot, optimize, and enhance data solutions, providing technical guidance and best practices.
• Performance & Innovation: Continuously optimize data pipelines and infrastructure for performance, scalability, and cost-efficiency, staying up-to-date with emerging technologies and industry trends.

Critical Thinking & Consulting: Approach technical challenges with a consultative mindset, analyzing complex problems and proposing data-driven solutions that deliver business value.

Job Specification

Azure Certified: Hands-on expertise in designing and managing Azure cloud solutions.

CI/CD Proficiency: Solid understanding of Continuous Integration/Deployment best practices.

Python & Data Integration: Work with relational/NoSQL databases, Azure Blob/ADLS, and streaming platforms.

Cloud Migration: Proven experience migrating applications and infrastructure from on-premises to cloud environments.

Data Formats & Transformations: Skilled in XML, Parquet, CSV, JSON for data processing.

Azure: Hands-on with Azure Synapse, Databricks, ADLS, Azure SQL

Data Modeling: Strong grasp of relational and dimensional modeling, query optimization, and access patterns (SQL, MDX).

Pipeline Orchestration: Automate and manage data pipelines on-prem and in cloud environments.

Enterprise-scale Architecture: Deep experience with Azure and hybrid infrastructures, architecture design, and technology management.