Senior Enterprise Data Analyst
About The Position
This is a remote role that may be hired in several markets across the United States. Perform duties as a subject matter expert for data delivery across multiple data domains per the business units data needs. Collaborate with large cross-functional teams, SMEs, vendors, etc. to deliver governed data. Act as a data SME and partner with diverse group of business functions to define requirements, analysis, mapping, validation and resolve any data issues. Perform detailed data analysis to translate business requirements into source to target data mappings for CDEs (Critical Data elements). Create and maintain all relevant documentation for Enterprise data warehouse which includes source-to-target mappings, data dictionaries, and other related materials. Communicate and guide technology teams through data mapping documents in implementing the solutions. Identify areas of improvement in current data infrastructure and work with key stakeholders to fix them. Validate functional workflow, business rules, and formulae through data profiling using SQL (Structured Query Language) queries. Work closely with business stakeholders to share insights and data issues. Perform ad-hoc analytics using advanced SQL to extract business value and answer questions from stakeholders. Drive and enforce data governance framework to ensure high quality strategic data solutions. Develop and execute procedures and processes to certify data quality for business purposes. Ensure data consistency, accuracy, timeliness, validity, and completeness. Represent data management group in various forums such as Internal / external audits, status updates, and respond to queries in an effective and timely manner. This is a remote role that may be hired in several markets across the United States.
Requirements
- Bachelor’s degree in Information Technology, or a related field
- six (6) years of experience in the job offered or six (6) years of experience as Data Management, Project Manager, Data Analyst or related occupation
- 5 years of experience in banking and financial services
- expert proficiency in working with SQL
- deep understanding of Data Warehousing and transformation methods, and ETL processes
- proven experience in Data Management, Data Analysis, Data Quality, Data Governance, Metadata management, lineage documentation, Data Profiling, Data Mapping and Data Validation
- knowledge of data spreadsheets and databases, Business Analytics, and Alteryx
- knowledge of data governance best practices and tools (such as Collibra)
- hands on experience in ETL tools for building data pipelines and process automation
- relevant experience in BI reporting tools, both Tableau and Business Objects
- experience supporting monthly close process and ad-hoc projects as needed
Responsibilities
- Subject matter expert for data delivery across multiple data domains
- Collaborate with cross-functional teams to deliver governed data
- Partner with business functions to define requirements, analysis, mapping, validation and resolve data issues
- Translate business requirements into source to target data mappings for CDEs
- Create and maintain documentation for Enterprise data warehouse
- Communicate and guide technology teams through data mapping documents
- Identify areas of improvement in current data infrastructure
- Validate functional workflow, business rules, and formulae through data profiling using SQL queries
- Share insights and data issues with business stakeholders
- Perform ad-hoc analytics using advanced SQL
- Drive and enforce data governance framework
- Develop and execute procedures and processes to certify data quality
- Ensure data consistency, accuracy, timeliness, validity, and completeness
- Represent data management group in various forums
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
