Sr. Business and Data Analyst - Vice President

Join the Mizuho team as a Senior Business and Data Analyst !

Mizuho Americas LLC is seeking curious minds to join our data warehouse sourcing and analytics team in the role of Sr. Business and Data Analyst to collaborate with various IT and business stakeholders, including but not limited to Risk, Finance, Regulatory Reporting. In this role, the successful candidate will be expected to take a lead role in gathering business and data requirements for impact assessment and population into our Enterprise data warehouse. You will work as part of a team to understand patterns of data as they apply to a variety of MUSO Banking and Securities products, develop source to target mapping specifications for use by developers, and execute test plans to identify inconsistencies between our source systems and target warehouse objects. Additionally, the ideal candidate will collaborate under agile project methodology, participate in daily scrum meetings, sprint planning andactively participate in other Agile Ceremonies.

• Develop strong value-added relationships with business partners across multiple domains - risk, finance, regulatory reporting, and other IT groups.
• Demonstrate leadership characteristics, be a passionate, motivated self-starter and an ardent team player with sense of urgency and proactivity in meeting stakeholder expectations.
• Act as an SME in understanding source system data attribution for alignment to data warehouse target state transactional and analytic models.
• Apply proven experience in eliciting and validating business requirements and data/interface specifications as applied to MUSO product data constructs and solutions.
• Conduct business/data analysis and research to validate new requirements and identify patterns and inconsistencies of data across sources and targets as relevant to the underlying product behaviors.
• Conduct data mining of transactional and reference data for mapping of source system data attributes to target destination, including transformation specifications for implementation conforming to the platform standards and best practices.
• Lead and drive culture of maintaining evergreen documentation of the strategic platform with respect to MUSO Bank products including but not limited to documenting meeting minutes, mapping of current and target state business processes, and Standard Operating Procedures to ensure consistency and transparency of effort.
• Actively participate in Agile processes for successful project execution
• Constantly be on the lookout for ways to improve monitoring, discover issues and deliver better value to the customer.

• Bachelor's degree in business administration, Finance, or related field
• 5+ years of progressive experience in a Lead Business or Data Analyst role with strong data analysis in a large-scale Banking or Finance industry
  • SME level familiarity with Investment Banking products and related subject areas from a data attribution level: Derivatives (OTC (Over The Counter), Fixed Income), Finance (Repos, Reverse Repos), Cash, Loans, Commitments, and related products like Collateral is a MUST
  • Strong exposure to a Regulatory Reporting data environment is a plus.
• Effective communication, collaboration, analytical, problem-solving, and organizational skills
• Highly self-motivated, goal oriented and proactive
• Strong documentation and specification writing
• Understanding of Database Design concepts - Dimensional modelling is a huge plus
• Hands on, strong data querying skills to support finance product data analysis and mining efforts involving large sets of data from multiple sources, preferably in a Cloud first environment, is a plus.
  • Programming languages such as SQL , Snow SQL,
  • Proficiency in understanding database design principles and product, reference data strategic models is a plus.
  • Proficiency in statistics and statistical packages like Excel , to be used for End-User reports will be a plus.
  • Familiarity/experience with Snowflake data warehouse environments (Snow SQL) is a plus.
• Data visualization and data analysis experience is a plus (Power Bi, Tableau)
• Experience with project management tools such as Jira, and Confluence
• Proven experience in eliciting requirements and testing
• Experience in analyzing data to draw relevant business, reporting specific conclusions.
• Knowledge in generating process documentation (UML Sequence diagrams) is also a plus.