Senior Data Architect - Hybrid

McAfee GmbH; Waterloo; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is on the lookout for a Senior Data Architect to enhance their Enterprise Data Platform team. This hybrid role involves overseeing data platform architecture on the Databricks platform, focusing on data lakehouse modeling, ETL/ELT design, and ensuring compliance with security standards. The ideal candidate will bring over six years of experience in data engineering and modeling, collaborating closely with data teams to deliver robust solutions. If you're passionate about data architecture and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• 6+ years of experience in data engineering, data modeling, and ETL/ELT.
• Hands-on experience with data modeling tools and Databricks.
• Experience conducting code reviews as a senior engineer.

Responsibilities

• Design and organize data platforms, including databases and data structures.
• Collaborate with data stewards and engineers on solution design.
• Ensure adherence to data curation standards and guidelines.

Skills

Data lakehouse modeling and design

ETL/ELT design

Dimensional and relational data modeling

Data warehouse design

Security and PII management

Python/PySpark

Data quality guidelines

CI/CD pipelines

Git and version control

Agile sprints

Education

Bachelor's degree in Computer Science or related field

Tools

Databricks

Erwin

ER/Studio

Job description

Role Overview:

We are seeking a seasoned analytical leader to join our Enterprise Data Platform team as a Senior Data Architect, reporting to the Capability Lead – Data Architecture. As a member of McAfee’s enterprise data architecture team, 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 hybrid position based in either Waterloo or Toronto, Canada. You must be within a commutable distance to one of these two locations. You will be required to be onsite on an as-needed basis; when not working onsite, you will work remotely from your home location.

Job Description:

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 guidelinesfor medallion certification framework and required architecture.

• Ensure the platform and platform design meets 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 experienceas 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.

#LI-REMOTE

Accommodations:

McAfee recognizes and supports its obligation to reasonably accommodate applicants and employees with disabilities. We are here to help. Please let us know if you need a reasonable accommodation for any part of the application, interviewing, hiring, or at any other time during the employment process. Please do not include personal medical information in the email.

Diversity is foundational for our business success. We want to be a workplace of choice for all people and we value the unique perspectives offered by a diverse workforce. McAfee does not unlawfully discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, citizenship, disability, protected veteran status, age, ancestry, medical condition, genetic information, marital status, pregnancy, or any other legally protected status. This principle applies to all areas of employment: recruitment and hiring, training, performance evaluations, promotions and transfers, compensation and benefits, and social and recreational programs.

McAfee desires to be an employer of choice with an inclusive environment for all individuals. As part of this goal and in compliance with various laws and regulations, McAfee provides reasonable accommodation to applicants and employees. Requests for reasonable accommodation for applicants and employees are evaluated on a case-by-case basis.

Posting Statement:

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.