Sr. Business and Data Analyst

We are seeking curious minds to join our data sourcing and analytics team in the role of Business /Data Analyst to assist with data requirements discovery/documentation, testing validation and support for a strategic MUSO data warehouse environment. In the role, you will work as part of a team to understand patterns of data as they apply to MUSO Banking products and execute test plans to identify possible inconsistencies between our source systems and target warehouse objects. Additionally, you will collaborate under agile project methodology, participate in daily scrum meetings, and assist in compiling necessary documentation for testing results.

Key Responsibilities:

• Develop strong relationships with business partners
• 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
• 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
• Work with team in collaborative way to complete tasks as scheduled
• Constantly be on the lookout for ways to improve monitoring, discover issues and deliver better value to the customer
• Become SME on source system data attribution for alignment to data warehouse sourcing and analytic efforts

Qualifications:

• Bachelor's degree in business administration, Finance, Data Analytics or related field
• 5-7+ years in Business or Data Analyst role in Banking or 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 communication, analytical, problem-solving and organizational skills
• Creativity and Curiosity
• 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
• Proven experience in eliciting requirements and testing
• Experience in analyzing data to draw business-relevant conclusions
• Knowledge in generating process documentation

The expected base salary ranges from $111,000 - $180,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, certifications and licenses obtained. Market and organizational factors are also considered. In addition to salary and a generous employee benefits package, including Medical, Dental and 401K plans, successful candidates are also eligible to receive a discretionary bonus.

#LI-Hybrid