← Back to jobs

Avance Consulting Logo
Tech Lead - Data Engineer

Avance Consulting

 

San Antonio,United States

Posted On: 1 day ago
Experience: 10+ years
Availability: Onsite
Openings: 2
Category: Tech Lead- Data Engineer
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

Lead the design, implementation, and optimization of enterprise-level data applications and ETL/ELT processes.

This role is on-site.

Responsibilities

  • Build, monitor, and optimize ETL and ELT processes using scalable data models.
  • Migrate existing on-premises solutions to cloud platforms such as AWS, Azure, or Snowflake.
  • Design and implement identity and access management features and authorization frameworks.
  • Solve system performance and scalability issues through query optimization and encryption security.
  • Own projects from start to finish, managing transactions using distributed data processing algorithms.

Required Skills

  • 10+ years of experience in data engineering and data warehousing.
  • Expertise in Snowflake modeling, including roles, databases, and schemas.
  • Advanced SQL skills with experience in query tuning and database performance measuring.
  • Proficiency with Snowflake, dbt, Informatica, or DataStage.
  • Strong knowledge of Python and Unix environments.
  • Hands-on experience with SQL Server and Unisys.
  • Deep understanding of data modeling, metadata management, and data dictionaries.
  • Experience managing data lakes and multi-dimensional models.
  • Proven ability to set up resource monitors and perform performance tuning.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs