Role: Snowflake Engineer with Python, SQL and PySpark experience
Location: Charlotte, NC - Hybrid 3 days to office - Must be local or ready to relocate
Duration: 6+ Months
Job Description
This 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 Responsibilities
- Experience 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.
Skills
- 10+ years - Enterprise Data Management
- 10+ years - SQL Server based development of large datasets
- 5+ years with Data Warehouse Architecture, Snowflake experience preferred
- 3+ years' experience in Finance / Banking industry with some understanding of Securities and Banking products and their data footprints.
- 2+ years Python coding experience
- Experience with PySpark (good to have, should understand the architecture)
- Proficient with Data Visualization tools
- Hands-on experience with Snowflake utilities such as SnowSQL and SnowPipe
- Working knowledge of MS Azure configuration items with respect to Snowflake
- Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
- Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling
- Previous experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skills
- Capable of discussing enterprise level services independent of technology stack
- Experience with Cloud based data architectures, messaging, and analytics
- Superior communication skills
- Cloud certification(s)
- Any experience with Regulatory Reporting is a Plus
Education
Minimally a BA degree within an engineering and/or computer science discipline
Master's degree strongly preferred
Similar Jobs
- View Job
Snowflake Engineer with Pyhton, SQL and PySpark exp - US
Charlotte - View Job
Software Engineer (Python & PySpark)
Charlotte - View Job
Sr Software Engineer, Snowflake focus
Charlotte - View Job
DA with SQL, Alteryx and Counterparty/Client Experience
Charlotte - View Job
Software Engineer (.NET/SQL)
Charlotte