Note: The job is a remote job and is open to candidates in USA. First Citizens Wealth is a financial services organization focused on banking and wealth management. The Enterprise Data Analyst II supports enterprise data quality, governance, analytics, and data warehouse initiatives by developing documentation, improving data processes, building dashboards, and enforcing data policies. The role also provides consultation to stakeholders and facilitates initiatives that strengthen the Bank’s data management capabilities.
Responsibilities
- This position supports initiatives within the Bank that improve enterprise data quality, governance, and analytics
- Drives positive change across the Bank through technical innovation and continuous improvement initiatives
- Creates and maintains technical documentation related to enterprise data
- Provides expert consultation to team members, the Information Technology department, and other stakeholders on tactics that achieve data management goals
- Identifies and implements 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 where appropriate
- 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
- Facilitates initiatives that develop the Bank's data management capabilities
- Assists management in creating and implementing business plans to achieve planned objectives
- Maintains a strong knowledge of current and emerging technologies or trends impacting the financial service industry
- Creates and maintains technical documentation for the Enterprise Data Warehouse, which includes source-to-target mappings, data dictionaries, and other related materials
Skills
- Bachelor's degree in Information Technology, Data Management, Finance or related field plus five (5) years of experience in the job offered or as a Data Management Analyst, Data Analyst, Financial Analyst, or related occupation
- Requires experience working with databases and data warehouses
- Requires experience working with SQL
- Requires an understanding of data warehousing and transformation methods, lineage documentation, and ETL processes
- Requires knowledge of customizable workflow solution (JIRA)
- Requires knowledge of data intelligence platform for data classification, data governance and data quality (Collibra)
- Requires knowledge in data governance concepts and principles and an understanding of banking products and services
- Requires experience with Data Lineage, DB Visualizer, Data Quality, Metadata Management, Data Transformation, IMX, Data Profiling, ETL, Data Analysis, Regulatory Reporting and Data Lineage
- Requires experience with SharePoint and Confluence
- Requires experience with Alteryx, Power BI, Toad, and Tableau
- Requires experience with Informatica DQ and Axiom SL
- Requires experience with Salesforce and Ncino
- Requires experience with Oracle, SQL Server, Flexcube, LoanIQ, Signature, SQL, Abinitio MDH, and Stucky
Company Overview