Sr.Specialist / Expert, Data Warehouse Security Analyst

Colgate; Ajax; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

An established industry player is seeking a Sr. Specialist / Expert Data Warehouse Security Analyst to join their innovative team. This role involves managing security compliance across cloud data warehousing tools like Snowflake and BigQuery, focusing on enhancing data security measures and Role Based Access Control (RBAC). If you're passionate about cybersecurity and want to make a significant impact in a global company, this position offers a unique opportunity to collaborate with cross-functional teams and drive improvements in data protection strategies. Join a forward-thinking organization that values innovation and sustainability in its mission.

Qualifications

• 5+ years IT experience with 3+ years in Data Security.
• Strong knowledge of database security and cloud environments.

Responsibilities

• Manage security compliance across cloud data warehousing tools.
• Identify risks and vulnerabilities to prevent cyber attacks.

Skills

Data Security

Database Management

Data Modeling

Communication Skills

Interpersonal Skills

Risk Assessment

Cybersecurity

Scripting (Bash, Python)

Education

Bachelor's in Computer Science

Master's in Management Information Systems

Tools

Snowflake

BigQuery

AWS

GCP

Docker

Kubernetes

Job description

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under internationally recognized brand names such as Colgate, Palmolive, Softsoap, Irish Spring, and more.

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care, and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable.

Job Title: Sr. Specialist / Expert, Data Warehouse Security Analyst

Travel Required?: Travel - up to 10% of time

Date: Jan 24, 2025

Hybrid

Relocation Assistance Offered Within Country
#162866 - Mumbai, Maharashtra, India

Who We Are
Colgate-Palmolive Company is a caring, innovative growth company focused on Oral Care, Personal Care, Home Care, and Pet Nutrition.

Do you want to be part of a team that is building a future to smile about? If this is how you see your career, Colgate is the place to be!

The Experience:

As a Data Warehouse Security Analyst, you will be responsible for managing and maintaining security compliances across cloud data warehousing tools like Snowflake and BigQuery.

This position will help drive improvements in security, maintainability, and scalability of our application’s data security as well as Role Based Access Control (RBAC) management within our Enterprise Architecture.

Who are you…

You are a Data Warehouse Security Analyst -

1. Plan, implement and maintain data security measures
2. Identify risk and vulnerabilities in data warehousing tools to prevent cyber attacks
3. Guard sensitive data and determine how best to protect that data from unauthorized entities
4. Understand data encryption and methods to apply it
5. Handle PII data and apply security measures around it
6. Research attempted breaches of data security and rectify security weaknesses
7. Manage, maintain, and improvise RBAC within data warehouse tools
8. Collaborate with cross-functional teams to assess data protection requirements
9. Evaluate and promote processes, tools, and technologies that enhance data warehouse security
10. Develop and maintain design and solution documentation

You connect the dots -

1. Support day-to-day business requirements according to global SLA
2. Ensure the proper use of information technology project management methodology

You are a collaborator -

1. Collaborate with cross-functional teams & security teams
2. Mentor and coach junior developer resources

You are an innovator -

1. Conduct security analysis to improve system compliance
2. Stay updated with the latest technological advancements
3. Build expertise in diverse and emerging technologies related to data warehouse security

What you’ll need…(Required)

1. Bachelor’s or higher degree in Computer Science, Management Information Systems, or a related field.
2. 5+ years IT professional experience
3. 3+ years experience in Data Security
4. Good knowledge in data modeling and database design
5. Experience with managing database or data warehouse security
6. Working knowledge of databases and SQL
7. Experience working with cloud environments (e.g.- GCP, AWS)
8. Experience with automation via any scripting such as Bash or Python.
9. Good Communication and Interpersonal Skills

What you’ll need…(Preferred):

1. Experience working with cloud data warehousing (e.g.- Snowflake, BigQuery)
2. Experience with containerization technologies (e.g.- Docker, Kubernetes).
3. Project management

Our Commitment to Sustainability
With the Colgate brand in more homes than any other, we are presented with great opportunities and new challenges as we work to integrate sustainability into all aspects of our business.

Our Commitment to Diversity, Equity & Inclusion
Achieving our purpose starts with our people — ensuring our workforce represents the people and communities we serve.

Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to any characteristic protected by law.

Reasonable accommodation during the application process is available for persons with disabilities.

#LI-Hybrid