Business Intelligence
Role details
Job location
Tech stack
Job description
Designing, developing, testing, and implementing Business Intelligence (BI) solutions for the Data Warehouse using SAP Business Objects, Tableau, SQL query, Autosys, DB2, Oracle, MS SQL Server, and AWS. Developing and maintaining Python code to automate business requirements. Designing and developing financial dashboards and reports for core banking products loans, deposits, trade finance, treasury, and customer statements. Performing business intelligence (BI) development using SAP Business Objects (designing, developing, testing, and implementing Business Objects Universes, reports, Security, and performance tuning), and using Tableau (designing, developing, testing, and implementing Data Source, Dashboard, Worksheet, LODs, Security, and performance tuning). Writing, evaluating, testing, and performance tuning advanced SQL queries in database technologies using DB2, Oracle MS SQL Server, AWS, or similar platforms. Developing and scheduling batch jobs using Autosys; and with Waterfall methodology and Agile methodology. Analyzing business requirements and preparing functional and technical specifications, and test cases. Coordinating and interacting with technical and business groups. Assigning work to onshore and offshore contractors, checking their work, and ensuring the project and tasks are delivered on time and with quality. Supporting consultative relationships with key business stakeholders, proactively identifying, and addressing BI needs to meet business needs, along with regulatory and compliance requirements. Supporting the development of a change management process that facilitates the ability for business leaders to propose new metrics or metric modifications per business needs. Supporting the development of a standard process on defining data requirements, managing governance, and creating BI reports and dashboards for use throughout the organization. Supporting the partnership with business stakeholders to streamline and automate existing reporting, crucial for meeting regulatory and compliance requirements; and Providing support to define, design, implement, and maintain key performance indicators (KPIs) to support operational efficiency., Other: Required to work nights & weekends & be on-call during non-business hours as necessary for technical support & maintenance purposes.
Requirements
Education: Bachelor's Degree in Computer Science, Information Systems, Information Technology, Computer Engineering, or a related field (or foreign equivalent degree).
Experience: 3 years of experience performing business intelligence (BI) development using Tableau (designing, developing, testing, and implementing Data Source, Dashboard, Worksheet, LODs, Security, and performance tuning); writing, evaluating, testing, and performance tuning SQL queries in database technologies (Oracle, MS SQL, My SQL, Server or DB2) and database cloud technologies (AWS S3 bucket and AWS redshift); with Apache Spark scripting as a processing engine; analyzing business requirements, preparing functional and technical specifications, and test cases; and 1 year of experience must include business intelligence (BI) development using Power BI, SAP HANA, Alteryx, or Business Objects (designing, developing, testing, and implementing Business Objects Universes, reports, Security, and performance tuning); developing and scheduling batch jobs using Autosys or Windows batch scripting; maintaining project deliverables with Waterfall methodology and Agile methodology; and developing and maintaining Python code.