Snowflake Data Engineer

Job Title : Snowflake Data Engineer (DBT, a must; Informatica, a plus) Job ID: 112362 Position Type: Full-time Location: San Antonio / Plano, TX or Phoenix, AZ - Onsite Role/Responsibilities Strong hands‑on expertise in Snowflake-based cloud data warehousing and modern ELT development using dbt (Core or Cloud) Deep proficiency in advanced SQL, dimensional modeling (Kimball/Data Vault), incremental and snapshot strategies, performance tuning, and cost optimization in Snowflake. Develop and maintain dbt models on Snowflake. Build reliable, tested, and documented data transformation pipelines. Implement data quality checks, lineage, and governance standards. Optimize SQL queries and dbt models for performance and cost. Collaborate with data engineering, BI, analytics, and business teams. Support Git-based development, CI/CD, and deployment processes. Experience designing scalable, production‑grade ELT pipelines, implementing CI/CD for dbt, integrating orchestration tools, and enforcing data quality through automated testing and observability frameworks. Strong understanding of cloud platforms and security in Snowflake, version control (Git), and DevOps‑driven deployment practices is required. Demonstrated experience leading technical design reviews Required Skills Strong SQL and data modeling skills. Hands‑on experience with dbt Core or dbt Cloud. Experience working with Snowflake. Knowledge of ELT pipelines, testing, documentation, and version control. Understanding of analytics engineering and dimensional modeling. Pay and Benefits Pay Range Minimum: $95,000 per year Pay Range Maximum: $151,000 per year HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to View email address on click.appcast.io for investigation. Compensation and Benefits A candidate’s pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance‑based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need‑based leave with no designated number of leave days per year); and 10 paid holidays per year. How You’ll Grow At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your brilliance the best. Throughout your time with us, we offer transparent communication with senior‑level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best. #J-18808-Ljbffr HCLTech