Snowflake Architect

Post Date

Jun 25, 2024

Location

Pittsburgh,
Pennsylvania

ZIP/Postal Code

15219
US
Sep 15, 2025 Insight Global

Job Type

Contract,Perm Possible

Category

Architect

Req #

PIT-714499

Pay Rate

$60 - $90 (hourly estimate)

Job Description

A financial services client in the Pittsburgh area is beginning a Cloud transformation journey and the Data team is seeking a Snowflake Architect to join in those efforts. This team is preparing the Snowflake instance in Azure in preparation for some core banking applications and their data to be migrated to this instance by July. This role will be a hands-on architecture role working alongside the existing team on this effort. The team today consists of a project manager, data architect, integration architect, data manager, and data analysts. While the team has a thorough understanding of where the environment is today and where they are going, they are looking to add in Snowflake expertise to drive the DW architecture and build. This is a very interactive role and project. Therefore, strong interpersonal skills and communication will be necessary for success.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

* Expertise in Snowflake Architecture, both in design and hands-on experience

* Designing DW solutions in the cloud

* Dimensional modeling

* Teamwork

* Communication

Nice to Have Skills & Experience

* Azure

* Oracle Snowflake transformations

* Informatica integration

* Cloud to cloud integration

* ETL

* VersionOne for project planning

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.