Assistant Software Engineer Jobs in Cary, NC (NOW HIRING)

This position is HYBRID in Raleigh, NC 

We are seeking a Senior Software Engineer with strong experience of Cloud Technologies around Snowflake ecosystem. This role will involve building robust backend services, data integration pipelines, and user interfaces that drive real-time and batch data flows across cloud environments. Develops software and procedures that improve processing capabilities. Analyzes, codes, tests, and implements in coordination with management, associates, and end users. 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. 

The ideal candidate is a hands-on data engineer with expertise in cloud-based data platforms, data warehousing, ETL/ELT development, and modern data engineering practices. This individual will build and optimize scalable pipelines, integrations utilizing AWS Services, Snowflake, dbt, Python, SQL, and related technologies. 

You will work across the full stack—from APIs and data ingestion layers to orchestration logic and UI components—helping architect and build scalable, extensible platforms 

The successful candidate will thrive in a collaborative environment, possess strong problem-solving skills, and be passionate about building reliable, scalable, and high-quality data solutions. 

• Design, develop, and support scalable data pipelines, data warehouses, and cloud-based data solutions utilizing AWS Services, Snowflake, dbt, Python, SQL, and related technologies. 

• Develop and maintain ETL/ELT processes, data integrations, and transformation frameworks supporting operational, reporting, and analytical workloads. 

• Implement and enhance data quality controls, reconciliation processes, testing frameworks, and dbt tests to ensure trusted and reliable data assets. 

• Optimize data pipeline performance and operational efficiency through monitoring, alert investigation, automation, testing, CI/CD, dashboard development, and production support activities. 

• Develop monitoring dashboards and operational metrics to improve platform visibility, reliability, and incident response. 

• Support deployment automation, release validation, and environment promotion processes to improve delivery reliability and operational efficiency. 

• Collaborate with business and technology stakeholders to understand requirements and deliver scalable data solutions that support business objectives. 

• Contribute to engineering best practices through technical discussions, peer reviews, documentation, and continuous improvement initiatives across the data engineering team 
• Leverage AI-powered development and productivity tools to improve engineering efficiency, code quality, testing, and delivery outcomes. 

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

Technical Expertise: 

• Proficiency in AWS Services (e.g., EC2, S3, Lambda, RDS), Snowflake, dbt, Python and SQL 

• Hands-on experience with Apache Airflow 

• Frontend experience with React and RESTful API integration 

• Strong database skills (PostgreSQL, MSSQL, JSONB, data modeling) 

• Familiarity with containerization and orchestration (Docker, ECS, EKS, etc.) 

• Strong understanding of API development, cloud architecture, and DevOps practices 

• Strong knowledge of release and configuration management tools (e.g., Gitlab, Jenkins, Git, Azure DevOps). 

• Proficiency in SQL databases and experience with data migration/integration processes. 

Problem Solving & Communication: 

• Strong analytical skills toidentifyand resolve issues during the release process. 
• Excellent verbal and written communication skills to collaborate effectively with technical and non-technical stakeholders.

Preferred Qualifications 

• Advanced experience with cloud platforms such as AWS, Azure, or GCP. 

• Advanced experience with modern data warehousing and large-scale data processing technologies such as Snowflake, Spark, or equivalent platforms. 

• Advanced proficiency in Python and SQL. 

• Advanced experience developing and supporting ETL/ELT processes, data pipelines, and data integration solutions utilizing tools such as dbt, Apache Airflow, Astronomer or equivalent cloud-native data engineering technologies. 

• Experience with data modeling, data warehousing, and data engineering best practices. 

• Experience in designing, developing, and supporting scalable and reliable data engineering solutions in enterprise environments. 

• Experience collaborating with business and technology stakeholders to deliver data-driven solutions. 

• Strong analytical, problem-solving, and communication skills. 

Additional qualifications are a plus 

• Intermediate experience with Change Data Capture (CDC), streaming, and real-time data ingestion technologies such as Kafka, Amazon Kinesis, Apache Flink, Qlik Replicate, Snow pipe Streaming, or equivalent platforms. 

• Intermediate experience integrating data across cloud and on-premises environments. 

• Experience with Data Vault modeling and modern data warehousing methodologies. 

• Intermediate understanding of data governance, security, compliance, and data quality management practices. 

• Experience working within Financial Services, Banking, or other highly regulated industries. 

• Experience using AI-powered development and productivity tools to improve engineering efficiency and delivery outcomes. 

• AWS Certified Data Engineer – Associate, AWS Certified Developer – Associate, SnowPro Core Certification, SnowPro Advanced Data Engineer Certification, or equivalent cloud and data platform certifications. 

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.

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

Technical Expertise: 

• Proficiency in AWS Services (e.g., EC2, S3, Lambda, RDS), Snowflake, dbt, Python and SQL 

• Hands-on experience with Apache Airflow 

• Frontend experience with React and RESTful API integration 

• Strong database skills (PostgreSQL, MSSQL, JSONB, data modeling) 

• Familiarity with containerization and orchestration (Docker, ECS, EKS, etc.) 

• Strong understanding of API development, cloud architecture, and DevOps practices 

• Strong knowledge of release and configuration management tools (e.g., Gitlab, Jenkins, Git, Azure DevOps). 

• Proficiency in SQL databases and experience with data migration/integration processes. 

Problem Solving & Communication: 

• Strong analytical skills toidentifyand resolve issues during the release process. 
• Excellent verbal and written communication skills to collaborate effectively with technical and non-technical stakeholders.

Preferred Qualifications 

• Advanced experience with cloud platforms such as AWS, Azure, or GCP. 

• Advanced experience with modern data warehousing and large-scale data processing technologies such as Snowflake, Spark, or equivalent platforms. 

• Advanced proficiency in Python and SQL. 

• Advanced experience developing and supporting ETL/ELT processes, data pipelines, and data integration solutions utilizing tools such as dbt, Apache Airflow, Astronomer or equivalent cloud-native data engineering technologies. 

• Experience with data modeling, data warehousing, and data engineering best practices. 

• Experience in designing, developing, and supporting scalable and reliable data engineering solutions in enterprise environments. 

• Experience collaborating with business and technology stakeholders to deliver data-driven solutions. 

• Strong analytical, problem-solving, and communication skills. 

Additional qualifications are a plus 

• Intermediate experience with Change Data Capture (CDC), streaming, and real-time data ingestion technologies such as Kafka, Amazon Kinesis, Apache Flink, Qlik Replicate, Snow pipe Streaming, or equivalent platforms. 

• Intermediate experience integrating data across cloud and on-premises environments. 

• Experience with Data Vault modeling and modern data warehousing methodologies. 

• Intermediate understanding of data governance, security, compliance, and data quality management practices. 

• Experience working within Financial Services, Banking, or other highly regulated industries. 

• Experience using AI-powered development and productivity tools to improve engineering efficiency and delivery outcomes. 

• AWS Certified Data Engineer – Associate, AWS Certified Developer – Associate, SnowPro Core Certification, SnowPro Advanced Data Engineer Certification, or equivalent cloud and data platform certifications. 

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.