Senior Data Solutions Architect - Hybrid

Role Overview:

We are seeking a seasoned analytical leader to join our Enterprise Data Platform team as Senior Data Solutions Architect, reporting to the Capability Lead of 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 deep understanding of Data lakehouse modeling and design, ETL/ELT design, Dimensional and relational data modeling, Data warehouse design and 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.

About the role:

• Gather and understand requirements from business stakeholders and data owners.

• Drive solution design, collaborating with data stewards, data engineers and other architects.

• Design and organize data platforms, including databases and data structures, access, streaming, loading and pipeline design.

• Develop and maintain physical data models for the Databricks platform.

• Manage metadata in data catalog tools, such as Unity Catalog.

• Ensure adherence to data curation standards and guidelines for 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:

• Are accomplished in requirements gathering, solution design, and guiding teams through implementation and delivery.

• Bring 8 + years of experience in data engineering, data modeling and ETL/ELT.

• Have experience as a senior engineer, including conducting code reviews.

• Have 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.

• Agile sprints.

• Git and source control.

#LI-Hybrid

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 protects 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.