Lead Data Engineer (Data Stage)

Raleigh, NC, US • Posted 60+ days ago • Updated 10 hours ago
Full Time
On-site
depends on experience
Company Branding Image
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

  • Extract
  • Transform
  • Load
  • ELT
  • Data Governance
  • Business Operations
  • Decision-making
  • Vendor Management
  • Budget
  • Auditing
  • Testing
  • Training
  • Systems Architecture
  • Technical Support
  • Mentorship
  • Data Analysis
  • Estimating
  • Test Plans
  • Documentation
  • Collaboration
  • Design Patterns
  • Data Structure
  • Meta-data Management
  • Data Management
  • Information Systems
  • Enterprise Architecture
  • Project Management
  • Data Engineering
  • Data Integration
  • SQL
  • SAP BODS
  • PL/SQL
  • Informatica
  • IBM InfoSphere DataStage
  • Datastage
  • Netezza
  • Microsoft SSIS
  • Agile
  • Amazon Web Services
  • Snow Flake Schema
  • Data Warehouse
  • Analytical Skill
  • Data Modeling
  • Data Quality
  • Reporting
  • Dashboard
  • Cloud Computing
  • Big Data
  • Management
  • Analytics
  • Python
  • Microsoft Power BI
  • Microsoft SSAS
  • Microsoft SSRS
  • Finance
  • Regulatory Reporting

Summary

Overview

This is a remote role that may only be hired in the following locations: NC, AZ

This position is responsible for the end-to-end delivery and maintenance of cloud and on-premises data solutions that include analytics data platforms, data integration (ETL/ELT), data quality, data lineage, metadata management, and data governance tools. While ensuring that projects are delivered on time and meet the expected functionality, ensures the integrity of data for business operations and decision-making and be instrumental in building and providing support for the services offered. Serves as a technical expert and a mentor for less experienced associates in the work group. Engage in vendor management, budget planning, and auditing to ensure that resources are allocated effectively and efficiently.

Responsibilities

  • System Enhancement - Leads team efforts to evaluate and improve department systems, processes, and applications. Utilizes programming specifications to construct modules, develop testing methods, and assists with designing training materials. Designs and executes test plans to validate application functions. Designs modifications that fit within existing system architecture.
  • Business Support - Provides technical support to production systems by addressing complex issues, anticipating maintenance requirements, and ensuring functionality for end user needs. Develops technical solutions to unique system problems. Leads major projects, delegates tasks, and ensures quality results.
  • Technical Expertise - Utilizes expertise to mentor and train associates within the work group. Participates in special projects and meetings as needed to convey critical technical insight. Serves as a technical resource for management, associates, and business units.
  • Data Analysis - Collects data related to user requests and determines scope, time estimates, and system impacts. Inspects business specifications, programming specifications, coding, test plans, documentation, and implementation plans for accuracy.
  • Collaborate with architects and development teams to understand data requirements, instantiate design patterns, build reusable Data Pipelines/frameworks, design new tables/queries and ensure the design is feasible, implemented accurately and compliant with all the bank standards while accelerating speed to market for delivery.
  • Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment.
  • Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking creatively to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes.

Qualifications

Bachelor's Degree and 6 years of experience in Advanced data engineering, enterprise architecture, project leadership OR High School Diploma or GED and 10 years of experience in Advanced data engineering, enterprise architecture, project leadership

  • 5 years of firsthand experience in data engineering/data integration SQL, SAP BODS, Oracle, SQL server, Informatica, DataStage, Netezza, SSIS technologies.
  • 3 years of experience in agile engineering practices, leading multi-time zone data teams
  • 2 years of hands-on experience in AWS, Snowflake, dbt
  • 1 year experience with cloud computing
  • Working knowledge of design and development concepts in Cloud Data warehousing, transactional and analytical data modeling, data quality, business reporting and dashboards
  • Working knowledge of technologies in Cloud technologies, analytics platforms, mastering, integrations, and big data management.
  • Working knowledge of Analytics Delivery, Python, Power BI, SSAS, SSRS
  • Experience in working with Finance and regulatory reporting will be plus.


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

$descr2

$descr3
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10122789
  • Position Id: 32113
  • Posted 30+ days ago

Company Info

About First-Citizens Bank & Trust Company

Why First Citizens?

As America’s largest family-controlled bank, we have a unique legacy of strength, stability and vision.In recent years, we’ve grown to become a top 20 U.S. bank and a member of the Fortune 500.

With growth comes opportunities to learn and advance.

Technology is mission-critical here – from innovations that make banking easier to ensuring funds and data are secure, we constantly seek to create efficiencies for our associates and customers.

Our technology team makes a lasting difference by delivering solutions that empower our customers to take charge of their financial future.

Discover what it’s like to make better happen every day at a bank that’s committed to offering you a supportive, vibrant and flexible work environment.

Equal Opportunity Employer.

Member FDIC.

 

Market Position
Top 20 U.S. Bank

Total Assets
$221B

About_Company_One
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Raleigh, North Carolina

Today

Full-time

depends on experience

Raleigh, North Carolina

Today

Full-time

depends on experience

Charlotte, North Carolina

Today

Full-time

depends on experience

Arizona

Today

Full-time

depends on experience

Search all similar jobs