Lead Data Engineer
Apache Airflow
Azure Data Engineer
Big Data
Bigdata
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Engineering Lead
Data Integration
Data Integration Tools
Data Lakehouse
Data Management
Data Modeling
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
Databricks
Databricks Lakehouse
Databricks Lakehouse Platform
ETL
Informatica
Integration
Lead Data Engineering
Snowflake
Software Development
Spark
SQL
Job Description
Mizuho Americas is seeking a Lead Data Engineer to help design, build, and deliver scalable enterprise data pipelines and data platform capabilities. This hybrid role in New York, NY focuses on hands-on engineering work across Snowflake, Python, and Apache Airflow, alongside leadership in architecture, engineering standards, and production reliability.
What you’ll do
- Design, develop, and maintain scalable data pipelines and ETL/ELT frameworks for enterprise data and analytics workloads.
- Build and optimize Snowflake solutions, covering data modeling, transformations, performance optimization, and workload management.
- Create reusable, production-grade data engineering components using Python.
- Design and orchestrate complex workflows using Apache Airflow (or similar orchestration platforms).
- Develop and support cloud-based data solutions using Microsoft Azure (or comparable cloud technologies).
- Collaborate with business, analytics, architecture, governance, and technology teams to translate requirements into scalable technical solutions.
- Define technical designs, integration patterns, engineering standards, and best practices for enterprise data solutions.
- Implement data quality, monitoring, lineage, security, and operational controls across data pipelines.
- Troubleshoot production issues and drive improvements in performance, resiliency, scalability, and maintainability.
- Perform design and code reviews and provide technical guidance to data engineering teams.
- Support modernization of the data platform and adoption of modern engineering practices and technologies.
- Work in an Agile environment.
Qualifications
- 7+ years of professional experience in data engineering, data platforms, or related roles.
- Strong hands-on expertise with Snowflake and Star Schema Architecture.
- Advanced programming experience with Python and SQL.
- Strong experience with Apache Airflow or comparable workflow orchestration technologies.
- Hands-on experience with Microsoft Azure or another major cloud platform such as AWS or GCP.
- Proven experience designing and building ETL/ELT pipelines, data integration solutions, and enterprise data processing workflows.
- Strong knowledge of SQL, data modeling, data warehousing, and performance optimization.
- Experience designing solutions for scalability, reliability, maintainability, and production support.
- Strong problem-solving, communication, and stakeholder-management skills.
- Ability to operate effectively in a complex enterprise environment and work across engineering, architecture, governance, and business teams.
Technologies
- Snowflake
- Python
- Airflow
- Azure
- Databricks
- Apache Spark
- Azure Data Factory (ADF)
- SQL
- ETL/ELT
- Star Schema Architecture
- Lakehouse
- Medallion architecture
- Cloud-native data platforms
Compensation and location
- Location: New York, NY (hybrid)
- Salary: USD 112,000 - 200,000 per year
Benefits
- Generous employee benefits package, including Medical, Dental, and 401K plans
- Discretionary bonus eligibility
Additional scheduling requirement
- In-office attendance is an essential function of the role.
- Minimum 50% in-office, or five out of every 10 business days.