Business Intelligence Analyst

UBS • Raleigh, NC

239d

About The Position

As a Business Intelligence Analyst at UBS Business Solutions US LLC in Morrisville, NC, you will gather business requirements and analyze, design, develop, test, implement, and document various functionalities of data warehouses, data marts, and business intelligence. You will participate in the full lifecycle development of reporting projects, including requirements gathering, analysis, design, development, testing, and production rollover. Your role will involve creating external, internal, and context filters to improve performance, generating dashboards by joining multiple tables, and creating action filters, parameters, KPIs, calculated sets, and hierarchies for preparing dashboards and worksheets in Tableau. You will also test dashboards to ensure data matches business requirements and check for any changes in the underlying data. Additionally, you will work on building dashboards, perform report scheduling using Tableau, and handle performance tuning of Tableau reports. Your responsibilities will include combining data from multiple databases into one report, creating and managing Tableau sites, projects, workbooks, groups, data views, data sources, and data connections, as well as performing database development and data analysis on stored procedures, triggers, and functions.

Requirements

• Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, Information Technology, Engineering (any), Math, or a related field of study.
• Two (2) years of experience with SQL scripting and performance tuning (Sybase/Oracle).
• Experience with Tableau, Power BI, Unix, and/or Point.

Responsibilities

• Gather business requirements and analyze, design, develop, test, implement and document functionalities of data warehouses and business intelligence.
• Participate in the full lifecycle development of reporting projects.
• Create external, internal, and context filters to improve performance.
• Generate dashboards by joining multiple tables.
• Create action filters, parameters, KPI, calculated sets and hierarchies for dashboards in Tableau.
• Test dashboards to ensure data matches business requirements.
• Build and publish customized interactive reports and dashboards.
• Perform report scheduling using Tableau and handle performance tuning of Tableau reports.
• Combine data from multiple databases into one report.
• Create and manage Tableau sites, projects, workbooks, groups, data views, data sources and data connections.
• Perform database development and data analysis on stored procedures, triggers, and functions.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Securities, Commodity Contracts, and Other Financial Investments and Related Activities
• Education Level: Bachelor's degree