Remote Sql Support Analyst Jobs in Raleigh, NC (NOW HIRING)

This is a remote role that may only be hired in the following locations: (Charlotte, NC, Raleigh, NC or Phoenix, AZ)

This role is part of the Enterprise Data organization and is primarily focused on the overarching governance and architecture of all data across the enterprise.

This position leads Bank initiatives that improve enterprise data quality, governance, reporting, and analytics at an advanced level of ability and technical expertise. Drives positive change across the Bank through technical innovation and continuous improvement initiatives, as well as through cross-functional partnership with other business units. Creates and maintains technical documentation related to enterprise data, including centralized critical business reports. Provides expert consultation to team members, the Information Technology department, the Bank's Data Council, and other stakeholders on strategies that achieve data management goals. May provide leadership to less experienced consultants in the work group.

• Data Enhancement - Leads the implementation of enhancements for the quality, management, and storage of enterprise data. Executes initiatives that improve profiling, exception reporting, and issue resolution as well as general fixes for the Enterprise Data Warehouse. Builds dashboards to modernize analytics and assists management with special data projects.
• Business Support - Enforces data policies and procedures across the enterprise. Encourages discussion and feedback from associates in order to identify areas of improvement within data management capabilities. Completes month-end validations on reporting data to ensure the quality and completeness of data prior to business use. May assist in training or mentoring less experienced consultants in the work group.
• Business Strategy - Facilitates strategies that develop the Bank's data management capabilities. Assists management in creating and implementing a strategic road to achieve planned objectives. Works cross-functionally to mature department presence within Bank business units. Maintains a strong knowledge of current and emerging technologies or trends impacting the financial service industry.
• Documentation - Creates and maintains technical documentation for the Enterprise Data Warehouse, which includes source-to-target mappings, data dictionaries, and other related materials. Identifies and creates centralized business critical reports.

Bachelor's Degree and 6 years of experience in Data Management, Data Analytics OR High School Diploma or GED and 10 years of experience in Data Management, Data Analytics

Preferred Skills: 

• Understanding of data warehousing and transformation as well as extract, transform, and load processes, Knowledge of technologies and trends impacting the financial service and insurance industry.
• Experience in Banking, Regulatory, Data Warehouse/Data Lakes, AWS/ Snowflake
• Proven track record of leading agile data product delivery across cross-functional teams using agile frameworks such as Scrum, SAFe, or Kanban
• Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes, Knowledge of data spreadsheets and databases.
• Advanced proficiency in writing complex SQL queries to perform data analysis on the complex data sets.
• Ability to convert complex technical findings into clear, actionable narratives for both technical and non-technical stakeholders.
• Ability to create dashboards using the tools Tableau and Power BI for reporting analysis.

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.

Bachelor's Degree and 6 years of experience in Data Management, Data Analytics OR High School Diploma or GED and 10 years of experience in Data Management, Data Analytics

Preferred Skills: 

• Understanding of data warehousing and transformation as well as extract, transform, and load processes, Knowledge of technologies and trends impacting the financial service and insurance industry.
• Experience in Banking, Regulatory, Data Warehouse/Data Lakes, AWS/ Snowflake
• Proven track record of leading agile data product delivery across cross-functional teams using agile frameworks such as Scrum, SAFe, or Kanban
• Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes, Knowledge of data spreadsheets and databases.
• Advanced proficiency in writing complex SQL queries to perform data analysis on the complex data sets.
• Ability to convert complex technical findings into clear, actionable narratives for both technical and non-technical stakeholders.
• Ability to create dashboards using the tools Tableau and Power BI for reporting analysis.

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.