Job Description
Snowflake technical lead
Job Summary
-
Location: Texas
-
Project role: Snowflake technical lead
-
Skills: Snowflake
- Secondary Skills:
- DBT
- Python
- SQL
- CA Erwin Data Modeler
- AWS Architecture
-
No. of positions: 2
-
Pay Range Minimum: $62000
-
Pay Range Maximum: $127600
Job description:
Work Location: San Antonio, Texas
No. of Positions: 2
Job Title/Role: Lead Data Modeler
Mandatory skills: Erwin, RDBMS
Job Description:
- Lead the design and optimization of data models for large-scale enterprise applications
- Develop and maintain logical and physical data models for application projects
- Expert in logical, physical, and dimensional data modeling
- Analyze application data requirements and translate them into efficient data models
- Collaborate with ETL and reporting teams to ensure data models support analytics needs
- Define and maintain data dictionaries, metadata, and modeling standards.
- Lead data modeling initiatives for strategic application development projects
- Define and enforce data modeling best practices and standards
- Collaborate with enterprise architects and business stakeholders on data strategy
- Ensure data models align with data governance, security, and compliance standards
- Strong experience in data modeling tools (e.g., ER/Studio, Erwin, or Power Designer).
Qualifications: - Deep experience in data architecture, strong analytical skills, and the ability to translate complex business requirements into robust data models .
- Strong background in data warehousing and data lakes
- Experience with cloud platforms (AWS, Azure, or GCP) and modern data architecture.
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.
Disclaimer
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 secure@hcltech.com for investigation.