Snowflake Data Engineer

Snowflake EngineerMust have technical/functional skills:4 years of experience in Snowflake development5 years of hands-on experience with SQL in writing complex SQL queries and logic4 years of hands-on experience in using Talend (preferred), Informatica or any other ETL/ELT toolMust have some working knowledge or understanding of Python, dbt (Data Build Tool)Must be a hands-on, self-driven, and independent engineer who can work with limited supervision, manage priorities effectively, and deliver high-quality outcomes within agreed timelinesStrong understanding of dimensional data modeling, database design principles, data warehousing concepts, and SQL/NoSQL technologies is highly desiredRoles & responsibilities:Responsible for the development, maintenance, documentation, monitoring, and continuous improvement of existing data warehouse and ETL/ELT solutionsDevelop new data pipelines, onboard additional data sources, implement transformations, document and improve overall data delivery processesMonitor scheduled jobs, investigate failures, troubleshoot data issues, optimize processes, and implement sustainable fixes to support reliable operationsExperience with Shell scripting, Airflow, Git, CI/CD, and AWS or other cloud platforms, and consuming data from APIs, external data services are desirableExperience working with structured, semi-structured, and unstructured data sources is desirablePerform basic to intermediate data modeling and database design activities as requiredPerform detailed data analysis, ensure data accuracy, integrity, privacy, and compliance through quality control procedures and monitoring processesIdentify reusable components/AI/Automation opportunities and build them so that they can be reused by all the workstreamsPerform maintenance and upgrade releases of supported data systems, including periodic off-hours support as requiredPartner with business stakeholders, architects, analysts, and application teams to translate business requirements into scalable data solutions while following the architecture and development guidelines and principlesGeneric managerial skills, if any:Excellent communication skills and ability to effectively collaborate with team membersSalary range: $110,000 - $130,000 per yearTCS Employee Benefits Summary: Discretionary Annual Incentive. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. Family Support: Maternal & Parental Leaves. Insurance Options: Auto & Home Insurance, Identity Theft Protection. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement. Time Off: Vacation, Time Off, Sick Leave & Holidays. Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.Location: Blue Bell, PA