Source description
About the role
ü Must be local to NYC and Central NJ – no relocations
ü In-person interview is a MUST
ü 100% Onsite
ü USC and GC Only
100% Onsite | In-person Interview | Must be local to NYC or Central NJ, and provide residency proof
Job Title: Azure Date Engineer with Snow Flake and SQL with
Work Location: 100% Onsite – NYC or Iselin, NJ 08830
Interview Mode: In-person Interview
Duration: 12 months
Visa: USC and GC Only
Client is seeking an experienced Data Engineer with a strong background in Snowflake and SQL . The ideal candidate will be responsible for developing, optimizing, and maintaining our Snowflake data warehouse environment to support financial data analysis and reporting needs. The role requires a deep knowledge of Snowflake's unique capabilities, as well as proficiency in advanced SQL techniques and a comprehensive understanding of financial data.
Required Skills and Experience
Must have financial client project experience
Must have good knowledge of financial industry standards , regulatory requirements , and data security protocols .
Proven 8+ years of experience in Snowflake data warehousing development
Strong expertise in SQL and SQL Query optimization
Strong knowledge of data warehousing concepts and best practices.
Good with Snowflake's architecture , features, and best practices.
Experience with Data modeling , ETL development , and data integration techniques.
Experience with Azure Data Factory ( ADF ) and other Azure Services.
Proficiency in Python and PySpark for data processing and automation.
Nice to have - relevant certifications such as the Snowflake SnowPro Core Certification.
Preferred Qualifications
-
Hands-on experience with cloud migration projects.
-
Experience in data governance, data security, and data quality management.
-
Ability to work independently, manage multiple tasks, and drive projects to completion
-
Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.
-
Key Responsibilities
-
Design, build, and maintain scalable and efficient Snowflake data warehouse solutions tailored for financial industry applications.
-
Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval.
-
Optimize Snowflake performance through effective data modeling, partitioning, and indexing strategies.
-
Collaborate with financial analysts and business stakeholders to understand data requirements and deliver precise reporting and analytical solutions.
-
Ensure data integrity and security within the Snowflake environment, complying with industry regulations and standards.
-
Manage data migration projects from legacy systems to Snowflake, ensuring minimal disruption to business operations.
-
Provide technical expertise and support for Snowflake to internal teams, including troubleshooting and resolving issues.
-
Stay up to date with Snowflake features and updates, continuously improving and expanding our data warehouse capabilities.
-
Develop and maintain documentation for Snowflake processes, systems, and procedures.
More at 3B Staffing