Smartbridge · 2 days ago
Contract - Senior Azure Data Engineer
Smartbridge simplifies business transformation across App Development, Automation, Data & Analytics, and Modernization. They are seeking a Senior Azure Data Engineer to design and build modern Azure data platforms, focusing on strong coding in T-SQL and Python/PySpark, along with architectural judgment and database expertise.
AnalyticsConsultingEnterprise SoftwareInformation ServicesInformation TechnologyMobileSaaSSoftware
Responsibilities
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
Qualification
Required
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)
Preferred
Designed and implemented robust data validation procedures to verify the completeness of data transfers, ensuring all records were successfully migrated and proactively triggering alerts in cases of discrepancies
Experience with working with large SQL tables (100 million rows)
IaC (Bicep/Terraform) for data resources
Event-driven integration (Service Bus/Event Grid, CDC tooling)
Certs: DP-203 or AZ-204 are a plus
Company
Smartbridge
Simplifying Digital Transformation for the Enterprise
H1B Sponsorship
Smartbridge has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (4)
2023 (4)
2022 (6)
2021 (5)
2020 (8)
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase