C

CI&T

AI-driven digital solutions and nearshore development

Master Data Developer - Data Ops

Cloud Engineering +1Confirmed live in the last 24 hours
Full-timeRemote in BrazilNo salary listedRemote

About the Job

Requirements

  • Solid, hands-on experience in DataOps or platform engineering supporting a production cloud data platform end-to-end, including provisioning, CI/CD, monitoring, and operational handoff.
  • Strong CI/CD experience for data pipelines, including Azure DevOps Pipelines with YAML, Git-based workflows with branch policies and approval gates, automated testing and regression gates, and multi-environment promotion paths.
  • Azure infrastructure fluency with Virtual Networks, NSGs, Private Link and Private Endpoints, Azure Key Vault for secrets, certificates, and rotation, Microsoft Entra ID service principals, managed identities, PIM, and access reviews, Azure Monitor and Log Analytics, and Azure Cost Management.
  • Hands-on Terraform experience, including remote state management on Azure Blob Storage, the Snowflake Terraform provider, and IaC security scanning integrated into CI pipelines.
  • Snowflake platform experience in RBAC design, warehouse sizing and segregation, resource monitors, row-access policies, and dynamic data masking. Experience with Enterprise or Business Critical editions is preferred.
  • Experience monitoring and operating a production CDC-based replication pipeline, including lag monitoring, restart and recovery procedures, and schema-drift detection at the landing layer.
  • Experience managing pipeline credentials through Azure Key Vault without plaintext credentials in repositories or pipeline definitions, and maintaining documented rotation procedures.
  • Experience integrating code scanning, dependency scanning, and IaC scanning into CI pipelines; familiarity with least-privilege access design and audit logging in regulated or sensitive-data environments.
  • Experience owning FinOps attribution, budget alerts, and right-sizing reviews as a named responsibility.
  • Fluent English at B2 or above for serving as the named client-facing point of contact on platform operations topics across delivery and client teams.

Responsibilities

  • Own end-to-end environment provisioning and platform readiness across the full data stack, from SQL Server CDC source through Snowflake landing, raw, and curated layers, ahead of and during the build; deliver a formal readiness checklist before sensitive-data build begins.
  • Provision and maintain Snowflake DEV, QA, UAT, and production environments with dedicated, right-sized warehouses for replication and ingestion, curated-layer transformation, and BI serving, each configured with auto-suspend, resource monitors, and cost attribution.
  • Coordinate Azure infrastructure provisioning for Virtual Networks, NSGs, Private Endpoints, Azure Key Vault, self-hosted Azure DevOps agents, and VM infrastructure for the CDC replication tool, including firewall rules, TLS certificate requests, and DNS resolution for private Snowflake endpoints; surface documented lead times proactively.
  • Manage Snowflake RBAC provisioning with a dedicated project-specific role hierarchy separated from broad IT, developer, analyst, and AI roles; execute positive and negative access tests before handoff to the build team.
  • Manage the full vendor and service-account access lifecycle, including named, individual, time-bound, least-privilege access for delivery personnel; dedicated non-personal service accounts for replication, Snowflake, and BI integrations; credential storage and rotation through Azure Key Vault; and documented revocation evidence at engagement end.
  • Build and operate the CI/CD pipeline for data artifacts, including transformation logic, metric definitions, replication configurations, Snowflake object DDL, and versioned SQL transformation models, using Azure DevOps Pipelines with YAML-based, version-controlled pipeline definitions.
  • Enforce a DEV-to-QA-to-UAT-to-production promotion path with branch policies, required reviewers, pull-request build validation, and written approval gates before production deployment; prevent silent or automatic production changes.
  • Integrate automated regression, schema validation, row-count checks, and data-quality assertions at every promotion stage.
  • Externalize environment-specific configuration from code and integrate Azure DevOps Variable Groups linked to Azure Key Vault so credentials are not stored as plaintext in pipeline definitions or repository files.
  • Integrate code scanning, dependency scanning, and infrastructure-as-code scanning, such as Checkov and Microsoft Defender for DevOps, into CI pipelines; remediate or formally document exceptions for material findings before production promotion.
  • Design, document, and rehearse rollback procedures for every promotion stage, including a full mock cutover and rollback rehearsal before the production readiness gate.
  • Implement and own end-to-end pipeline monitoring using Azure Monitor and Log Analytics, covering replication health, CDC lag alerts, replication-agent availability, Snowflake warehouse freshness against agreed SLA targets, landing-zone schema-change and drift events, and semantic-definition change alerts.
  • Configure Azure Monitor Alert Rules routed through Action Groups to the client's approved ITSM tool, such as ServiceNow, with named alert owners, defined thresholds, and documented escalation paths so the client's DataOps team can operate every alert after handoff without vendor involvement.
  • Enable and maintain Diagnostic Settings on Azure Key Vault, VMs, NSGs, and Storage Accounts, feeding a centralized Log Analytics Workspace with appropriate retention, access control, and audit trails for authentication, access grants, configuration changes, and deployments.
  • Implement Snowflake resource monitors and Azure Cost Management budget alerts for cost-anomaly detection; produce periodic FinOps attribution reports by workload class.
  • Own platform cost attribution and consumption monitoring across Snowflake warehouses and Azure compute resources, establishing per-workload attribution from day one through a consistent resource-tagging strategy enforced via IaC.
  • Deliver a Snowflake and Azure cost model at the architecture gate, including monitored budgets, right-sizing recommendations, and auto-suspend configurations.
  • Conduct periodic right-sizing reviews using Azure Advisor and Snowflake usage data; present findings in structured FinOps reviews with the client's Cloud Architecture team.
  • Manage Azure infrastructure as code using Terraform or Bicep where appropriate, including VNets, NSGs, Key Vault, VMs, storage accounts, Entra ID service principals, and RBAC role assignments; avoid manual portal configuration for production-baseline infrastructure.
  • Manage Snowflake object provisioning, including databases, schemas, warehouses, roles, and resource monitors, through the Snowflake Terraform provider, maintaining remote state in Azure Blob Storage with state locking.
  • Enforce configuration standards with Azure Policy guardrails, such as Key Vault soft-delete, no public IPs on data resources, and mandatory resource tagging, so IaC deployments are validated against policy before production.
  • Maintain Architecture Decision Records and other living delivery artifacts alongside the Lead Architect, including network and connectivity design, environment topology, CI/CD promotion model, and security access design, in client-controlled repositories from the first commit.
  • Write and validate operational runbooks for replication failure, recovery, and resynchronization; CDC lag breach response; deployment and rollback procedures; reconciliation-discrepancy triage; access request and revocation workflows; cost-anomaly response; and incident routing through client ITSM. Exercise each with the client's DataOps team before final handoff acceptance.
  • Drive progressive knowledge transfer from the architecture phase through paired working sessions, shadowed deployments, and runbook exercises rather than a single end-of-project handoff.
  • Act as the named point of contact for platform operations across the delivery team and the client's DataOps, Cloud Architecture, Infrastructure/Network, and Information Security teams, translating technical platform concerns into clear client-facing communications in fluent English.
  • Quantify and track client infrastructure dependencies, including Snowflake environments, Azure network paths, service accounts, replication-tool licensing, and production change windows, with named need-by dates and schedule-impact statements; escalate proactively when readiness is at risk.

Desired Qualifications

  • Hands-on configuration of Qlik Replicate full-load and CDC replication, including source and target endpoint setup, table scoping, schema-evolution handling, throttling and change-window management, latency monitoring, and restart and recovery procedures.
  • Familiarity with Azure SQL Server or SQL Server on Azure VM, including CDC prerequisites such as SQL Server Agent, capture jobs, and service-account permissions; private Azure connectivity requirements; and coordination with DBA teams on change windows and backup schedules.
  • Operational experience with Microsoft Fabric or OneLake, including capacity management, landing-zone health, and monitoring in a Fabric environment.
  • Experience designing or operating Azure ExpressRoute and hybrid networking between on-premises SQL Server instances and cloud-hosted data infrastructure.
  • Experience implementing Microsoft Entra ID Privileged Identity Management for just-in-time access with approval workflows and audit trails for vendor and contractor access in a client environment.
  • Familiarity with Microsoft Dynamics 365 Business Central or SQL Server source systems, including Business Central table structures, company-prefixed naming conventions, and schema-drift risk from vendor-managed upgrades.
  • Familiarity with Power BI semantic model operations, including workspace publication, scheduled refresh configuration, and gateway management in a governed enterprise deployment.
  • Demonstrated experience writing production runbooks that a client's operations team can execute without vendor support, and leading structured knowledge transfer with competency-evidence checkpoints.
  • Experience in mortgage, lending, or financial-services environments operating under strict change-control discipline with sensitive financial data and audit-trail requirements for every access and deployment event.
  • Experience operating dbt or dbt-style versioned SQL transformation frameworks in a CI/CD pipeline, including running tests, managing model promotion, and debugging failed runs in Snowflake.

About the Company

CI&T

AI-driven digital solutions and nearshore development

CI&T provides digital solutions to help brands transform their businesses through technology. It focuses on digital strategy and software engineering, offering services such as AI-powered solutions, customer-centric design, and nearshore software development. Products and engagements work by delivering tailored digital initiatives through long-term partnerships, project-based work, and ongoing maintenance; its MRVP approach helps navigate compliance in regulated industries while still enabling innovation. CI&T differentiates itself through a global delivery model, a focus on diversity and inclusion, and an emphasis on combining strategy, engineering, and design to drive business transformation. The company targets a wide range of clients, including regulated sectors and quick-service restaurants, and aims to help clients maximize resources, scale rapidly, and thrive in a post-digital transformation landscape.

Company size
5,001-10,000
Company stage
IPO
Headquarters
São Paulo, Brazil
Founded
1995

Recently Posted Jobs

Explore more opportunities at CI&T

See more jobs