Job Title: Snowflake Data Engineer/Business Analyst
Location: Niskayuna, NY – 5 days onsite
Type: Contract
Responsibilities:
• Work with the business to understand functional requirements and transform into technical solutions within Snowflake
• Lead Project for the Enterprise Reporting & Analytics team to build out reports for the business leveraging data from various sources
• Work within a project management methodology
• Must be comfortable talking and engaging with the business teams to understand their current as is and to be processes
Technical Requirements:
• Candidates should have at least 8-10 years of experience in data engineering / data warehousing
• Must be both strong in understanding business processes and able to work technically within Snowflake
• Experience working with data within the manufacturing industry (Manufacturing, supply chain, finance, procurement, etc.)
• SQL & SnowSQL: Expertise in writing, optimizing, and troubleshooting SQL queries in Snowflake.
• Stored Procedures & UDFs: Experience in developing and maintaining stored procedures and user-defined functions (UDFs).
• ELT Development: Ability to design and implement ELT pipelines using Tasks, Streams, Dynamic Tables, Views, and other table types in Snowflake or external tools.
• Data Modeling: Proficiency in dimensional modeling (Star, Snowflake, etc.), SCD types, and Snowflake best practices.
• Security & Access Control: Knowledge of Snowflake roles, privileges, and Role-Based Access Control (RBAC).
• API & External Connectivity: Experience integrating Snowflake with various data sources and third-party tools.
• Scripting & Automation: Proficiency in Python, Java, or JavaScript for automation and orchestration.
• Integration & Orchestration: Experience with tools such as Alteryx, DBT, Airflow, Kafka, Talend, or Informatica.
Extra (Not required, but nice to have)
• Knowledge with building reports from SAP Data
• Tableau Development
All your information will be kept confidential according to EEO guidelines.
...can serve as replicable models for other capital providers. Job Overview NYSERDA seeks a self-motivated and knowledgeable Internal Auditor II with more than seven years of audit experience, including meaningful exposure to investment fund operations. This role will...
...Meat and Produce products. Temps range from 10 ( Freezer) to 46 degrees (including a banana and avocado ripening room!) Base Pay: $21.50 an hour PLUS Incentives: $200 8 Week training completion bonus! $1000 milestone bonus! $500 @ 6 and 12 months $800 a month potential...
" Licensed Psychiatric Nurse Practitioner Wage: Between $148-$203 an hour Did you know that you can build a flexible private practice on your terms as a psychiatric nurse practitioner?Whether you want to see patients alongside a full-time job or grow a full-time...
...International School is committed to providing children with English-Chinese bilingual education in a Montessori environment. Our emphasis... ...have many positions available that offer upward mobility for teachers who want to be administrators and or business development...
...Description SUMMARY OF POSITION The Triage Nurse is an essential role responsible for providing high-quality, evidence-based telephonic and virtual nursing assessment, triage, and... ...support continuity of care. A portion of work may be performed remotely, in accordance...