What are the responsibilities and job description for the Lead Business Data Analyst - Data Modeler position at Brains Workgroup, Inc.?
Our client, a major bank in New York City, is looking for talented Lead Business Data Analyst / Data Modeler for strategic company data warehouse environment.
The information below covers the role requirements, expected candidate experience, and accompanying qualifications.
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 ModelerJob 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 industrySME 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 ResponsibilitiesActively 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 orUse this link to apply directly :
https : / / brainsworkgroup.catsone.com / careers / index.php?m=portal&a=details&jobOrderID=16566426
Or email : igork@brainsworkgroup.com
Check ALL our Jobs : http : / / brainsworkgroup.catsone.com / careers
Keywords : data analyst sql math investment banking derivatives cash excel spss sas models visualization powerbi alteryx jira confluence uml dimensional database snowflake testing
