Montreal Oficial

Senior Data Architect

Montreal Oficial

full-time

Posted on:

Location Type: Hybrid

Location: São PauloBrazil

Visit company website

Explore more

AI Apply
Apply

Job Level

About the role

  • Participate in SAFe ceremonies as an Architect (PI Planning, System Demo, etc.)
  • Guide development teams on database-related processes
  • Review systems' data architecture
  • Review and assist with data modeling and propose improvements
  • Review and assist in the development of data processing jobs
  • Review and assist in preparing systems for ETL processes
  • Assess the data maturity of systems with respect to:
  • Adherence to naming standards
  • Table partitioning
  • Index creation
  • Primary and foreign keys
  • Data masking
  • Data purging
  • Among others

Requirements

  • Data Modeling (logical, conceptual and physical models)
  • Dimensional modeling and ETL
  • RDBMS: Microsoft SQL Server and Oracle
  • Data Quality
  • Agile Methodologies
  • Database security and performance best practices
  • SQL
  • Best practices for index usage and table partitioning
  • SAFe framework
  • DataOps
  • Data management and governance
  • Data lifecycle management
  • Non-relational and Big Data technologies (Elasticsearch, Hive, Impala, HBase)
Benefits
  • Health insurance
  • Dental plan
  • Life insurance
  • Childcare assistance
  • Transportation allowance
  • Meal allowance
  • Wellhub (Gympass)
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Data ModelingDimensional modelingETLRDBMSMicrosoft SQL ServerOracleSQLDataOpsNon-relational technologiesBig Data technologies
Soft Skills
GuidanceReviewingAssessment