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 hiring a Lead Data Engineer in New York, NY (hybrid) to help design and deliver scalable enterprise data pipelines and cloud-based platforms. This role is hands-on and technical, with the chance to shape architecture, engineering standards, and production reliability while modernizing the data platform.
What you’ll be doing
- Design, develop, and maintain scalable data pipelines and ETL/ELT frameworks for enterprise data and analytics workloads.
- Build and optimize solutions in Snowflake, including 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 a comparable orchestration platform).
- Develop and support cloud-based data solutions using Microsoft Azure (or comparable cloud technologies).
- Partner 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 controls including data quality, monitoring, lineage, security, and operational controls.
- Troubleshoot production issues and drive improvements across performance, resiliency, scalability, and maintainability.
- Perform design and code reviews and provide technical guidance to data engineering teams.
- Support data platform modernization and adoption of modern engineering practices and technologies.
- Work in an Agile environment.
What you bring
- 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.
- Strong experience designing and developing ETL/ELT pipelines, data integration solutions, and enterprise data processing workflows.
- Strong knowledge of SQL, data modeling, data warehousing, and performance optimization.
- Experience designing for scalability, reliability, maintainability, and production support.
- Strong problem-solving, communication, and stakeholder-management skills.
- Ability to operate effectively across engineering, architecture, governance, and business teams in a complex enterprise environment.
Tools you’ll work with
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 benefits
- Salary: USD 112,000 - 200,000 per year
- Generous employee benefits package including Medical, Dental, and 401K plans
- Discretionary bonus eligibility
Office attendance requirements
- In-office attendance is an essential function of the role.
- Minimum 50% time in the office, or five out of every 10 business days.