Senior Data Architect - Hybrid

Mcafee; Waterloo; On-site; CAD 80,000 - 130,000; Full time

Job summary

Join a forward-thinking company as a Senior Data Architect, where your expertise in data modeling and ETL will drive innovative solutions on the Databricks platform. This remote role offers the chance to design and manage data architectures while ensuring compliance and security. Collaborate with talented data engineers and stewards to create robust data platforms that empower users. Enjoy a flexible work environment with a commitment to diversity and inclusion, alongside competitive benefits that support your well-being and professional growth. If you're passionate about data and eager to make an impact, this opportunity is perfect for you.

Benefits

Bonus Program

Pension and Retirement Plans

Medical, Dental and Vision Coverage

Paid Time Off

Paid Parental Leave

Support for Community Involvement

Qualifications

• 6+ years of experience in data engineering and ETL/ELT.
• Hands-on experience with data modeling tools and Databricks.

Responsibilities

• Design and organize data platforms, ensuring compliance and security.
• Collaborate with data teams on solution design and code reviews.

Skills

Data lakehouse modeling and design

ETL/ELT design

Dimensional and relational data modeling

Data warehouse design

Security and PII management

Databricks/Spark

Python/PySpark

Data modeling tools (Erwin, ER/Studio)

CI/CD pipelines

Git and version control

Tools

Databricks

Collibra

Agile methodologies

Job description

Senior Data Architect - Remote

We seek an analytical leader to join our Enterprise Data Platform team as a Senior Data Architect. As a McAfee’s enterprise data architecture team member, you will manage data platform architecture on the Databricks platform.

This role requires a deep understanding of:

• Data lakehouse modeling and design
• ETL/ELT design
• Dimensional and relational data modeling
• Data warehouse design
• Security and PII management

This is a Remote position located in Canada. We are only considering candidates located in Canada and are not providing relocation at this time.

About the role:

• Design and organize data platforms, including databases and data structures, data storage, access, loading, and pipeline design.
• Collaborate with data stewards and data engineers on solution design.
• Develop and maintain physical data models for the Databricks platform.
• Manage metadata in data catalog tools, such as Collibra.
• Ensure adherence to data curation standards and guidelines for medallion certification framework and required architecture.
• Ensure the platform and platform design meet required security and compliance guidelines, including PII management.
• Provide oversight to data curation teams, ingestion engineers and data engineers, including code review and data model design review to ensure adherence to standards and best practices.

About you:

• Bring 6+ years of experience in data engineering, data modeling, and ETL/ELT.
• Have experience as a senior engineer, including conducting code reviews.

Have hands-on experience with six or more of the following:

• Design and implementation of logical and physical data models.
• Data modeling tools, such as Erwin or ER/Studio.
• Databricks/Spark.
• Lakehouse architecture and medallion data organization.
• ETL/ELT development, monitoring, pipelining and orchestration.
• Python/PySpark, Scala or similar programming language.
• Data quality guidelines and testing frameworks.
• Creating technical design documents and data flow diagrams.
• CI/CD pipelines.
• Agile sprints.
• Git and version control.

Company Overview

McAfee is a leader in personal security for consumers. Focused on protecting people, not just devices, McAfee consumer solutions adapt to users’ needs in an always online world, empowering them to live securely through integrated, intuitive solutions that protect their families and communities with the right security at the right moment.

Company Benefits and Perks:

We work hard to embrace diversity and inclusion and encourage everyone at McAfee to bring their authentic selves to work every day. We offer a variety of social programs, flexible work hours and family-friendly benefits to all of our employees.

• Bonus Program
• Pension and Retirement Plans
• Medical, Dental and Vision Coverage
• Paid Time Off
• Paid Parental Leave
• Support for Community Involvement

We're serious about our commitment to diversity which is why McAfee prohibits discrimination based on race, color, religion, gender, national origin, age, disability, veteran status, marital status, pregnancy, gender expression or identity, sexual orientation or any other legally protected status.