Job Description Summary:


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:


·        Analyze data from conceptualization through presentation of the data.

·        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 tasks and projects based on priority and deadlines

·        Interview users/stakeholders to learn their data/business processes and elaborate those as functional specifications for the development of data mapping, file inventories, and data flows. 

·        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



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

o   Strong MS SQL Server 2008 & T-SQL experience

o   Strong MS Integration Services 2008 experience

o   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 Big Data, Hadoop, Hive QL, Impala, Sqoop, Oozie a plus

·        Proven communication skills

  • Requires proficiency with presentation software,
  • Strong communication skills and a strong commitment to and affinity for delivering the highest level of customer service.



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