Business Intelligence Analyst

GENERAL SUMMARY

The Business Intelligence Analyst is responsible for enhancing and supporting the use of Data Warehouse, Data Marts, and Business Object reporting. The analyst will gather requirements from the end-user and interface with multi-disciplinary teams within the Bank to support the creation and delivery of timely, action-oriented intelligence. The analyst will also promote the IT vision to achieve a cross-functional, integrated reporting and analysis environment for users. Strong ability to understand critical business processes and to analyze complex problems is essential for the successful execution of value-added analytics. The analyst must have a strong commitment to quality and be skilled in operating and promoting an environment of teamwork. The analyst must be systematic and meticulous with details to effectively process large amounts of data into meaningful information.

ESSENTIAL FUNCTIONS

• Collaborate with Business Units to gather, define and prioritize reporting needs in the Business Intelligence area based on business strategic and operational goals.
• Design and develop reports using SAP Business Objects and/or MS SQL Reporting Services (SSRS).
• Build and test reporting framework and reporting deliverables, assuring data validity and integrity.
• Create or review technical design documentation to ensure the accurate development of reporting solutions.
• Conduct or coordinate tests to ensure intelligence is consistent with defined needs.
• Maintain library of model documents, templates, or other reusable knowledge assets.
• Provide technical support for existing reports, dashboards, or other tools.
• Maintain existing business reporting and analytical solutions by providing production support for troubleshooting and regular processing needs.
• Proactively analyze data to identify opportunities for improvement / best practice.
• Assist with the development of ETL (SSIS) processes to acquire and load data from internal and external sources.
• Assist with the implementation of data quality improvement processes and initiatives.
• Assist with logical and physical data modeling to support business intelligence initiatives.

QUALIFICATIONS

• Education: Bachelor's degree in Information Systems, Finance Accounting Technology, or finance-related discipline.
• Experience:
  • 2 to 3 years of experience as a Business Analyst, Data Analyst, or in a similar position, preferably in financial institutions. A strong background in the following is required:
  • Structured Query Language - especially in a Microsoft SQL Server environment.
  • Reporting/Business Intelligence tools such as Business Objects, SSRS, QlikView.
  • Data marts and data warehouse.
  • Good understanding of SQL, relational databases, mathematical formula, and data integration fundamentals.
  • Demonstrable strengths in data-driven reporting and effective interpreting based on the discovery and findings.
• Skills/Ability: Strong written and verbal communication skills. Able to effectively communicate with peers and managers. Self-motivated. Must be able to prioritize, multi-task, and meet agreed deadlines. Able to work both independently and in a team.

OTHER DETAILS

$35.48 - $43.81 / hour
Pay determined based on job-related knowledge, skills, experience, and location.