HSBC Lead Analyst (QlikView / QlikSense) in Arlington Heights, Illinois

Provides technical leadership and on going system support across the organization. Develops and maintains data and processes of a complex nature to support the tactical and analytical needs of the assigned unit. Coordinates and completes complex projects according to plan when assigned. Employs several programming languages of different utility to access information systems (Data Warehouses, data marts, raw data source files, etc.) to provide information support to assigned unit. Directs project activities, initiates analysis, and provides solutions for problems within scope of responsibility. Works independently with management and key end-users to understand and obtain information requirements. Enables and assists analytic and business staff to achieve optimal financial return from data resources.

The Lead BI Data Analyst – QlikSense will be an integral part in supporting the Data and Information Management team to automate data feeds and create intuitive dashboards.
The role will act as a source of business centric innovation; the candidate will partner across the organization to support data driven initiatives by leveraging our Enterprise Data Warehouse, Analytics Mart, and third party sources.

The successful candidate will build structures within organization data mart that 1.) Lend value by extending the capabilities of reporting for the business 2.) Extended to support complex segmentation , model building and dashboard development.

  • Impact on the Business *

    • Provide technical leadership and consultation to define objectives and requirements and develops requirements into a format that allows a technical solution to be created and implemented. Finalizes recommendations when ascertaining the type of information to be extracted. Leads consensus on specifications and moves to execution.
    • Solve technically complex programming projects in assigned area. Translate loosely defined business problems into a set of objectives, criteria and logical specification so a programming solution can be developed. Develop, test and write highly complex application programs, queries and profiles according to specification.
    • Identify system performance issues on large, complex queries.
    • Redevelop queries to perform in a more efficient manner.
    • Develop cost effective code in the completion of assigned projects. Mentor Senior CIM and CIM Analysts as assigned.
    • Makes recommendations to help evolve and make improvements to the information infrastructure. Develop SAS data marts and stages data for use throughout the organization. Gather business requirements, code, test, debug, creates documentation and implement solutions. Increase the awareness and provide support in the usage of information solution by business analysts. Develop and produce standard reports and files and delivers according to specification.
    • Develop proficiency in project management and information systems analysis skills. Maintain a high level proficiency in programming languages. Provide technical analysis and solutions to issues; sets technical directions.
    • Assists management in developing project plans and executing data mart development assignments. When assigned as project manager, leads projects of high complexity, prepares project plans, estimates and schedules, and manages projects to assure objectives are met on time and within cost.
    • Coordinate activities and evaluates performance of project team and reports performance. May lead multiple projects simultaneously.
    • Assist in the training and orientation of other staff and end users

    Customers / Stakeholders

    • Design, develop and maintain highly complex databases and data marts as needed for MIS, end user computing and statistical modeling. Ensure all databases and data marts are accurate, documented and accessible. Ascertain, recommend and implement methods of improving efficiencies in database design, programming tools and coding methodologies for business analysts and the department.
    • Develop, train and support Senior CIM and CIM Analysts as required. Review finished projects and work in progress to ensure correctness, accuracy and conformance to department standards.
    • Seek technical and professional information and processes regarding area of responsibility to enhance department knowledge base.

    Operational Effectiveness & Control

    • To implement the Group compliance policy locally by containing compliance risk in liaison with the Head of Group Compliance, Global Business Compliance Officer, Area Compliance Officer or Local Compliance Officer, ensuring adequate compliance resources and training, fostering a compliance culture and optimizing relations with regulators.
    • Complete other responsibilities, as assigned.

    Management of Risk

    • Ensure compliance, operational risk controls in accordance with HSBC or regulatory standards and policies; and optimize relations with regulators by addressing any issues.

    Observation of Internal Controls

    • Maintains HSBC internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators. Day to day activities

    • Create and develop dashboards in QlikView & QlikSense.

    • Intermediate level experience in COGNOS 10.
    • Ability to understand the Data transformation in COGNOS Framework behind a Cognos 10 report.
    • Able to implement and develop the 3 tier approach for QlikView / QlikSense(QV/QS).
    • Experience in migrating Reports from COGNOS 10 to QlikSense
    • Experience with Advance QV/QS objects and extensions (Geo-Maps/ Sunburst Charts/ Waterfall etc)
    • Document Data extraction , Transformations at a field level for all deliverables.
    • Expert on Creating Nprinting outputs based on QV/QS dashboards.
    • Ability to set up section access based security on QV/QS.
    • Data Validation on reports being produced on QV/QS
    • Working with Project Management to help manage the dependencies analysis, risk identification, and risk mitigation
    • Manage the adherence to scope and requirements (functional and non-functional) to ensure the projects remain on track.
    • Define test conditions and success criteria to ensure that systems testing requirements are provided to IT in advance of system testing and oversee SIT to ensure that test cases are reported and issues raised within this cycle prior to the business UAT. Where necessary, define, participate and undertake testing, defect analysis and issue resolution during QA and UAT testing cycles

    • A minimum of five to seven years experience in a computing or information science environment.

    • Bachelor’s degree, or equivalent experience, in Computer Science, Mathematics, Statistics, etc. or related field.
    • Advanced degree preferred.
    • Strong organizational, analytical and interpersonal skills required.
    • Excellent interpersonal, presentation, and written and verbal communication skills.
    • Experience with SAS Programming Preferred
    • Experience in d3js to build extension objects for QlikSense Preferred
    • Experience with R & Python Preferred
    • Experience with Cognos development Preferred
    • Hadoop and Big Data Experience Preferred
    • Cloud Experience for e.g. Google cloud, AWS etc. Preferred
    • Domain experience in banking and regulatory environments Preferred


Job: *Information Technology

Title: Lead Analyst (QlikView / QlikSense)

Location: Illinois-Arlington Heights

Requisition ID: 0000AEO3