Smartbridge

Senior Azure Data Engineer

Smartbridge

contract

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureCyber SecurityETLPySparkPythonSQLTerraformVault

About the role

  • Define the target-state Azure data architecture (ingestion, orchestration, storage zones, serving patterns), security/networking boundaries, cost/perf tradeoffs, and promotion strategy (Dev→Test→Prod).
  • Implement robust ELT/ETL with ADF/Synapse Pipelines (parameters, reusable templates, CI/CD).
  • Hands-on in T-SQL and Python/PySpark for transformations, utilities, and tests.
  • Physical/semantic modeling, partitioning, columnstore strategies, statistics management, query plan analysis, index design, concurrency & transaction isolation, workload management.
  • SLA/SLO definitions, Azure Monitor / Log Analytics / App Insights dashboards and alerts; error handling, retries/backoff, idempotency, CDC and schema drift strategies.
  • RBAC, Key Vault, managed identities, private endpoints/VNet, data masking patterns; document data contracts and access patterns.
  • Code reviews, PR discipline, mentoring, and crisp documentation/runbooks for client handoff.

Requirements

  • 8–12+ years in data engineering (recent Azure focus).
  • Expert with ADF (linked services, datasets, IRs—including self-hosted), Synapse (SQL pools/serverless, pipelines), and ADLS/Blob.
  • T-SQL: advanced query tuning, execution plan analysis, windowing, TVFs/stored procs, temp tables vs CTE tradeoffs, cardinality estimator know-how.
  • Python/PySpark: production data transforms, packaging, and testing.
  • CI/CD: Azure DevOps or GitHub Actions (multi-stage releases, approvals, infra + data deployments).
  • Proven delivery of production-grade platforms at scale (TB-level data, strict SLAs).
Benefits
  • 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords

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

Hard Skills & Tools
Azure data architectureELTETLT-SQLPythonPySparkCI/CDquery plan analysisdata modelingdata transformations
Soft Skills
mentoringdocumentationcode reviewscommunication