Data Analytics Specialist

Your role

Data Analytics Specialist - UBS Business Solutions US LLC - Morrisville, NC:

•Build data engineering models and ETL processes for financial applications on Cloudera CDH platform using Python, SQL, Hive, Impala, Git, and BitBucket.

•Enable data visualization of dashboards based on functional requirements using Tableau.

•Build CI/CD data pipelines using Jenkins and automate ETL workflows using Control-M.

•Liaise with management to ensure regulatory compliance.

•Engage with business users to explain issues and resolve heightened risk incidents.

•Apply knowledge of the trade lifecycle across various financial products as well as payment, clearing, and settlement services.

•Develop data engineering models, apply transformation rules to enrich raw feeds, and publish aggregated data sets for Tableau reports.

•Implement CI/CD and deployment using Jenkins to fast-track business model delivery.

•Build data pipelines, source data from SharePoint, execute custom Python scripts to make REST API calls using Microsoft Azure Active Directory, transform and load data into Hive tables, and generate visualization reports using Tableau.

•Identify bugs and roadblocks, perform root cause analysis, and apply technical fix to resolve production incidents.

•Perform data analysis and data modeling and build data lakes and cloud data warehouses.

•Work with SQL data analysis and data modeling, including query optimization; building ETL processes; data engineering concepts; Cloudera Hadoop CDH infrastructure (Impala, Hive, Hue, and HDFS); and, Shell Scripting (UNIX/Linux).

Your team

You'll be working in the Group Functions team in Morrisville, NC.

Your expertise

JOB REQUIREMENTS:

•Master's degree in Computer Science, Information Technology Management, Computer Information Systems, Management Information Systems, Engineering (any), Math, or a related field of study, plus two (2) years of experience with SQL data analysis and data modeling, including query optimization; building ETL processes; data engineering concepts; Cloudera Hadoop CDH infrastructure (Impala, Hive, Hue, and HDFS); Python; Shell Scripting (UNIX/Linux); Jenkins; Control-M; and/or, Tableau.

•Alternatively, the employer will accept a Bachelor's degree, plus five (5) years of progressively responsible experience.

Qualified Applicants apply through . Please reference: FRA-DR-UBS-085. NO CALLS PLEASE. EOE/M/F/D/V

About us

UBS is the world's largest and the only truly global wealth manager. We operate through four business divisions: Global Wealth Management, Personal & Corporate Banking, Asset Management and the Investment Bank. Our global reach and the breadth of our expertise set us apart from our competitors

We have a presence in all major financial centers in more than 50 countries.

Join us

At UBS, we know that it's our people, with their diverse skills, experiences and backgrounds, who drive our ongoing success. We're dedicated to our craft and passionate about putting our people first, with new challenges, a supportive team, opportunities to grow and flexible working options when possible. Our inclusive culture brings out the best in our employees, wherever they are on their career journey. We also recognize that great work is never done alone. That's why collaboration is at the heart of everything we do. Because together, we're more than ourselves.

We're committed to disability inclusion and if you need reasonable accommodation/adjustments throughout our recruitment process, you can always contact us.