Join Creative Tech

Data Administrator – Mid Level

Join Creative Tech

full-time

Posted on:

Location Type: Remote

Location: Brasil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

DynamoDBMongoDBPostgresPySparkPythonSparkSQL

About the role

  • Plan, build, and execute pipelines in Databricks.
  • Develop, validate, and optimize SQL and PySpark scripts.
  • Ensure efficient cluster usage and optimize cost and performance.
  • Design tables and data structures optimized for performance.
  • Implement data quality gates and rules in Databricks pipelines and Delta Live Tables (DLT).
  • Ensure that only trusted data reaches consumption layers.
  • Perform logical and physical modeling in the Lakehouse.
  • Keep the data model repository up to date.
  • Maintain documentation and metadata catalogs.
  • Support administration of the Databricks Workspace.
  • Manage access profiles.
  • Enforce security and governance policies.
  • Contribute to governance practices and standardization of data assets.
  • Ensure data integrity, traceability, and consistency.

Requirements

  • Bachelor's degree in IT or a related field.
  • Experience with Databricks (Workspace, clusters, notebooks, Delta Lake, DLT).
  • Knowledge of analytical data architecture and Lakehouse.
  • Proficiency in SQL.
  • Proficiency in PL/SQL.
  • Experience with PySpark (Python + Spark) for building pipelines.
  • Experience writing performance-focused SQL and PySpark scripts.
  • Experience in logical and physical data modeling.
  • Knowledge of dimensional modeling (Data Warehouse).
  • Experience with metadata and organizing model repositories.
  • Strong knowledge of relational and non-relational DBMS such as: PostgreSQL, SQL Server, MongoDB, DynamoDB.
  • Data governance.
  • Security policies and controls.
  • Access and profile management.
  • Information security policies.
Benefits
  • Home office / infrastructure allowance
  • Flexible working hours
  • Birthday day off — with a surprise!
  • Support for training and certifications
  • Access to Alura
  • Partnership with FIAP
  • Employee referral bonus
  • Health insurance
  • Dental plan
  • Vittude — mental health platform
  • Wellhub — physical wellness program
  • New Value — discount coupons
  • SESC benefits
  • Meal and/or food allowance
Applicant Tracking System Keywords

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

Hard Skills & Tools
SQLPySparkPL/SQLdata modelingdimensional modelingperformance optimizationdata quality gatesdata integritydata traceabilitydata consistency