ElevationHR is seeking a ETL Developer/Senior Snowflake Developer for a leading financial services company, headquartered in Chicago, Illinois, that provides asset management, asset servicing, wealth management, and banking services.
The ideal candidate will have expertise in design and development in Snowflake on Azure, experience with ETL tools such as SnowSQL. We are searching for senior level candidates with 5+ years of relevant experience.
Job Title: ETL Developer (Senior Snowflake Developer)
Project Overview: We are seeking an experienced Snowflake Developer to enhance and support data ingest/egress integrations with our Financial Risk Mart Solution.
Contractor's Role: The role involves building and supporting Snowflake processes and collaborating with the current application development team to drive superior business value, enhance customer experience, and ensure compliance.
Responsibilities:
-
Design and develop ETL pipelines in and out of the data warehouse using a combination of Python and Snowflake SnowSQL.
-
Possess a deep understanding of relational as well as NoSQL data stores methods and approaches, including star and snowflake dimensional modeling.
-
Experience in designing and deploying virtual warehouses, schemas, views, and zero-copy clones in Snowflake cloud data warehouse.
-
Collaborate with data analysts to map documents and design/build IBM DataStage jobs according to requirements.
-
Participate in peer design reviews and provide recommendations.
-
Ensure runbooks are fully up-to-date and consistently improving efficiency through automation.
-
Hands-on experience with improving operational stability via automation, including auto-healing where possible. Raise design changes with SMEs and/or architects and identify opportunities for application/service managers.
-
Be available for some off-hours work as required by projects, operations, and on-shore team and stakeholder needs, such as during releases, testing, and/or critical bug resolutions.
Requirements:
-
Expertise in design/development in Snowflake on Azure.
-
Experience with ETL tools like SnowSQL, including design/development and implementing data ingestion and processing pipelines.
Skills Required:
-
Snowflake
-
SQL
-
Python
-
Data Analysis
-
Strong problem-solving skills
Preferred Skills:
-
Experience with Datastage ETL.
#ETL #SQL #ETLDeveloper #SnowflakeDeveloper #Snowflake #SnowSQL #DataAnalysis #Azure #Python #DatastageETL #TechJobs #FinancialServices #ChicagoJobs #RemoteJobs #CareerGrowth #TechInnovation #ITCareers #ElevationHR