Overview

　　This position provides risk analytics and expert support at the highest level of operational complexity to business units. Creates methods to evaluate potential losses, and develops high-impact solutions to minimize or eliminate risk. Recommends and monitors enhancements to current processes and procedures, performing analysis and reporting in support of strategic objectives. Serves as a resource and may provide a leadership role for the work group through knowledge in the area of specialization.

　　Responsibilities

　　Identifying Risk - Leads the design and implementation of process evaluation methods, and the development of expert solutions to address identified risks. Works closely with management to ensure risk strategies are effective and compliant. May involve creation, evaluation, and execution of models or simulation scenarios to test risk conditions.Data Analysis - Sources, compiles, and interprets data. Performs complex analysis for risk trends and data discrepancies, and may direct the analytics efforts of the work group.Reporting - Produces reports based on data analysis, company trends, and risk factors. Conveys patterns, problems, and areas of improvement. Enables insight into potential losses and mitigation of identified risks through reporting activities.Operational Support - Supports business processes through a variety of escalated operational tasks. Develops, implements, and ensures continuous improvement of procedures. Acts as a resource to management and other associates, including production of documentation, presentations, or other materials to educate on risk policies and procedures. Handles complex technical matters and participates in special projects.Remote eligible.The base pay for this position is relative to your experience but the range is generally $97,900 to $169,700 per year. First Citizens offers a competitive, comprehensive benefits program which you can review here: https://jobs.firstcitizens.com/benefits.Qualifications

　　Bachelor's Degree and 4 years of experience in Risk management, or financial analysis, or statistical modeling OR High School Diploma or GED and 8 years of experience in Risk management, or financial analysis, or statistical modeling

　　Toolset Skills Required: Excel, Tableau, SAS, SQL

　　Excel Skills

　　Data Entry and Formatting: Entering and formatting data, using different data types, and applying basic formatting to make data readable.Basic Formulas and Functions: Using simple functions like SUM, AVERAGE, MIN, MAX, and understanding cell references (relative, absolute, mixed).Creating Basic Charts: Building basic charts like bar, line, and pie charts to visualize data.Managing Worksheets: Inserting, deleting, moving, and copying worksheets.Using Basic Text Functions: Familiarity with functions like CONCATENATE (or CONCAT), LEFT, RIGHT, MID.Sorting and Filtering Data: Basic sorting and filtering to manage and analyze datasets.Using more complex functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and nested functions.PivotTables and PivotCharts: Creating and manipulating PivotTables and PivotCharts for summarizing and analyzing large datasets.Intermediate Conditional Formatting: Applying and customizing more complex rules and understanding how to use formula-based conditional formatting.Working with Multiple Worksheets and Workbooks: Linking data across multiple sheets and workbooks, consolidating data.Advanced Charting: Creating complex and dynamic charts, like waterfall, Pareto, and combo charts, and using advanced charting features.Advanced PivotTable Features: Using slicers, timelines, calculated fields, and items in PivotTables.Lookup Functions: Mastery of advanced lookup functions and techniques, including XLOOKUP and array formulas.Error Checking and Data Troubleshooting: Identifying and correcting errors in formulas and data.Power Query (Get & Transform): Importing, transforming, and automating the data cleaning process using Power Query.Power Pivot and DAX: Leveraging Power Pivot and Data Analysis Expressions (DAX) for advanced data modeling and analysis.Designing interactive, dynamic dashboards for reporting.Data Security: Protecting workbooks, worksheets, and ranges, and understanding data sharing and security best practices.Performance Optimization: Enhancing performance of Excel workbooks, especially for large and complex datasets.Integration with Other Tools and Services: Integrating Excel with other applications and services, including the use of APIs and external databases.

　　Tableau Skills:

　　Data Import and Management:Connecting to data sources (Excel, CSV, etc.)Data preparation and cleaningVisualization Techniques:Creating simple charts (bar, line, pie, etc.)Using color, size, and labels effectivelyDashboard and Worksheet Creation:Building basic dashboards and worksheetsUnderstanding layout containers and floating versus tiled objectsCalculations:Simple calculated fields (sums, averages, etc.)logical calculationsSorting, Grouping, and Filtering Data:Applying basic filters and sortsCreating groups and setsUnderstanding of Basic Tableau Concepts:Dimensions vs. MeasuresDiscrete vs. Continuous fieldsUsing Tooltips and Annotations:Customizing tooltipsAnnotating visualizations for clarityAdvanced Visualization Techniques:Building more complex charts (histograms, scatter plots, heatmaps, etc.)Creating custom calculations in visualizationsUsing functions like IF, CASE, etc.Understanding table calculations and LOD expressionsData Blending and Joining:Combining data from multiple sourcesUnderstanding data relationships and joinsDashboard Interactivity:Implementing dashboard actions (filter, highlight)Using parameters for dynamic visualizationsData Extracts and Optimization:Creating and managing Tableau data extractsOptimizing performanceUnderstanding of Tableau Server/Online:Publishing dashboardsBasic understanding of user permissions and content managementComplex Calculations:Advanced Level of Detail (LOD) expressionsComplex table calculations and nested calculationsAdvanced Data Preparation:Using Tableau for data cleaning and transformationDealing with complex data structures and data modelingDescriptive Analysis and Statistical Functions:Incorporating statistical analysis into visualizationsAdvanced Dashboard and Visualization Techniques:Responsive design for dashboardsAdvanced interactive and animated visualizationsTableau Server/Online Advanced Management:In-depth understanding of Tableau Server/Online administrationAdvanced content and user managementTroubleshooting complex performance issuesExpert-Level Data Management and Scalability:Managing large datasets efficiently

　　SAS Skills

　　Basic SAS Environment Understanding: Navigating the SAS interface, understanding the concept of SAS libraries.Basic Data Operations: Importing and exporting data, basic data manipulation (like sorting, merging datasets).Understanding of SAS Datasets: Familiarity with SAS data step, creating and modifying SAS datasets.Basic SAS Procedures: Using PROC SORT, PROC PRINT, PROC MEANS, and PROC FREQ for basic data analysis.SAS Programming Basics: Writing basic SAS programs, understanding SAS syntax, and basic programming logic like IF-THEN statements, loops.Advanced Data Manipulation: More complex data steps, merging and appending datasets, using conditional logic.SAS Functions and Formats: Utilizing SAS functions for data manipulation, creating and applying custom formats and informats.Macro Programming Basics: SAS macro programming, using macro variables and simple macro definitions.SAS/SQL Integration: Using PROC SQL for database management and complex data manipulation.SAS Advanced Programming Techniques: Array processing, hash objects, advanced data step techniques.

　　SQL Skills

　　Basic SQL Syntax: Understanding and using basic SQL commands - SELECT, FROM, WHERE.Simple Queries: Writing simple queries to retrieve data from a database.Basic Data Manipulation: Inserting, updating, and deleting records.Basic Data Aggregation: Using GROUP BY and basic aggregate functions (COUNT, SUM, AVG, MIN, MAX).Joins and Subqueries: Understanding and using different types of joins (INNER, LEFT, RIGHT, FULL), writing subqueries.Complex Queries: More complex SELECT statements, using operators and filters effectively.Stored ProceduresSQL for Data Analysis: Using SQL for more complex data analysis tasks, integrating SQL with other data analysis tools.Integration with Other Systems: Integrating SQL databases with other software, understanding of APIs and external data sources.