Share

A Business Information / Systems Analyst working within a global team, will support audit teams by developing analytical reports that facilitate data mining. A Candidate must be able to understand the value of the product/enhancement and communicate concrete designs for realizing that value. Candidate must become the subject matter expert (SME) for assigned accounts’ data processes, and must be able to articulate processes/requirements in a format that is digestible by Account Management, Data Services, and other teams.

This resource must be self-managed, self-directed, and priority-minded.  This role receives direction from the Data Services Manager, but also must share the responsibility of defining and planning the work for maximum benefit to provide auditors with tools they need to deliver our service in the ever changing market place. Time is split between analysing and manipulating data, writing complex SQL and collaborating with our audits to understand each client’s needs and workings with the goal to provide analytics and audit solutions.

Job Duties and Responsibilities:     

Analyse data from conceptualisation through presentation of the data. Requires proficiency with tools, knowledge of data analysis methodology, use of presentation software, strong communication skills and a strong commitment to and affinity for delivering the highest level of customer service.

Documenting requirements, designing test cases, and participating in the full development lifecycle

Develop, test and validate ETL processes

Profile data to measure quality, integrity, accuracy, and completeness

Manage multiple concurrent BIA-related tasks and smaller projects based on priority and deadlines

Interview users/stakeholders to learn their data/business processes. Deconstruct and re-design them into faster/better/cheaper processes. Finally, elaborate those as functional specifications for development.

Understand entire process for assigned accounts and how the parts combine to make the whole. Turn processes into detailed functional requirements, including but not limited to data mapping, file inventories, and data flow. 

Serve as a functional SME to development team as they implement the data needs as documented.

Communicate with Account Management, Business Operations, Data Services, and Development teams, as necessary, to ensure transparency, share insights, define scope, requirements, and liaise between teams to manage expectations

Communicating with both technical and non-technical end users

Contribute to the success of the organisation by helping others accomplish job results, learning new skills needed by the team, and finding new ways to help the team.

Responsibility for supervision and development of Junior Analysts

 

External Contact with

Qualifications/ Experience/ Skills required /Personal attributes:

Bachelor’s degree or three to five years related experience and/or training; or equivalent combination of education and experience.

3+ years of Experience in business analysis

Prior experience working within cross-functional teams in a matrix organization

SQL

Strong MS SQL Server 2008 & T-SQL experience

Strong MS Integration Services 2008 experience

Strong relational database analysis

Experience in SQL index management, performance optimization with large datasets, data warehouse/data mining

Experience with MS SQL, MS Excel, MS PowerPoint, MS Visio and relevant software

Exposure to/knowledge of R and Python

Proven communication skills

 

Additionally, experience in any of the following would be a distinct advantage

Enterprise accounting systems and packages

Principles of financial accounting

Oracle Applications (Financial), SAP, JD Edwards, Navision, Axapta

MS SQL Reporting Services 2008

Technical documentation

Knowledge of data mining with unstructured/textual data

Experienced in the complete life-cycle of solution development from capturing business requirements through solution delivery