Position: Senior Data Engineer (AWS / Python / SQL / Snowflake)
Location: Charlotte, NC Remote
Duration: 12+ months
Visa: or citizens
What You'll Need to Have
10+ years of professional experience in Data Engineering
Strong Python development expertise with the ability to design, build, and optimize ingestion frameworks
Advanced SQL skills, including writing efficient and performant queries
Deep experience working with Snowflake, including administration, performance tuning, and cost optimization
Hands-on experience building scalable data ingestion pipelines
Data Platform & Integration
Experience with Informatica IDMC for data ingestion
Experience using Fivetran or similar ingestion tools (must be able to explain hands-on usage)
Experience replicating data from SQL Server or similar relational systems into Snowflake
Experience ingesting data from external APIs using Python
Cloud & Pipeline Orchestration
Experience working within AWS cloud environments
Experience using AWS Airflow for scheduling and orchestration
Familiarity with AWS CloudWatch for monitoring and debugging
Experience with CI/CD pipeline implementation and deployment strategies
Data Engineering Expertise
Strong understanding of ETL workflows and pipeline design
Expertise in performance tuning for pipelines and data warehouses
Knowledge of Snowflake scaling strategies (vertical vs. horizontal scaling)
Experience implementing data quality validation within ingestion pipelines
Experience documenting engineering solutions and maintaining technical documentation
Preferred / Nice to Have
Hands-on experience with Fivetran ingestion architecture
Experience with Lambda or additional AWS services
Experience improving existing ingestion frameworks and platform architecture
Important: The environment is AWS-based. This role does not use Azure or Hadoop-based ecosystems, and those backgrounds alone will not translate directly to this role.