Shulman Fleming & Partners
Overview
Business/Data Analyst (VP Level)
Hybrid Schedule at least 3 days onsite-NYC or Iselin NJ
Salary Range: $111k to $175k
No Sponsorship Available
To qualify for this role, you must have a deep understanding of Data warehousing, and experience doing data integration into a data warehouse (like a cloud/dimensional warehouse). You must also have strong financial knowledge of products like derivatives, paper loans, commercial paper, cash, or equities as well as the product and data footprint underneath that product. You will be expected to perform core analysis on how to bring that data into the data warehouse. You will need Data profiling skills (SQL coding), data mapping skills and will do data model enhancement.
Additionally, as the Data SME you will collaborate under agile project methodology, participate in daily scrum meetings, and assist in compiling necessary documentation for testing results.
Responsibilities
Become SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts
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
Participate in Agile methodologies for project execution
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
Qualifications
7+ in Business or Data Analyst role in Finance industry
Subject Matter Expertise with one or more of the following products or subject areas from a data level: Derivatives (OTC,ETD), SFT/Repo, Cash/Bonds, Commercial Paper Loans, Deposits, General Ledger; Regulatory Reporting for Banks
Strong mathematical skills to help collect, measure, organize and analyze data
Strong documentation and specification writing
Understanding of Database Design concepts in a Datawarehouse environment
Hands on technical skills supporting data analysis
Programming languages such as SQL, and Python
Technical proficiency regarding database design development, and data models
Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analysis.
Familiarity/experience with Snowflake data warehouse environments (SnowSQL) a plus
Data visualization and data analysis experience is preferred (PowerBi, Tableau)
Experience with project management tools such as Jira, Trello, and Confluence
Experience in analyzing data to draw business-relevant conclusions
Knowledge in generating process documentation
#J-18808-Ljbffr
Hybrid Schedule at least 3 days onsite-NYC or Iselin NJ
Salary Range: $111k to $175k
No Sponsorship Available
To qualify for this role, you must have a deep understanding of Data warehousing, and experience doing data integration into a data warehouse (like a cloud/dimensional warehouse). You must also have strong financial knowledge of products like derivatives, paper loans, commercial paper, cash, or equities as well as the product and data footprint underneath that product. You will be expected to perform core analysis on how to bring that data into the data warehouse. You will need Data profiling skills (SQL coding), data mapping skills and will do data model enhancement.
Additionally, as the Data SME you will collaborate under agile project methodology, participate in daily scrum meetings, and assist in compiling necessary documentation for testing results.
Responsibilities
Become SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts
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
Participate in Agile methodologies for project execution
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
Qualifications
7+ in Business or Data Analyst role in Finance industry
Subject Matter Expertise with one or more of the following products or subject areas from a data level: Derivatives (OTC,ETD), SFT/Repo, Cash/Bonds, Commercial Paper Loans, Deposits, General Ledger; Regulatory Reporting for Banks
Strong mathematical skills to help collect, measure, organize and analyze data
Strong documentation and specification writing
Understanding of Database Design concepts in a Datawarehouse environment
Hands on technical skills supporting data analysis
Programming languages such as SQL, and Python
Technical proficiency regarding database design development, and data models
Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analysis.
Familiarity/experience with Snowflake data warehouse environments (SnowSQL) a plus
Data visualization and data analysis experience is preferred (PowerBi, Tableau)
Experience with project management tools such as Jira, Trello, and Confluence
Experience in analyzing data to draw business-relevant conclusions
Knowledge in generating process documentation
#J-18808-Ljbffr