Lead Business Data Analyst / Data Modeler

$185,000 - $185,000/Yr

Brains Workgroup - Woodbridge Township, NJ

Full-time - Mid Level

Woodbridge Township, NJ

About the position

The Lead Business Data Analyst / Data Modeler will play a crucial role in the strategic data warehouse environment of a major bank in New York City and NJ. This position involves engaging with business partners to analyze and validate data requirements, ensuring the integrity and consistency of data across various sources. The role requires strong analytical skills, technical proficiency in database design, and the ability to communicate effectively with stakeholders.

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
• 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, 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
• Map 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

Requirements

• Bachelor's degree in business administration, finance, Data Analytics, or related field
• 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
• 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 proficiency
• 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 for data set analysis
• Familiarity/experience with Snowflake data warehouse environments (Snow SQL) a plus
• Data visualization and data analysis experience (Power Bi, Alteryx) a plus
• 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

Nice-to-haves

• Familiarity with Snowflake data warehouse environments (Snow SQL)
• Data visualization and data analysis experience (Power Bi, Alteryx)
• Knowledge in generating process documentation (UML Sequence diagrams)

Benefits

• Competitive compensation package (base is 165-185K)
• Excellent benefits
• Target bonus
• Hybrid work environment with up to 2-3 days per week in the office