Snowflake Architect

Company Description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Title : Snowflake Architect

Location: ERIE PA – Onsite

Long Term

Job Overview:

We are seeking an experienced Snowflake Tech Lead/Architect to join our team. The ideal candidate will have a solid background in data architecture, cloud data warehousing, and analytics. As a Snowflake Tech Lead, you will be responsible for leading the design, development, and implementation of data solutions using Snowflake. You will collaborate closely with cross-functional teams to ensure data solutions are accurate, accessible, and secure.

Key Responsibilities:

• Lead the design and implementation of Snowflake solutions to meet business requirements.
• Collaborate with business stakeholders, data engineers, and analysts to gather requirements, ensuring data quality and integrity.
• Lead the development and maintenance of data models and pipelines using Snowflake.
• Manage diverse data sets (XML, JSON, CSV) from disparate sources.
• Optimize Snowflake performance, including query tuning and storage optimization.
• Manage and mentor a team of data professionals in Snowflake best practices.
• Develop and maintain ETL processes to integrate data from various sources.
• Monitor and troubleshoot data issues and implement solutions.
• Research and develop POCs to demonstrate business capabilities using Snowflake.
• Working with global team (onsite & offshore model) and guiding both shores to successfully drive the project/program.
• Stay updated with industry trends and advancements in Snowflake and related technologies.

Qualifications:

• 15+ years of experience in data engineering, data warehousing, or related roles.
• Strong expertise in Snowflake architecture, SQL, and data modeling.
• Experience with ETL tools (Informatica) and data integration methodologies.
• Solid understanding of data warehousing concepts, metadata management, data lakes, and multi-dimensional models.
• Familiarity with AWS cloud platforms and data pipeline orchestration tools (e.g., Apache Airflow).
• Excellent problem-solving skills and attention to detail.
• Strong communication and leadership skills, with the ability to work collaboratively across teams.

Preferred Qualifications:

• Snowflake (SnowPro Core or higher) & AWS Cloud certification (CCP or higher)
• Experience with data visualization tools (e.g., Qlik, SAS) is an advantage.
• Knowledge of programming languages such as Python, Java, or Scala.
• Having experience in insurance domain is an advantage.
• Experience in Agile/Scrum methodologies.

Regards,

Manoj

Derex Technologies INC

Contact : 973-834-5005 Ext 206

Additional Information

All your information will be kept confidential according to EEO guidelines.