Data Warehouse Engineer

Maverick Payments

. The Data Warehouse Engineer is a hands-on role responsible for designing, building, and operating Maverick’s Azure data platform.

Posted 4/22/2026full-timeRemote • Arizona, California, Colorado, Florida, Idaho, Kansas, Kentucky, Maine, Maryland, Massachusetts, Nevada, New Jersey, New York, North Carolina, Ohio, Oregon, Pennsylvania, Tennessee, Texas, Utah, Virginia, Washington • 🇺🇸 United StatesMid-LevelSenior💰 $110,000 - $125,000 per yearWebsite

Tech Stack

Tools & technologies

Amazon RedshiftAzureBigQueryETLITSMSQLTerraformVault

About the role

Key responsibilities & impact

The Data Warehouse Engineer is a hands-on role responsible for designing, building, and operating Maverick’s Azure data platform.
Reporting to the Data Team Director, you will partner with external implementation resources in Phase 1 and then own daily operations, reliability, and continuous improvement of the platform.
Monitor health and SLAs via Azure Monitor/Log Analytics, Synapse and Data Factory dashboards; respond to critical pipeline incidents within 2 hours.
Triage and resolve data integration failures (sponsor bank files, CRM/ITSM connectors, API ingestions), distinguishing data quality vs. pipeline vs. infrastructure issues; escalate when needed.
Perform root-cause analysis (RCA) and drive corrective actions; maintain and conduct post-mortems.
Design and build Azure Data Factory pipelines (ETL/ELT) for batch and incremental ingestion using parameterized, reusable templates.

Requirements

What you’ll need

3+ years in data engineering/data warehousing or related technical roles.
Advanced SQL/T‑SQL: complex queries, stored procedures, views, indexing, and performance tuning.
Hands‑on Azure: Data Factory, Synapse SQL, Data Lake Gen2, Key Vault (or strong equivalents: Snowflake, BigQuery, Redshift).
Proven delivery of ETL/ELT for file‑based (CSV/JSON/Parquet) and API data sources.
Strong data modeling: star/snowflake, dimensional modeling, fact/dimension tables, SCDs (Type 1/2).
Git proficiency and CI/CD concepts for infra/pipeline deployment (Azure DevOps/GitHub Actions; ARM/Bicep/Terraform a plus).
Demonstrated troubleshooting and RCA across complex systems; able to drive solutions independently.
Experience supporting BI/analytics consumers (Power BI preferred; semantic models, incremental refresh, gateway basics)

Benefits

Comp & perks

Competitive Salary, Bonuses and Incentives.
Comprehensive employer sponsored health, vision, and dental insurance programs.
Paid time off, Paid Sick and Paid Holidays.
401K plan with up to a 3% matching contribution.
Commitment to Career Development and Advancement.
Vibrant Office Culture, Team Building, Birthdays, Work Anniversaries, Snacks, and more!

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills & Tools

data engineeringdata warehousingSQLT-SQLAzure Data FactoryAzure Synapse SQLdata modelingETLELTtroubleshooting

Soft Skills

problem-solvingindependent solutionscollaborationcommunicationcritical thinkingroot-cause analysiscontinuous improvementreliability managementincident responsepost-mortem analysis