Sr Snowflake Data Engineer

Job Title: Sr Snowflake Data Engineer

Location: Austin, TX

Position Type: Full-time

Work Type: Onsite

Salary: Base salary range around 90k to 135k + relocation expenses & client approved benefits. 

 

 

• Expert level fluency with Snowflake, SQL, Tableau, and Python is required.

• Experience with data modeling in Snowflake, performance tuning the queries and optimization.

• Computational analysis using Snowflake, mySQL, Python, Tableau and Business Objects.

• Experience with building Cloud Native applications using AWS.

 

• Hands-on experience with ETL and Dimensional Data Modelling – Slowly Changing Dimensions (SCD – Type 1, 2, 3).

• Proficiency in Python scripting/programming – using Pandas, PyParsing, Airflow.

• Design, develop, and maintain data pipelines and architectures to support analytical needs.

• Excellent communication and presentation skills.

• Hands-on experience with writing Complex queries using – Joins, Self Joins, Views, Materialized Views, Cursor also Recursive, use of GROUP BY, PARTITION BY functions.

• Proficiency in Pandas, Tableau server modules, Numpy, Datetime, Apache Airflow related modules, APIs.

• Experience with SnowSQL, Snowpipe.

• Experience with Snowflake performance optimization techniques.

• Own project delivery collaborating with Offshore.

• Ability to bridge the gap between business needs and technical capabilities.

• Translating complex analytical requirements into actionable data solutions and automation across tools and platforms.

• Create and maintain reports, create and manage data models, leverage data across complex hierarchies using multiple data sources.

• Actively participating in discussions with business to understand requirements and provide suitable solutions.

Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek’s diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.

Ztek is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Ztek is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at "To apply, click the Monster apply button" Please indicate the specifics of the assistance needed. Ztek encourages all interested and qualified candidates to apply for employment opportunities. Ztek does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. 1324b.