Our client is seeking a skilled Cloud Data Engineer to design, implement, and manage scalable data solutions primarily on Microsoft Azure and other cloud platforms. In this role, you will oversee the end-to-end data lifecycle—including pipeline development, storage architecture, processing, and integration—to empower data-driven decision-making across the organization. You will leverage strong technical expertise and analytical problem-solving skills to collaborate closely with cross-functional teams and line-of-business stakeholders.
Key Responsibilities
- Design & Build: Develop scalable, secure, and resilient data architectures, storage environments, and processing pipelines using cloud-native services.
- ETL/ELT Workflows: Create automated workflows to streamline data ingestion, cleansing, mapping, transformation, and distribution using slowly changing dimensions (SCD) in a enterprise data warehouse environment.
- Storage & Integration: Load optimized, transformed data into target structures, including cloud data warehouses, reporting systems, and downstream analytics applications.
- Performance Tuning: Optimize 'big data' pipelines, queries, and architectures to ensure high performance, reliability, and cost-efficiency.
Operations, Security & Compliance
- System Health & Support: Monitor, troubleshoot, and maintain data environments to support high availability; provide on-call support for critical production systems as needed.
- Data Security & Governance: Implement robust security controls—including encryption, access management, and auditing—to protect sensitive data and support compliance with financial institution regulations.
- Documentation & Planning: Maintain clear documentation for data pipelines, system architectures, and procedures. Collaborate with IT teams to draft technology and security roadmap plans.
- Mentorship & Culture: Mentor IT staff on security best practices, emerging cloud technologies, and continuous learning in modern data engineering.
Cross-Functional Collaboration
- Requirement Gathering: Partner with business analysts, technical teams, and key business stakeholders to translate operational needs into technical data solutions.
- Analytics Enablement: Deliver clean, accessible datasets and leverage analytics services to generate actionable business insights.
Qualifications & Skills
Technical Experience
- Cloud Platform: Proven experience as an Azure Data Engineer or in a similar cloud-focused data role.
- Core Languages: Fluency in Python, SQL, and PySpark for data manipulation and pipeline development.
- Azure Data Ecosystem: Hands-on experience with Azure Data Factory, Databricks, Azure Data Lake Storage (ADLS), Azure Synapse Analytics / SQL DW, and Analysis Services.
- Data Warehousing: Solid background in building ETL/ELT pipelines, big data environments, and modeling dimensional data (e.g., slowly changing dimensions).
- Communication & Collaboration: Strong verbal and written communication skills with a track record of building positive relationships with internal teams, leadership, and external vendors.
- Regulatory Awareness: Familiarity with IT laws, rules, and compliance regulations specific to financial institutions.
Preferred Certifications