Senior Data Engineer - ELT

First Citizens
Arizona, TX, United States
1 day ago
Apply on jobs.firstcitizens.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
4 years minimum
Working hours
Regular working hours

Tech stack

Application Programming Interfaces (APIs) Artificial Intelligence Amazon Web Services Amazon S3 Architectural Patterns ARM Architecture Automation of Tests Microsoft Azure Cloud Computing Cloud Database Cloud Engineering Code Review
+30 more
Databases Continuous Integration Information Engineering Data Infrastructure Data Masking Data Security Data Systems Database Development Amazon DynamoDB Github Monitoring of Systems Identity and Access Management Jinja (Template Engine) Python (Programming Language) Performance Tuning Role-Based Access Control SQL Stored Procedures SQL Databases Data Logging Data Ingestion Delivery Pipeline Snowflake Gitlab Build Management Semi-structured Data Qlikview AWS Fargate Splunk Data Pipelines Dynatrace

Job description

We are seeking a Senior Data Engineer with strong hands-on experience building and operating modern data pipelines in a cloud-based data platform. This role sits one level below the Lead Data Engineer and is focused on implementing, enhancing, and supporting data pipelines and platform capabilities under established architectural patterns.

Senior Data Engineers are expected to be daily hands-on contributors who can independently deliver complex pipeline components, partner effectively with Leads, and mentor junior engineers while continuing to grow toward platform ownership and technical leadership., Data Pipeline Development

  • Design and build data pipelines using established Medallion Architecture patterns (Bronze, Silver, Gold).
  • Implement batch and CDC-based ingestion pipelines from databases, files, and APIs.
  • Support pipeline reliability, scalability, performance, and cost optimization.

Data Ingestion & Integration

  • Develop and support ingestion pipelines using Qlik Replicate for snapshot and CDC patterns.
  • Implement ingestion processes for structured and semi-structured data.
  • Build and extend Python-based pipeline components following existing frameworks.

Transformation, Modeling & Testing

  • Develop dbt models using SQL and Jinja templating.
  • Implement and maintain automated tests for data quality, freshness, and schema validation.
  • Participate in CI/CD-based deployments of dbt transformations.

Snowflake Development & Governance

  • Implement Snowflake ingestion patterns using Snowpipe and Tasks.
  • Apply and support RBAC, dynamic masking, and tag-based access controls.
  • Develop stored procedures and support governed data access patterns.

Cloud Development

  • Develop and operate data workloads using AWS services such as S3, Lambda, ECS Fargate, Glue, DynamoDB, and IAM, or equivalent Azure services.
  • Collaborate with senior engineers on deployment pipelines, automation, and environment promotion.

Operational Excellence

  • Troubleshoot data pipeline issues and participate in production support.
  • Implement logging, monitoring, and alerting for pipelines and data processes.
  • Contribute to performance tuning and cost optimization efforts.

Collaboration & Mentorship

  • Mentor junior data engineers through code reviews and technical guidance.
  • Collaborate with Lead Data Engineers on design and implementation decisions.
  • Partner with stakeholders to translate requirements into technical solutions.

Requirements

Bachelor’s Degree and 4 years of experience in Data engineering, data technologies, cloud platforms, High School Diploma or GED and 8 years of experience in Data engineering, data technologies, cloud platforms, Qualified candidates will have proven, hands-on production experience with most of the following:

  • Building data pipelines using Medallion Architecture patterns
  • Data ingestion using Qlik Replicate (snapshot, CDC, batch)
  • Python development for data pipeline components
  • dbt Cloud modeling, testing, and SQL development
  • Snowflake ingestion and processing (Snowpipe, Tasks, Stored Procedures)
  • RBAC and data masking concepts in Snowflake
  • Cloud-native development on AWS or equivalent Azure platforms
  • Experience with CI/CD pipelines (GitLab, GitHub Actions, etc.)
  • Observability and monitoring tools such as Splunk or Dynatrace
  • Experience in regulated or governance-heavy environments
  • Snowflake AI development using Cortex CoCo
  • Relevant cloud or data platform certifications

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.firstcitizens.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

6:36 min

Funding open source through GitHub Accelerator and Sponsors

Stormy Peters · World Congress 2023

6:14 min

Structuring CI/CD pipelines with integrated security and quality checks

Christoph Ruggenthaler · LIVE

2:38 min

Establishing comprehensive monitoring and log management

Michael Eder +1 · LIVE

2:40 min

Using GitHub primitives for internal documentation and corporate operations

Kyle Daigle · Coffee With Developers

4:54 min

Implementing geographic salary tiers for compensation equity and fairness

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

Videos

See all

Related articles

See all