ETL Lead

TechDigital Group; San Antonio (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

TechDigital Group in San Antonio, TX seeks a data engineer with strong Snowflake, DBT, and SQL skills to join our Texas-based team. The role focuses on building enterprise data platforms, migrating workloads to the cloud, and implementing robust data models.

You will work on IAM, data governance, performance tuning, and ETL/ELT pipelines, ensuring scalable, secure access and reliable analytics for business users.

Qualifications

• Proficiency in SQL and cloud-based data technologies.
• Strong knowledge of data warehousing concepts, data modeling, and metadata management.
• Experience with Snowflake modeling, roles, databases, and schemas.
• Experience migrating on-premises solutions to cloud-based Snowflake/AWS/Azure.

Responsibilities

• Create, test, and deploy enterprise Snowflake-based data solutions.
• Design IAM features and authorization frameworks for secure access.
• Optimize client queries and strengthen encryption for data at rest and in transit.
• Resolve performance and scalability issues across distributed data systems.
• Manage transactions and distributed data processing algorithms.
• Own projects from inception to delivery.
• Build, monitor, and optimize ETL/ELT processes with data models.
• Migrate on-premises solutions to cloud-based platforms.

Skills

DBT

Snowflake

SQL

Job description

Mandatory required skills

DBT, Snowflake, SQL

Detailed Job Description:-

• Knowledge of SQL language and cloud-based technologies
• Data warehousing concepts, data modeling, metadata management
• Data lakes, multi-dimensional models, data dictionaries
• Migration to AWS or Azure Snowflake platform
• Performance tuning and setting up resource monitors.
• Snowflake modeling - roles, databases, schemas
• SQL performance measuring, query tuning, and database tuning
• ETL tools with cloud-driven skills

Roles and Responsibilities:-

• Create, test, and implement enterprise-level apps with Snowflake.
• Design and implement features for identity and access management.
• Create authorization frameworks for better access control.
• Implement Client query optimization, major security competencies with encryption.
• Solve performance issues and scalability issues in the system.
• Transaction management with distributed data processing algorithms.
• Possess ownership right from start to finish.
• Build, monitor, and optimize ETL and ELT processes with data models.
• Migrate solutions from on-premises setup to cloud-based platforms.