Zortech Solutions
Snowflake Engineer with Pyhton, SQL and PySpark exp - US
Zortech Solutions, Charlotte, North Carolina, United States, 28245
Role:
Snowflake Engineer with Python, SQL and PySpark experienceLocation:
Charlotte, NC - Hybrid 3 days to office - Must be local or ready to relocateDuration:
6+ MonthsJob DescriptionThis position is for a Cloud Data / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.Major ResponsibilitiesExperience designing and developing Enterprise Data Warehouse solutions.Demonstrated proficiency with Data Analytics and Data Insights.Proficient in writing SQL queries and programming including stored procedures and reverse engineering existing processes.Leverage SQL, programming languages (Python or similar), and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.Perform code reviews to ensure fit to requirements, optimal execution patterns, and adherence to established standards.Skills10+ years - Enterprise Data Management10+ years - SQL Server based development of large datasets5+ years with Data Warehouse Architecture, Snowflake experience preferred3+ years' experience in Finance / Banking industry with some understanding of Securities and Banking products and their data footprints.2+ years Python coding experienceExperience with PySpark (good to have, should understand the architecture)Proficient with Data Visualization toolsHands-on experience with Snowflake utilities such as SnowSQL and SnowPipeWorking knowledge of MS Azure configuration items with respect to SnowflakeHands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharingExperience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modelingPrevious experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skillsCapable of discussing enterprise level services independent of technology stackExperience with Cloud based data architectures, messaging, and analyticsSuperior communication skillsCloud certification(s)Any experience with Regulatory Reporting is a PlusEducationMinimally a BA degree within an engineering and/or computer science disciplineMaster's degree strongly preferred
#J-18808-Ljbffr
Snowflake Engineer with Python, SQL and PySpark experienceLocation:
Charlotte, NC - Hybrid 3 days to office - Must be local or ready to relocateDuration:
6+ MonthsJob DescriptionThis position is for a Cloud Data / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.Major ResponsibilitiesExperience designing and developing Enterprise Data Warehouse solutions.Demonstrated proficiency with Data Analytics and Data Insights.Proficient in writing SQL queries and programming including stored procedures and reverse engineering existing processes.Leverage SQL, programming languages (Python or similar), and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.Perform code reviews to ensure fit to requirements, optimal execution patterns, and adherence to established standards.Skills10+ years - Enterprise Data Management10+ years - SQL Server based development of large datasets5+ years with Data Warehouse Architecture, Snowflake experience preferred3+ years' experience in Finance / Banking industry with some understanding of Securities and Banking products and their data footprints.2+ years Python coding experienceExperience with PySpark (good to have, should understand the architecture)Proficient with Data Visualization toolsHands-on experience with Snowflake utilities such as SnowSQL and SnowPipeWorking knowledge of MS Azure configuration items with respect to SnowflakeHands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharingExperience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modelingPrevious experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skillsCapable of discussing enterprise level services independent of technology stackExperience with Cloud based data architectures, messaging, and analyticsSuperior communication skillsCloud certification(s)Any experience with Regulatory Reporting is a PlusEducationMinimally a BA degree within an engineering and/or computer science disciplineMaster's degree strongly preferred
#J-18808-Ljbffr