Job Summary
We are seeking a skilled Snowflake Administrator to join our team in Pittsburgh, PA. The ideal candidate will have experience managing Snowflake environments, optimizing queries, and ensuring secure authentication methods. While SnowPro Core or SnowPro Advanced Administrator certifications are not required, candidates should have at least one.
Key Responsibilities
- Administer and maintain Snowflake environments, ensuring optimal performance and security.
- Implement and manage Snowflake authentication architectures, including Azure AD, SSO, Multifactor Authentication, and SiteMinder SSO.
- Optimize and tune SQL queries for improved performance.
- Work with cloud platforms, particularly Azure, with GCP experience as a plus.
- Develop automation scripts using Python for enhanced system efficiency.
- Support data governance and compliance best practices.
- Collaborate with cross-functional teams to integrate Snowflake with data pipelines and ETL tools.
Required Skills & Qualifications
- Strong proficiency in SQL and data warehousing concepts.
- In-depth understanding of Snowflake features and functionalities.
- Experience with cloud platforms, particularly Azure, with GCP as a plus.
- Knowledge of data integration tools and ETL processes.
- Familiarity with scripting languages like Python for automation.
- Experience with data governance and compliance best practices.
- Bonus: Experience with Azure AD B2C.
If you have a passion for database administration and cloud data solutions, we encourage you to apply.
Similar Jobs
What We Do
Techstra Solutions is a certified woman-owned consulting firm that provides strategy, technology and implementation support to large organizations undergoing digital and talent transformation. The rapid pace of technology innovation required to remain competitive, juxtaposed with the slow rate of change in many organizations, causes most to struggle.
To be successful companies must drive new ways of working including the use of technology/analytics and new skillsets (hard/soft) deep into their culture so that they are able to rapidly and continuously react to change. They must also apply new approaches that empower their employees, ensuring its sustainability.
At Techstra Solutions we focus on four key areas, otherwise known as the 4 A’s: Automation (Robotic Process Automation (RPA)/Intelligent Automation), Analytics (Reporting/Analytics/AI/ML), Application Modernization (Cloud, Mobility, etc), and Agile-based solutions (DevOps).
