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.
...Hiring Immediately for Warehouse Packer Jobs in McDonough, GA: Inergroup is hiring immediately for Warehouse Packer jobs in McDonough... ...available Skills and Qualifications: No prior warehouse experience is required; we welcome entry-level candidates. Ability to...
...VP, Creative Director (Art) Looking for something fresh? Day One Agency is hiring. Day One is a creative agency committed to bringing fresh thinking to our work. Every. Single. Day. For us, every day is day one, a new opportunity to start from the beginning, find a...
...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...