Previous Job
Data Business Analyst
Ref No.: 17-03584
Location: Pittsburgh, Pennsylvania
Position Type:Full Time
Pay Rate : $ 130,000.00 - 150,000.00 /Year
The desired candidate will work as a data and technical business analyst on our Asset and Liability Management (ALM) platform for Corporate Treasury. The ALM platform is comprised of a large data warehouse built using Microsoft and big data (Hadoop) technologies used for optimizing Net Interest Income and for reporting to senior/executive management as well as regulatory reporting (e.g. Basel III, LCR and 4G/5G, SR14-1, NSFR and CCAR).
The position requires understanding of the big picture to implement strategic solutions and detail orientation for data quality and data governance and project management for reporting status and project progress.  The candidate must have experience with best-in-class methods, tools and techniques for elicitation and documentation of internal and external client needs and associated requirements, this includes use case modeling, business process modeling, and formal requirements traceability techniques. The analyst can leverage broad industry domain knowledge to assist in acquiring the business and client requirements. The analyst should be experienced working with financial data in detail, demonstrating broad product understanding.
The responsibilities of this role includes but not limited to:
  • Data; hands on data sourcing, analyze the data for quality, harmonize the data and work with sources to finalize requirements, develop feeds, document business rule transformations and work with development team to implement. Perform detailed reconciliations between data sets.
·         Lead implementations for enhancements/projects and ability to communicate clearly issues, risks and status updates to developed plans and dashboards
·         Assist to design data architecture, data flows and contribute to the overall application ecosystem
·         Iterate with the business and technology to define and develop coherent and visually aesthetic and graphic based business intelligence and dashboards
·         Provide production support on data issues and processes in a challenging and time crunch environment working closely with business, vendor, and data teams to resolve the issues
·         Authors various documents on projects such as use cases, process flows and other related project documents and adheres to life cycle documentation; BRDs, FRDs and test documentation
·         Experience in hands on data mapping and data ware housing concepts and reporting platforms, working with Big Data, Hadoop a plus
·         Strong experience SQL and working with large data sets knowledgeable in Microsoft SQL Server, SSIS, SSRS, SSAS and Tableau is a plus.
·         Experience working in the financial and banking industries and knowledge of financial products on The Client Mellon Corporation Balance Sheet.
·         Capable of working to resolving production issues in a stressful and time critical environment.
·         Previous development knowledge is a plus.
·         Advanced knowledge and extensive experience working with SQL
·         Experience working with offshore development teams
·         Strong testing and quality assurance mindset. Must be able to craft detailed test plans and test cases to ensure final deliverables meet specifications.
·         Excellent oral and written communication skills
Third Party Applications Not Accepted