Business Intelligence Analyst
Cathay Bank
- Rosemead, CA
- $35.48-43.81 per hour
- Permanent
- Full-time
- 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.
- 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.
Pay determined based on job-related knowledge, skills, experience, and location.Cathay Bank offers its full-time employees a competitive benefits package which is a significant part of their total compensation. It is our goal to provide employees with a comprehensive benefits package to fit their needs which includes, coverage for medical insurance, dental insurance, vision insurance, life insurance, long-term disability insurance, and flexible spending accounts (FSAs), health saving account (HSA) with company contributions, voluntary coverages, and 401(k).Cathay Bank may collect personal information from potential job candidates and applicants. For more information on how we handle personal information and your applicable rights, please review our .Cathay Bank is an Equal Opportunity and Affirmative Action Employer. We believe in diversity, equity, and inclusion in the workplace. We welcome applications for employment from all qualified candidates, regardless of race, color, ethnicity, ancestry, citizenship, gender, national origin, religion, age, sex (including pregnancy and related medical conditions, childbirth and breastfeeding), reproductive health decision-making, sexual orientation, gender identity and expression, genetic information or characteristics, disability or medical condition, military status or status as a protected veteran, or any other status protected by applicable law.