Senior Snowflake & BI Developer - Treasury Finance

mizuho; New York (NY); Hybrid; USD 112,000 - 190,000; Full time

Job summary

mizuho is seeking a data-focused engineer in New York to design and maintain Snowflake data solutions and BI reporting for Treasury and Finance teams. You will build scalable ETL/ELT pipelines, develop dashboards, and implement data quality controls to ensure accuracy and compliance with financial data standards.

The role requires collaboration with multiple stakeholders, experience in Agile environments, and strong SQL/Power BI skills. Hybrid in-office attendance is expected in New York.

Qualifications

• 5+ years of experience in data engineering, BI development, data warehousing, analytics engineering, or financial-services technology.
• Snowflake, advanced SQL development, and Power BI with dimensional modeling and data warehousing.
• Experience working with Finance/Treasury stakeholders on data & reporting needs.
• Experience in Agile delivery environments.

Responsibilities

• Act as a technical liaison with Treasury, Finance, Data Architecture, Engineering, Operations, Risk, and dependent tech teams.
• Design, develop, test, and maintain Snowflake data solutions and ETL/ELT pipelines.
• Develop Power BI dashboards, semantic models, KPIs, and DAX measures for Treasury and Finance reporting.
• Ensure data quality, governance, and controls across source systems, Snowflake, and reporting layers.
• Support full lifecycle activities including testing, UAT, code review, deployment, and production support.

Skills

Snowflake

SQL Development

Power BI

Dimensional Modeling

Enterprise Data Warehousing

Data Marts

Data Transformation

Data Quality

Data Lineage

Education

Bachelor's degree in Engineering/Information Systems or equivalent

Tools

Snowflake

Power BI

Job description

PRINCIPAL DUTIES AND RESPONSIBILITIES

Stakeholder Management

Act as a technical liaison with Treasury, Finance, Data Architecture, Engineering, Operations, Risk, and dependent technology teams. Partner directly with Treasury and Finance users to understand reporting requirements, financial calculations, business rules, and data dependencies. Communicate development progress, data-quality issues, risks, dependencies, and technical recommendations. Work collaboratively with Solution Architects, Data Architects, Business Analysts, and application teams. Support analysis and resolution of data and reporting discrepancies.

Snowflake Data Development

Design, develop, test, and maintain scalable Snowflake data solutions, including advanced SQL transformations, dimensional models, financial data marts, and reusable data components. Build and maintain ETL/ELT pipelines to ingest, transform, aggregate, and publish Treasury and Finance data from multiple source systems. Design and develop Power BI dashboards, semantic models, KPIs, calculations, and DAX measures supporting Treasury and Finance reporting and analytics. Optimize Snowflake queries, data structures, and processing patterns for performance, scalability, and efficient resource utilization, while troubleshooting data issues across upstream and downstream layers. Implement data-quality, reconciliation, and reporting controls to ensure Power BI outputs reconcile to approved source data and financial control totals.

Requirements & Data Solution Design

Partner with Treasury and Finance users to translate business requirements into data requirements, reporting specifications, transformation rules, and source-to-target mappings. Collaborate with Data and Solution Architects to design target-state data models and flows, maintaining traceability from source systems through Snowflake to Power BI. Maintain required data models, mappings, and technical documentation.

Data Quality, Governance & Controls

Implement data-quality, validation, and reconciliation controls across source systems, Snowflake, and reporting layers. Maintain data lineage, governance, security, and access controls for Treasury and Finance data. Support the full development lifecycle, including testing, UAT, code review, deployment, and production support.

Minimum Job Requirements or Experience

• 5+ years of experience in data engineering, BI development, data warehousing, analytics engineering, or financial-services technology.
• Hands-on expertise in Snowflake, advanced SQL development, and Power BI, supported by strong knowledge of dimensional data modeling, enterprise data warehousing, data marts, data aggregation and transformation, data-quality controls, and end-to-end data lineage.
• Experience working directly with Finance/Treasury stakeholders to understand financial data and reporting requirements.
• Experience working within Agile delivery environments.

Education and Other Requirements

• Batchlors in Engineering, Information Systems or equivalent practical experience.
• Strong written and verbal communication skills.
• Ability to translate business concepts into technical data solutions.
• Ability to work independently and take ownership of development deliverables.
• Comfortable working across business, technology, risk, operations, and data organizations.
• Strong analytical and problem-solving skills.
• High attention to data accuracy, reconciliation, and financial controls.

The expected base salary ranges from $112k-$190k. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, certifications and licenses obtained. Market and organizational factors are also considered. In addition to salary and a generous employee benefits package, successful candidates are eligible to receive a discretionary bonus.

#LI-Hybrid

Other requirements

In office attendance is an essential function of this role. There is currently a requirement to be in the office a minimum 50% of the time, or five out of every 10 business days. Specific information about the requirements for your role will be communicated during the recruitment process.