Expoint - all jobs in one place

Finding the best job has never been easier

Limitless High-tech career opportunities - Expoint

Mcafee Senior Data Architect 
Canada, Ontario, Waterloo 
721504795

19.11.2024
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
About the role:
  • andorganize 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 andmaintainphysical data models for the Databricks platform.

  • Managemetadata 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 meet required security and compliance guidelines, including PII management.

  • Provide oversight todatacuration teams,ingestion engineersand data engineers, including code review and data model design review to ensure adherence to standards and best practices.


About you:
  • 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 withsix 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 architectureand medallion data organization.

  • ETL/ELT development, monitoring,pipeliningand orchestration.

  • Python/PySpark, Scala or similar programming language.

  • Data quality guidelinesand testing frameworks.

  • Creating technical design documents and data flow diagrams.

  • CI/CD pipelines.

  • Agile sprints.

  • Git and version control.

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