Highbrow LLC
Technical Lead – Snowflake
Highbrow LLC, Berkeley Heights, New Jersey, us, 07922
Job Title: Technical Lead – Snowflake
Job ID: 2023-12286
Job Location: Alpharetta, GA or Berkeley Heights, NJ
Job Travel Location(s):
# Positions: 1
Employment Type: W2
Candidate Constraints:
Duration: Long Term
# of Layers:0
Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers
Key Technology:Snowflake, MOVEit, Data Warehouse
Job Responsibilities:
Provide hands-on technical leadership to the agile project team tasked with migrating MOVEit jobs to Snowflake.
Implement codified and repeatable migration patterns for different complexity Jobs from MOVEit to Snowflake. Extract, transform, and load logic to automate data collection and manage data processes/pipelines including data quality and monitoring
Design and build the migration factory with codified scripts and common plugins for accelerating/automating migration of jobs.
Performs problem analysis for migration of complex configurations from MOVEit to Snowflake.
Performs complex installation, configuration, customization and tuning. Provides input on answers to technical questions and problems while adhering to standards and procedures.
Assists in strategic planning and architecture and design. Makes recommendations on functional and business requirements.
Participates in projec
Skills and Experience Required:
Required:
5+ years of Data Architecture/Data Warehousing experience
Expert knowledge of Snowflake with more than three (3) years of hands-on experience with Snowflake
Exposure to Data warehousing and various ingestion patterns from multiple sources.
Good hands-on experience in Snowflake migration projects with good understanding of Snowflake architecture and building pipelines for ingestion
Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures and standard DWH and ETL concepts
Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel and understand how to use these features
Experience in Data Migration to Snowflake cloud data warehouse
Hands-on expertise with SQL and SQL analytics
Experience or strong knowledge of communication and data handling protocols (AS2, PGP/GPG, S/MIME, HTTPS, FTPS/SFTP/SCP/OFTP, POP3/SMTP, Web Services/SOAP/REST, WebDAV, etc.)
Experience or strong knowledge of industry data standards (ACH, ANSI X12, EDIFACT, HIPAA, RosettaNet, SWIFT, TRADCOMS, etc.)
Experience with .Net/Java based frameworks and solutions.
Demonstrated experience with enterprise database technologies like Oracle RAC, DB2, and MS SQL Server Enterprise
Solid understanding of networking concepts, firewalls and security standards.
Experience working in financial services industry preferred.
Education:
Bachelor ‘s Degree or higher in Computer Science, or related field.
#J-18808-Ljbffr
Job ID: 2023-12286
Job Location: Alpharetta, GA or Berkeley Heights, NJ
Job Travel Location(s):
# Positions: 1
Employment Type: W2
Candidate Constraints:
Duration: Long Term
# of Layers:0
Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers
Key Technology:Snowflake, MOVEit, Data Warehouse
Job Responsibilities:
Provide hands-on technical leadership to the agile project team tasked with migrating MOVEit jobs to Snowflake.
Implement codified and repeatable migration patterns for different complexity Jobs from MOVEit to Snowflake. Extract, transform, and load logic to automate data collection and manage data processes/pipelines including data quality and monitoring
Design and build the migration factory with codified scripts and common plugins for accelerating/automating migration of jobs.
Performs problem analysis for migration of complex configurations from MOVEit to Snowflake.
Performs complex installation, configuration, customization and tuning. Provides input on answers to technical questions and problems while adhering to standards and procedures.
Assists in strategic planning and architecture and design. Makes recommendations on functional and business requirements.
Participates in projec
Skills and Experience Required:
Required:
5+ years of Data Architecture/Data Warehousing experience
Expert knowledge of Snowflake with more than three (3) years of hands-on experience with Snowflake
Exposure to Data warehousing and various ingestion patterns from multiple sources.
Good hands-on experience in Snowflake migration projects with good understanding of Snowflake architecture and building pipelines for ingestion
Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures and standard DWH and ETL concepts
Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel and understand how to use these features
Experience in Data Migration to Snowflake cloud data warehouse
Hands-on expertise with SQL and SQL analytics
Experience or strong knowledge of communication and data handling protocols (AS2, PGP/GPG, S/MIME, HTTPS, FTPS/SFTP/SCP/OFTP, POP3/SMTP, Web Services/SOAP/REST, WebDAV, etc.)
Experience or strong knowledge of industry data standards (ACH, ANSI X12, EDIFACT, HIPAA, RosettaNet, SWIFT, TRADCOMS, etc.)
Experience with .Net/Java based frameworks and solutions.
Demonstrated experience with enterprise database technologies like Oracle RAC, DB2, and MS SQL Server Enterprise
Solid understanding of networking concepts, firewalls and security standards.
Experience working in financial services industry preferred.
Education:
Bachelor ‘s Degree or higher in Computer Science, or related field.
#J-18808-Ljbffr