Snowflake Data EngineerBusiness AnalystIndependent Consultants onlyW2
Share
Job Location:
Niskayuna, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
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
Additional Information :
All your information will be kept confidential according to EEO guidelines.
Remote Work :
No
Employment Type :
Contract
Key Skills
- Cyber Security
- Business Administration
- LTE
- Content Management
- Archicad
About Company
MSRcosmos is an IT Services subsidiary of the MSRcosmos Group, A U.S.-based multinational conglomerate. MSRcosmos Group focused on diverse ventures ranging from IT services to real estate and education. Together, both companies believe that business success and serving humanity are sy ... View more
