Lead Business/Data Analyst with Banking or Financial Industry Experience

$165,000 - $185,000/Yr

Shulman Fleming & Partners - New York, NY

Full-time - Mid Level

New York, NY

Administrative and Support Services

About the position

The Lead Business/Data Analyst will play a crucial role in the Banking or Financial industry, focusing on data requirements analysis, mapping, documentation, testing validation, and support. This position requires expertise in data warehousing, particularly with Snowflake, and involves collaboration in Agile methodology. The analyst will engage in data attribution, conduct business analysis, and ensure the integrity of data across various sources, contributing to the overall success of data-driven projects.

Responsibilities

• Actively engage as SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts
• Develop, review, and validate requirements and specifications
• Conduct business/data analysis and research to validate new requirements and identify patterns and inconsistencies of data across sources and targets
• Use automated tools to extract data from primary and secondary sources
• Filter Data by comparing results in sources and targets to identify and correct code problems
• Use statistical tools to identify, analyze, and interpret patterns and trends in complex data sets that could be helpful for the diagnosis of exception requirements
• Document meeting minutes
• Take an active role in Agile scrum sessions for project execution, including task allocations, blocker remediation and general progress tracking
• Report on common sources of technical issues or questions and make recommendations to development team
• Mapping of source system data attributes to target destination, including transformation specifications as required to be used by developers for implementation

Requirements

• 3-5+ years in Business or Data Analyst role in Banking or Finance industry
• SME level familiarity with Investment Banking products or subject areas from a data level: Derivatives, Finance, Cash, Loans, Commitments; Regulatory Reporting
• Excellent communication, collaboration, analytical, problem-solving, and organizational skills
• Strong documentation and specification writing
• Understanding of Database Design concepts Dimensional modelling
• Hands-on technical skills supporting data analysis
• Proficiency in programming languages such as SQL
• Technical proficiency regarding database design development, and data models especially Dimensional Data Models (e.g., Snowflake)
• Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analysis
• Experience with Snowflake data warehouse environments (Snow SQL)
• Data visualization and data analysis experience is a plus (Power Bi, Alteryx)
• Experience with project management tools such as Jira, and Confluence
• Experience in analyzing data to draw business-relevant conclusions.

Nice-to-haves

• Experience with Loan IQ
• Data visualization and data analysis experience is a plus (Power Bi, Alteryx)