Data Modeler

TurnKey Tech Staffing; São Paulo; Teletrabalho; BRL 423.000 - 636.000; Tempo integral

Resumo da oferta

A leading staffing agency is seeking a Data Modeler who will be responsible for designing and maintaining data models and SQL solutions on Google Cloud Platform. This role involves collaborating with various stakeholders and ensuring data integrity and performance. Candidates should have 5+ years of experience in SQL engineering and familiarity with data governance practices. The position offers fully remote work and a flexible schedule.

Serviços

Flexible Paid time off (no specified limits)

Health / Sport Budget

Personal laptop

Qualificações

• 5+ years in SQL engineering, data modeling, or a related role, preferably within SaaS or higher ed tech.
• Demonstrable experience with GCP data services.
• Experience with data orchestration frameworks is a plus.

Responsabilidades

• Design and implement scalable data models and SQL solutions.
• Collaborate with stakeholders to meet data requirements.
• Monitor and optimize GCP resource performance.

Conhecimentos

SQL proficiency

Google Cloud Platform experience

Data modeling

Data governance best practices

Infrastructure-as-code (Terraform)

Formação académica

College degree or equivalent life/work experience

Ferramentas

GCP services (BigQuery, Cloud SQL)

Git and Git providers

Python

Descrição da oferta de emprego

About the Product

For more than 30 years, Carnegie has been a leader and innovator in higher education marketing and enrollment strategy, offering groundbreaking services in the areas of Research, Strategy, Digital Marketing, Lead Generation, Slate Optimization, Student Search, Website Development, and Creative that generate authentic connections.

Job Purpose

The Data Modeler will be responsible for designing, developing, and maintaining robust data models and SQL-based solutions, with a focus on Google Cloud Platform. This role will ensure data integrity, optimize database performance, and support data-driven initiatives, particularly within the higher education sector.

Duties and Responsibilities

Data Modelling and SQL Development

• Design and implement scalable and efficient relational and dimensional data models.
• Develop, optimize, and maintain complex SQL queries, stored procedures, and functions.
• Ensure data quality and integrity across various data sources and reporting layers.
• Collaborate with stakeholders to understand data requirements and translate them into technical specifications.

Google Cloud Platform (GCP) Expertise

• Utilize GCP services such as BigQuery, Cloud SQL, and Dataflow for data storage, processing, and analysis.
• Implement and manage cloud-based data warehouses and data lakes on GCP.
• Develop and maintain infrastructure-as-code solutions for GCP data environments using tools like Terraform.
• Monitor and optimize GCP resource performance and cost for data platforms.

Collaboration and Communication

• Serve as a primary liaison among business leads, product managers, and data / engineering teams.
• Facilitate demos, knowledge-sharing sessions, and best-practice documentation for data solutions.
• Promote adoption of new data capabilities and practices; gather feedback for continuous improvement.

Release and Change Management

• Coordinate release plans, timelines, and stakeholder readiness for data model and SQL deployments.
• Ensure training, job aids, and rollout communications are prepared and delivered for data solutions.
• Track post-release issues, adoption, and stabilization metrics related to data platforms.

Knowledge / Skills / Abilities

• Ability to produce and manage, work autonomously, and take initiative.
• “Can-do” attitude with unwavering ethics and a willingness to help others.
• Exceptional relationship-building skills, cultural competency, and ability to communicate effectively with diverse groups of people and roles.
• Willingness to embrace relational nuances, own personal mistakes, be empathetic, address conflicts directly and transparently, and commit to self-reflection and self-betterment.
• Dexterity to effectively deal with ambiguity, change, and continuous process improvements.
• Strong business analysis fundamentals : elicitation, documentation, process mapping, traceability, UAT.

Requirements

• Strong proficiency in SQL and experience with relational database design and data modelling.
• Demonstrable experience with Google Cloud Platform (GCP) data services (e.g., BigQuery, Cloud SQL, Dataflow).
• Familiarity with infrastructure-as-code solutions, e.g., Terraform.
• Experience with data quality checks and data governance best practices.
• Experience with Git and Git providers, e.g., GitHub / BitBucket / GitLab.

Nice-to-haves

• Experience in the higher education space.
• Experience with data orchestration frameworks, e.g., Airflow, Prefect, Dagster, dbt.
• Experience with monitoring and observability tools for data platforms.
• Familiarity with Python for data scripting and automation.

Credentials and Experience

College degree or equivalent life / work experience.

5+ years in SQL engineering, data modelling, data engineering, or a related data-centric role, preferably within SaaS, marketing technology, higher ed tech, or related domains.

We offer

• We welcome new ideas and allow you to make an immediate impact on the team.
• Flexible Paid time off (PTO for any reason, including sick days (no specified limits) and flexible work schedule.
• Personal laptop.
• Health / Sport Budget.
• Fully remote.