Data Security Architect

TEKsystems - Orlando, FL

Full-time - Mid Level

Orlando, FL

Professional, Scientific, and Technical Services

About the position

The Data Security Architect role is focused on creating a unified data architecture for a major manufacturing company, integrating data from over 37 ERP systems and 100 home-grown systems into a single source of truth using a Snowflake environment. This position requires collaboration with CyberSecurity teams to balance the CEO's goals of data democratization and transparency with the need for stringent security measures. The architect will provide expertise and guidance to navigate these challenges effectively.

Responsibilities

• Verify and validate other developers' code according to established patterns.
• Check development quality and ensure the development process is applied as expected.
• Provide day-to-day business support, addressing questions and incidents.
• Develop code in Informatica and Snowflake following established patterns.
• Enhance and improve generic patterns as necessary.
• Create technical designs for Informatica developments and provide estimates.
• Analyze existing code bases to understand business logic and identify errors or problems.

Requirements

• Experience with Snowflake and JavaScript stored procedures.
• Advanced SQL skills and ability to write complex queries.
• Proficiency in Informatica PowerCenter development.
• Ability to create technical designs for Informatica developments and provide estimates.
• Experience in verifying and validating code according to established patterns.

Nice-to-haves

• Experience with OBIEE design and development.