Data Warehouse Engineer

Posted 10hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Data Warehouse Engineer designing, building, and operating Azure data platform for Maverick Payments. Collaborating with teams and managing operational excellence in data processing.

Responsibilities:

  • 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:

  • 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:

  • 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!