Design, build, and support scalable data pipelines and cloud-based data solutions utilizing AWS Services, Snowflake, dbt, Python, SQL, and related technologies.
Implement data warehouse solutions, dimensional data models, and ETL/ELT processes that support reporting, analytics, and business intelligence capabilities.
Implement data quality validations, test cases, and controls to ensure accurate, consistent, and reliable data assets.
Develop and maintain data tests, including dbt tests, to support data quality and reliability requirements.
Support workflow orchestration, monitoring, troubleshooting, log analysis, and production operations using Airflow and cloud-native technologies.
Collaborate with business users, product partners, analysts, and technology teams to deliver data solutions that support business objectives.
Follow established engineering standards, development practices, documentation requirements, and testing procedures to support high-quality solution delivery.
Participate in pipeline deployments, environment promotion activities, operational support, and performance optimization efforts using established CI/CD processes.
Leverage AI-powered development and productivity tools to improve engineering efficiency, code quality, and delivery outcomes.
Qualifications
Bachelor's Degree and 1 year experience
OR
High School Diploma or GED/Equivalent and 5 years' experience
Preferred Area of Study: Computer Science, Information Systems, Data Science, or related field
Preferred Area of Experience: Data engineering, database management, or related field. Experience with cloud-based data platforms and big data technologies
Preferred Qualifications
Experience with enterprise ETL/ELT tools such as DataStage, SAP BODS, SSIS, Informatica, or equivalent technologies.
Experience with Operational Data Stores (ODS), analytics platforms, and data products.
Experience working with cloud-based and on-premises data environments.
Exposure to Data Vault modeling and modern data warehousing methodologies.
Understanding of data governance, security, compliance, and data quality management practices.
Experience within Financial Services, Banking, or other highly regulated industries.
Familiarity with Tableau, Power BI, or other analytics and visualization platforms.
Experience using AI-powered development and productivity tools to improve engineering efficiency and delivery outcomes.
AWS Certified Cloud Practitioner, AWS Certified Developer – Associate, AWS Certified Data Engineer – Associate, SnowPro Core Certification, or equivalent cloud and data platform certifications.
#LI-DNI
Additional Information
This job posting is expected to remain active for 45 days from the initial posting date listed above. If it is necessary to extend this deadline, the posting will remain active as appropriate. Job postings may come down early due to business need or a high volume of applicants.
If hired in North Carolina, the base pay for this position is generally between $86,625 and $100,000. Actual starting base pay will be determined based on skills, experience, location, and other non-discriminatory factors permitted by law. For some roles, total compensation may also include variable incentives, bonuses, benefits, and/or other awards as outlined in the offer of employment.
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.
Duties and Responsibilities
The successful candidate will thrive in a collaborative environment, possess problem-solving skills, and be passionate about building reliable, scalable, and high-quality data solutions.
Design, build, and support scalable data pipelines and cloud-based data solutions utilizing AWS Services, Snowflake, dbt, Python, SQL, and related technologies.
Implement data warehouse solutions, dimensional data models, and ETL/ELT processes that support reporting, analytics, and business intelligence capabilities.
Implement data quality validations, test cases, and controls to ensure accurate, consistent, and reliable data assets.
Develop and maintain data tests, including dbt tests, to support data quality and reliability requirements.
Support workflow orchestration, monitoring, troubleshooting, log analysis, and production operations using Airflow and cloud-native technologies.
Collaborate with business users, product partners, analysts, and technology teams to deliver data solutions that support business objectives.
Follow established engineering standards, development practices, documentation requirements, and testing procedures to support high-quality solution delivery.
Participate in pipeline deployments, environment promotion activities, operational support, and performance optimization efforts using established CI/CD processes.
Leverage AI-powered development and productivity tools to improve engineering efficiency, code quality, and delivery outcomes.
Qualifications
Bachelor's Degree and 1 year experience
OR
High School Diploma or GED/Equivalent and 5 years' experience
Preferred Area of Study: Computer Science, Information Systems, Data Science, or related field
Preferred Area of Experience: Data engineering, database management, or related field. Experience with cloud-based data platforms and big data technologies
Preferred Qualifications
Experience with enterprise ETL/ELT tools such as DataStage, SAP BODS, SSIS, Informatica, or equivalent technologies.
Experience with Operational Data Stores (ODS), analytics platforms, and data products.
Experience working with cloud-based and on-premises data environments.
Exposure to Data Vault modeling and modern data warehousing methodologies.
Understanding of data governance, security, compliance, and data quality management practices.
Experience within Financial Services, Banking, or other highly regulated industries.
Familiarity with Tableau, Power BI, or other analytics and visualization platforms.
Experience using AI-powered development and productivity tools to improve engineering efficiency and delivery outcomes.
AWS Certified Cloud Practitioner, AWS Certified Developer – Associate, AWS Certified Data Engineer – Associate, SnowPro Core Certification, or equivalent cloud and data platform certifications.
#LI-DNI
This job posting is expected to remain active for 45 days from the initial posting date listed above. If it is necessary to extend this deadline, the posting will remain active as appropriate. Job postings may come down early due to business need or a high volume of applicants.
If hired in North Carolina, the base pay for this position is generally between $86,625 and $100,000. Actual starting base pay will be determined based on skills, experience, location, and other non-discriminatory factors permitted by law. For some roles, total compensation may also include variable incentives, bonuses, benefits, and/or other awards as outlined in the offer of employment.
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.
