What are the responsibilities and job description for the Sr. Engineer (Snowflake) position at KE Staffing?
Design, develop, and maintain scalable data pipelines using DBT, Snowflake, and Azure services. - Build and optimize ELT/ETL workflows for data ingestion, transformation, and integration from multiple source systems.
Develop and maintain data models, marts, and semantic layers using DBT best practices.
Implement robust data warehousing solutions in Snowflake, ensuring high performance and scalability. - Optimize Snowflake objects, queries, warehouses, clustering, and storage utilization.
Establish data quality frameworks, testing strategies, and monitoring using DBT tests and custom validation mechanisms.
Utilize Azure services such as Azure Data Factory (ADF), Azure Synapse Analytics, Azure Databricks, and Azure Storage.
Implement CI/CD pipelines and DevOps practices for data engineering deployments.
Collaborate with business stakeholders, data analysts, architects, and development teams to gather requirements and deliver data solutions. - Ensure adherence to security, governance, compliance, and data management standards.
Troubleshoot production issues and provide performance tuning recommendations.
Mentor junior engineers and contribute to data engineering best practices.
Experience working in Agile methodologies and Scrum teams.
Strong SQL development and query optimization skills.
Experience designing and implementing dimensional data models.
Knowledge of data governance and data quality frameworks