What are the responsibilities and job description for the Data Engineer (Snowflake DBT) position at HMG AMERICA LLC?
Role - Data Engineer (Snowflake DBT)
Location - Frisco, TX (Hybrid , 3 days/ week)
Hiring Mode - Contracting
Must Have -
- Snowflake with DBT (Data Build tool)
Job Description:
We are looking for an experienced Senior Data Engineer to design, build, and optimize scalable data platforms. The ideal candidate will have strong expertise across data engineering fundamentals, particularly in Snowflake, dbt, SQL, and modern DevOps practices, and will play a key role in delivering high‑quality, analytics‑ready data.
Key Responsibilities
- Design, build, and maintain robust data pipelines and data warehouse solutions
- Apply strong data engineering, data warehousing, and ETL concepts to support analytics and reporting needs
- Develop and maintain dimensional and analytical data models following best practices
- Optimize Snowflake performance through effective warehouse design, clustering, query tuning, and cost optimization
- Lead and contribute to dbt development, including:
- dbt models and project design
- Data quality tests and validations
- Audit logging and monitoring
- Usage of dbt utils and advanced dbt features
- Write and optimize complex SQL queries for large‑scale datasets
- Implement and maintain DevOps and CI/CD pipelines for data workflows
- Ensure data reliability, consistency, and documentation across the data platform
- Collaborate cross‑functionally with analytics, engineering, and business teams
Mandatory Skills & Experience
- Strong understanding of data engineering, data warehousing, and ETL/ELT architectures
- Solid knowledge of data modelling concepts (dimensional, normalized, analytical models)
- Hands‑on experience with Snowflake, including performance optimization
- Extensive dbt development and design experience, including:
- dbt tests
- Audit loggin
- dbt utils and best practice
- Excellent SQL hands‑on experience
- Proven experience implementing DevOps practices and CI/CD pipelines for data platforms
Good to Have
- Experience with cloud platforms (AWS, Azure, or GCP)
- Familiarity with orchestration tools (e.g., Airflow)
- Exposure to data governance, observability, or monitoring tools
- Strong problem‑solving and stakeholder communication skills