Senior Software Engineer - Pega (Remote) Job at First Citizens, Raleigh, NC

Q0wzUjN6YW1rRmhocVR1R0hKRlR1WXlNY2c9PQ==
  • First Citizens
  • Raleigh, NC

Job Description

Overview This is a remote role that may only be hired in the following locations: NC, TX Enterprise data warehouse supports several critical business functions for the bank including Regulatory Reporting, Finance, Risk steering, and Customer 360. This role is vital for building and maintaining enterprise data platform, data processes, and to support business objectives. Serves as production system support by resolving issues and ensuring ongoing functionality. May oversee the work of less experienced analysts or assist in special projects as needed. Responsibilities Responsible for designing, building, and maintaining data platform that supports data integrations for Enterprise Data Warehouse, Operational Data Store or Data Marts etc. with appropriate data access, data security, data privacy and data governance. Establish enterprise-scale data integration procedures, data pipelines and frameworks across the data development life cycle. Suggest and implement appropriate technologies to deliver resilient, scalable, and future-proof data solutions. Create data ingestion pipelines in data warehouses and other large-scale data platforms. Creating scheduled as well as trigger-based ingestion patterns using scheduling tools. Create performance optimized DDLs for any row-based or columnar databases such as Oracle, Postgres, Netezza database per Logical Data Model. Performance tuning of complex data pipelines and SQL queries. Performs impact analysis of proposed changes on existing architecture, capabilities, system priorities, and technology solutions. Manage deliverables of developers, perform design reviews and coordinate release management activities. Estimate and provide timelines for project activities. Identify, document, and communicate technical risks, issues and alternative solutions discovered during project. Drive automation, identify inefficiencies, optimize processes and data flows, and recommend improvements. Use agile engineering practices and various data development technologies to rapidly develop and implement efficient data products. Collaborate with Product Owners to understand PI goals, PI planning, requirement clarification, and delivery coordination. Technical support for production incidents and failures Work with global technology teams across different time zones (primarily US) to deliver timely business value. Qualifications Bachelor's Degree and 4 years of experience in Software application development and maintenance OR High School Diploma or GED and 8 years of experience in Software application development and maintenance Preferred: Data Engineering: Experience in designing and building Data Warehouse and Data lakes. Good knowledge of data warehouse principles, and concepts. Technical expertise working in large scale Data Warehousing applications and databases such as Oracle, Netezza, Teradata, and SQL Server. Experience with public cloud-based data platforms especially Snowflake and AWS. Data integration skills: Expertise in design and development of complex data pipelines Solutions using any industry leading ETL tools such as SAP Business Objects Data Services (BODS), Informatica Cloud Data Integration Services (IICS), IBM Data Stage. Experience of ELT tools such as DBT, Fivetran, and AWS Glue Expert in SQL - development experience in at least one scripting language (Python etc.), adept in tracing and resolving data integrity issues. Strong knowledge of data architecture, data design patterns, modeling, and cloud data solutions (Snowflake, AWS Redshift, Google BigQuery). Data Model: Expertise in Logical and Physical Data Model using Relational or Dimensional Modeling practices, high volume ETL/ELT processes. Performance tuning of data pipelines and DB Objects to deliver optimal performance. Experience in Gitlab version control and CI/CD processes. Experience working in Financial Industry is a plus. FCB 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 #J-18808-Ljbffr First Citizens

Job Tags

Remote job,

Similar Jobs

10-4 Truck Recruiting

CLASS A RECENT GRAD TRUCK DRIVER POSITION NO EXPERIENCE NEEDED Job at 10-4 Truck Recruiting

 ...Class A CDL Solo Truck Driver - RECENT GRADUATES OK!*********Please read to make sure you qualify :) POSITION DETAILS:...  ...Regional positions available **** Gain 3 months of experience and transfer to local ** No touch freight Weekly Pay via Direct Deposit... 

United States Secret Service

Criminal Investigator (Special Agent) - $40,000 Recruitment Incentive Job at United States Secret Service

 ...protective services for designated individuals. They plan and implement security measures for national special security events and may be...  ...to accept assignments anywhere within the United States and overseas. Certify that you have registered with the Selective Service... 

USM Business Systems

BizTalk Developer - Contract to hire Job at USM Business Systems

 ...Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.USM, a US ensured Minority Business Enterprise... 

Exceptional Childrens Foundation

School Van Driver Job at Exceptional Childrens Foundation

 ...Title: School Van Driver Reports to: AA Supervisor Department: Transportation Location: Kayne Eras School FLSA Status: Non-Exempt Program Hours: Monday Friday 6:00am 9:00am and 2:30 PM - 5:30 PM (split shift) Supervisory Responsibility: None... 

Core Medical Locums

Locum Tenens Pediatric Cardiac ICU Physician Assistant - $163 per hour Job at Core Medical Locums

 ...Core Medical Locums is seeking a Physician Assistant CICU - Cardiac Intensive Care Unit for a locum tenens job in Los Angeles, California....  ...Client in CA seeking a Locum Physician Assistant Critical Care Pediatric We are looking for a healthcare professional who is ready...