Lead Business Data Analyst / Data Modeler

Our client, a major bank in New York City and NJ, is looking for talented Lead Business Data Analyst / Data Modeler for strategic company data warehouse environment.
Permanent position with competitive compensation package (base is 165-185K), excellent benefits, and target bonus.
This is hybrid commute position with up to 2-3 days per week in the NYC or Iselin, NJ Office locations.
Lead Business Data Analyst / Data Modeler

Job Qualifications

• Bachelor's degree in business administration, finance, Data Analytics, or related field
• 3 5 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
• Strong mathematical skills to help collect, measure, organize and analyze data
• Excellent 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
• Hands on technical skills supporting data analysis.
  • 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.
  • Familiarity/experience with Snowflake data warehouse environments (Snow SQL) a plus
• Data visualization and data analysis experience is a plus (Power Bi, Alteryx)
• Experience with project management tools such as Jira, and Confluence
• Proven experience in eliciting requirements and testing
• Experience in analyzing data to draw business-relevant conclusions.
• Knowledge in generating process documentation (UML Sequence diagrams) a plus

Job Responsibilities

• Actively engage as SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts
• Develop strong value-added relationships with business partners.
• Develop, review, and validate requirements and specifications as applied to 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.
  • Using 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
  • Using 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, processes, and procedures to ensure consistency and integrity of effort
• Take an active role in Agile scrum sessions for project execution, including task allocations, blocker remediation and general progress tracking
• Collaborate with team members to collect, analyze, and evaluate information from multiple sources
• Report on common sources of technical issues or questions and make recommendations to development team
• Participate in validating functional requirements, design specifications, testing analysis
• Mapping of source system data attributes to target destination, including transformation specifications as required to be used by developers for implementation
• Work independently and with team in collaborative way to complete tasks proactively as scheduled
• Constantly be on the lookout for ways to improve monitoring, discover issues and deliver better value to the customer

Please email your resume or