Data Analyst – CITFN

Skills

Description

• Interact with business stakeholders to gather data, reporting and analytic requirements for financial data sets
• Perform data analysis, data lineage, and profiling of data from source system to data repositories and reports. Responsible for data mapping to any “to-be” data structures.
• Create specifications for Reporting/Analytic requirements and work with business users to elicit hidden requirements and clarify vague requirements, as well as ensure sign offs on requirements.
• Interact with technical teams and guide offshore development resources to help translate requirements into solutions. Responsible for providing functional and technical guidance to the development team.
• Coordinate user acceptance testing of reports and data driven solutions by working with the business users.
• Assist the Program Managers with tracking work program deliverables using the appropriate SDLC methodologies including agile scrum.
• Manage daily technical challenges and communicates to management any risks or issues.
• Develop, manage, and maintain processes, procedures, and documentation for handover to application support.

Responsibilities

• Looking for someone to work in the data space, but primary role would be a data analyst
• The ideal candidate should have experience working as part of a team in an analyst role on projects involving the implementation of data marts, data warehouses (DW), and operational data stores. Prior experience in gathering and documenting data requirements is essential. When we say data analyst, we want someone who can still write business requirements- talking to clients (internal to ifc) and getting requirements, but the way we collect requirements for data solutions would be slightly different
• Getting requirements for building data solutions- data warehouse solutions, data mart, etc
• Need expertise in managing large datasets (details about the size and scale of datasets are essential) and working on large-scale data and reporting applications.
• Second part- these roles would have to be able to look at data and understand it- not just taking requirements, understand meaning and connect the dots to make recommendations
• Financial space exp- accounting, loan servicing, etc- general financial domain knowledge because immediate role would be involving treasury data sets, would be very hard for them to understand data otherwise
• Lastly, want person who has good analytical/problem solving skills
• Capital markets/wealth management type background is good here
• PL/SQL queries
• SQL, in house oracle Exadata (on prem) but moving to the cloud, if they have that skill set on azure that’s good but not required
• Not modeling etc but need to be able to understand and write sql queries
• Where have people fallen short in the past? Understanding data sets- gauging sql skills is somewhat easy, but the data skills are harder to parse- data skills combo with business analyst skills
• Able to look at data and understand data. When we say that- if this person has gone through a real data warehousing project or data mart, they should be fine
• Any questions we want to ask- have they worked in financial sector?
• he gets a lot of report developers presented as analysts, we are talking about implementing data solutions and gathered requirements etc
• Problem solving or analytical skills- want them to be fairly independent