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.
Top Skills
What We Do
DEREX Technologies, Inc. established in 1996 is engaged nationally in providing professional computer services, including management consulting firm. We provide expert services nationwide to Fortune 500 companies and other private and public organizations in the United States. Derex provides a multi-faceted portfolio of products and services to its clients, including complete IT solutions.
