Data Warehouse & Analytics Engineer at First Citizens BancShares in Raleigh, NC

Job description

Overview Responsible for developing and maintaining the trusted data foundation that supports technology performance reporting, operational and risk metrics, analytics, and operational insights. This role acquires, transforms, structures, and maintains data from multiple sources to enable consistent, scalable, and automated reporting and analytical solutions. The position also designs and supports an interim analytics data repository to meet current business needs while partnering with enterprise data teams and preparing for transition to long-term enterprise data solutions. Responsibilities & Qualifications Duties & Responsibilities System Enhancement & Data Warehouse Support Evaluates, enhances, and maintains technology performance data warehouse solutions, reporting capabilities, and analytics platforms. Develops and supports data structures, processes, and applications that improve access to technology performance metrics and operational insights. Designs, develops, tests, and implements enhancements that align with existing system architecture and enterprise technology standards. Identifies opportunities to improve solution performance, scalability, maintainability, and reliability. Data Ingestion & Source Integration Develops and maintains data ingestion processes that integrate information from technology platforms, operational systems, vendor applications, and other internal and external data sources. Supports source-to-target mappings, data integration requirements, and data movement processes. Develops and maintains interfaces utilizing APIs, database connectivity, and file-based integrations to ensure efficient and reliable data acquisition. Collaborates with business and technology stakeholders to identify new data requirements and integration opportunities. Data Transformation & Curation Develops and maintains ETL/ELT processes that transform source data into trusted analytics-ready datasets. Applies business rules, data validations, standardization processes, and transformation logic to support reporting and analytical requirements. Ensures data consistency, accuracy, usability, and alignment with established business definitions and reporting standards. Analytics Data Modeling Designs, develops, and maintains analytical and dimensional data models that support technology performance management, reporting, dashboards, scorecards, and KPI measurement. Supports reporting and analytics initiatives through the development of optimized data structures and reporting datasets. Collaborates with stakeholders to translate business requirements into effective analytical data solutions. Historical Data & Snapshot Management Maintains historical data repositories and snapshot methodologies to support trend analysis, forecasting, benchmarking, audit requirements, and long-term performance measurement. Ensures historical data structures support consistent reporting and analysis across reporting periods. Implements processes that preserve data lineage and historical integrity. Data Quality Controls Develops and maintains data quality controls, validation procedures, reconciliation processes, and monitoring solutions. Identifies, researches, and resolves data integrity issues, anomalies, and discrepancies. Partners with source system owners and stakeholders to improve data quality and ensure confidence in reporting outputs. Supports data governance, documentation, and compliance requirements where applicable. Business Support & Operational Excellence Provides technical support to production data warehouse and analytics environments by addressing complex issues, anticipating maintenance requirements, and ensuring ongoing functionality. Monitors data processes, data flows, and scheduled jobs to ensure timely and accurate delivery of information. Performs root cause analysis and implements corrective actions to improve system stability and performance. Develops technical solutions to unique business and system challenges. Leads maj