About the role

Role Overview

Hands-on Data Warehouse Engineer responsible for designing, building, and operating Maverick Payments’ Azure data platform. You’ll report to the Data Team Director, partner with external implementation resources initially, and then own daily operations, reliability, and continuous improvement.

Key Responsibilities

Ensure pipeline uptime, SLAs, and observability; monitor via Azure Monitor/Log Analytics, Synapse, and Data Factory dashboards
Respond within 2 hours to critical pipeline incidents
Triage and resolve data integration failures (sponsor bank files, CRM/ITSM connectors, API ingestions) by distinguishing data quality vs. pipeline vs. infrastructure issues
Conduct root-cause analysis (RCA), drive corrective actions, and run post-mortems
Support analytics users with ad-hoc SQL, Power BI connectivity, refresh scheduling, and semantic model best practices
Track pipeline performance and data freshness; optimize query runtimes, memory, and SLA compliance
Design/build Azure Data Factory pipelines (batch + incremental) using parameterized reusable templates
Write/optimize T-SQL in Synapse SQL pools for reliability and maintainability
Implement incremental loads, CDC, idempotent retries, and robust error handling
Onboard new sponsor banks and data sources; standardize patterns for file-based (CSV/JSON/Parquet/Delta) and API-based data
Improve data quality and observability with validation checks, reconciliations, and anomaly detection
Optimize Synapse cost & performance (distribution strategies, partitioning, indexing/statistics, workload management, scale patterns, archival/retention)
Collaborate with vendors during Phase 1; participate in code reviews and produce architecture decision records (ADRs)
Integrate Microsoft Purview for lineage/catalog for transformation governance where appropriate
Create/maintain runbooks, troubleshooting guides, and common query patterns; document architecture, lineage, schemas, and transformation logic
Maintain data dictionary/metadata (refresh cadence, PII tags, sensitivity labels)
Support security/compliance activities for PCI-DSS and SOC 2 (encryption, RBAC/ACLs, Key Vault, Private Link, Managed Identity, least privilege)
Stay current on Azure/Synapse best practices, security updates, and cost optimization; pursue certifications

Requirements

Strong hands-on experience designing, building, and operating Azure-based data warehouse solutions
Proficiency with Azure Data Factory and Synapse SQL pools (including T-SQL)
Experience managing pipeline reliability: monitoring, SLAs, incident response, RCA, and corrective actions
Ability to troubleshoot data integration issues across sources/connectors/APIs and handle data quality vs. pipeline vs. infrastructure problems

Nice-to-haves

Experience with CDC and incremental ingestion patterns
Knowledge of data governance/lineage with Microsoft Purview
Familiarity with compliance concepts relevant to PCI-DSS and SOC 2 (RBAC, encryption, Key Vault, Private Link, Managed Identity)
Certification progress/interest: DP-203 and DP-300 (preferred)

About Maverick Payments

Maverick Payments is a family-owned, privately held full-service payment provider based in Calabasas, California. It builds and operates a white-labeled payments stack for sales organizations (ISO’s and ISV’s), including merchant acquiring, a proprietary gateway, ACH processing, fraud and chargeback tools, and analytics.