Senior Data Engineer - Qlik, DBT, Snowflake

This is a remote position that can only be hired in NC, AZ, TX.

This position is responsible for designing, implementing, and optimizing complex data solutions. This role leads the development of sophisticated data pipelines, warehouses, and analytics platforms in an agile environment while mentoring junior team members and collaborating with stakeholders to drive data-driven decision-making.

• Data Architecture and Strategy - Design and implement scalable, efficient data architectures. Lead the development of data strategy aligned with business objectives. Evaluate and integrate new technologies to enhance data capabilities
• Hands-on Data Pipeline Development - Implement complex data pipelines for real-time and batch processing. Optimize data flows for high-volume, high-velocity data environments. Develop advanced ETL processes for diverse data sources.
• Data Governance and Quality Management - Establish and enforce data governance policies and best practices. Implement data quality frameworks and monitoring systems. Ensure compliance with data regulations and standards
• Performance Optimization and Troubleshooting - Analyze and optimize system performance for large-scale data operations. Troubleshoot complex data issues and implement robust solutions
• Mentorship and Knowledge Sharing - Mentor junior data engineers and provide technical guidance. Contribute to the development of best practices and standards. Collaborate with cross-functional teams to drive data literacy
• Testing & Automation - Write unit test cases, validate the data integrity & consistency requirements, build automated data pipelines using GitLab, Github, CICD tools.
• Code Deployment & Release Management - Adopt release management processes to promote code deployment to various environments including production, disaster recovery, and support activities.

Bachelor's Degree and 4 years of experience in Data engineering, big data technologies, cloud platforms OR High School Diploma or GED and 8 years of experience in Data engineering, big data technologies, cloud platforms

Preferred Skills:

Technical/Business Skills:

• Strong hands-on experience in building robust metadata-driven, automated data pipeline solutions leveraging modern cloud-based data technologies, tools for large data platforms.
• Strong experience leveraging data security, governance methodologies meeting data compliance requirements.
• Strong hands-on experience building medallion architecture automated ELT data pipelines, snowpipe frameworks leveraging Qlik Replicate, DBT Cloud, snowflake with CICD.
• Strong hands-on experience building data pipelines, data integrity solutions across multiple data sources and targets like SQL Server, Oracle, Mainframe-DB2, files, Snowflake.
• Experience working with various structured & semi-structured data files - CSV, fixedwidth, JSON, XML, Excel, and mainframe VSAM.
• Experience using S3, Lambda, SQS, SNS, Glue, RDS AWS services.
• Excellent proficiency in Python, Pyspark, advanced SQL for ingestion frameworks and automation.
• Hands-on data orchestration experience using DBT cloud, Astronomer Airflow.
• Experience in implementing logging, monitoring, alerting, observability, performance tuning techniques.
• Implement and maintain sensitive data protection strategies - tokenization, snowflake data masking policies, dynamic & conditional masking, and rolebased masking rules.
• Strong experience designing, implementing RBAC, data access controls, adopting governance standards across Snowflake and supporting systems.
• Strong experience in adopting release management guidelines, code deployment to various environments, implementing disaster recovery strategies, leading production activities.
• Experience implementing schema drift detection and schema evolution patterns.
• Financial banking experience is a plus.
• Must have one or more certifications in the relevant technology fields.

Functional Skills:

• Team Player: Support peers, team, and department management.
• Communication: Excellent verbal, written, and interpersonal communication skills.
• Problem Solving: Excellent problem-solving skills, incident management, root cause analysis, and proactive solutions to improve quality.
• Partnership and Collaboration: Develop and maintain partnership with business and IT stakeholders
• Attention to Detail: Ensure accuracy and thoroughness in all tasks.

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.