Snowflake Senior Technical Specialist

HCL Technologies Limited; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

HCL Technologies Limited is seeking a Snowflake Senior Technical Specialist to deliver scalable data solutions and lead project execution, with strong delivery experience across Capital Markets corporate functions, securities, and front-to-back-office.

You will design, develop, and optimize data pipelines using Snowflake, Python, and Oracle PL/SQL; mentor teams; engage with customers; and apply Generative AI to enhance analytics and automation.

Qualifications

• 7+ years of data engineering or analytics experience preferred.
• Hands-on Snowflake data modeling, optimization, and cost management.
• Strong Python scripting for data processing and automation.
• Expertise in Oracle PL/SQL with complex queries and tuning.
• Experience with enterprise BI/reporting tools and governance.

Responsibilities

• Design and implement scalable data solutions using Snowflake.
• Lead end-to-end project delivery with governance and risk management.
• Mentor team members and review designs.
• Collaborate with cross-functional teams and stakeholders.
• Apply Generative AI concepts to enhance data engineering workflows.

Skills

Snowflake

Oracle PL/SQL

Python

DBT

Informatica

BI reporting tools

Tools

DBT

Informatica

Job description

Career Opportunities: Snowflake Senior Technical Specialist (164769)

We are seeking an experienced professional with strong expertise in Informatica,Snowflake, Python, Oracle PL/SQL, and reporting/BI toolsto deliver scalable data solutions and lead project execution, with proven delivery experience acrossCapital Markets corporate functions, securities, and front-to-back-office.

Key Responsibilities

• Design, develop, and optimize data solutions using Snowflake, Python, and Oracle PL/SQL.
• Develop and maintain reports and dashboards using standard BI/reporting tools to support business decision-making.
• Lead end-to-end project deliverables, ensuring quality, timeliness, and alignment with customer requirements.
• Drive and manage weekly and monthly governance calls, including status reporting, risk management, and stakeholder communication.
• Ensure all project tasks and milestones are completed on time with high-quality standards.
• Provide technical leadership and mentorship to the team, reviewing designs and code to ensure best practices.
• Engage directly with customers to understand business needs, translate them into technical solutions, and manage ongoing interactions.
• Collaborate with cross-functional teams to ensure smooth delivery and adoption of solutions.
• Apply Generative AI concepts and tools where relevant to enhance data engineering, analytics, automation, and productivity use cases.
• Continuously identify opportunities for process improvement, automation, and innovation.

Skill Requirements

• Technical: Snowflake, Oracle Pl/SQL, DBT, Python, Informatica, any BI reporting tool knowldge
• Strong hands-on experience with Snowflake, including data modeling, performance optimization, and cost management.
• Advanced proficiency in Python for data processing, automation, and integration.
• Solid experience in Oracle PL/SQL, including complex queries, procedures, and performance tuning.
• Experience with at least one enterprise reporting or BI tool.
• Proven leadership skills with experience leading teams and owning project delivery.
• Strong customer interaction and stakeholder management skills.
• Experience driving governance forums and executive-level status reviews.
• Exposure to Generative AI, including use cases, tools, or solution implementation, is highly desirable.

This role requires a strong balance of technical depth, leadership capability, and customer-facing skills to successfully deliver high-impact data and analytics solutions.