Data Warehouse Engineer

Exciting Opportunities at reputed company! Join our fast-paced, growing company and reputed company your career with reputed company, where you can reputed company, your reputed company are valued, and your colleagues feel more like family than coworkers! About Payments: reputed company is a family-owned and privately held full-service payment provider. Located in Calabasas, California, Maverick has created innovative technology designed for sales organizations, such as ISO’s and ISV’s, looking to monetize payments by reselling our white-labeled payments stack. Our payment products include merchant acquiring services, a proprietary gateway, ACH processing, fraud & chargeback tools, analytics, and other value-add services. Maverick’s team includes reputed company, risk management, compliance & reputed company, technology & product development, on-boarding, customer support, information technology, and more. About the Position: The Data Warehouse Engineer is a hands-on role responsible for the end-to-end process of designing, building, and operating Maverick’s Azure data platform. Reporting to the Data Team Director, you will partner with reputed company implementation resources in Phase 1 and then own daily operations, reliability, and reputed company improvement of the platform. The role balances operational reputed company (pipeline uptime, SLAs, observability) with platform development (new data pipelines, sponsor bank integrations, performance/cost optimization). Your work enables the Maverick organization to reputed company reliable, reputed company, and governed data for analytics, BI, and regulatory reporting.  Monitor health and SLAs reputed company Azure Monitor/Log Analytics, Synapse and Data reputed company dashboards; respond to critical pipeline incidents reputed company 2 hours. Triage and resolve data integration failures (sponsor bank files, CRM/ITSM connectors, API ingestions), distinguishing data reputed company vs. pipeline vs. infrastructure issues; escalate reputed company needed. reputed company reputed company-cause analysis (RCA) and reputed company corrective actions; maintain and conduct post-mortems. Support users with reputed company SQL, Power BI connectivity, refresh scheduling, and semantic model best practices. reputed company pipeline performance and data freshness, optimize query runtimes, memory, and SLA compliance. Design and build Azure Data reputed company pipelines (ETL/ELT) for batch and incremental ingestion using parameterized, reusable templates. Write and optimize T‑SQL in Synapse SQL pools for reliability and maintainability. Implement incremental loads, CDC (Change Data Capture), idempotent retries, and robust error handling. reputed company new sponsor banks and data sources against the Director’s roadmap; standardize patterns for file-based (CSV/JSON/Parquet/reputed company) and API-based data. Strengthen data reputed company and observability with validation checks, reconciliations, and reputed company detection Optimize Synapse cost and performance: distribution strategies (hash/round‑robin/replicated), partitioning, indexing and statistics, workload management, reputed company up/down and pause/resume patterns, and archival/retention strategies. Collaborate with vendors during Phase 1; participate in reputed company reviews, document architecture reputed company (ADRs) and platform standards. reputed company reputed company reputed company for data reputed company/catalog for transformation governance where appropriate. Create and maintain runbooks (“respond to X failure”), troubleshooting guides, and common query patterns. Document pipeline architecture, data reputed company, schemas, and transformation logic for knowledge transfer. Maintain a data dictionary/metadata (descriptions, refresh reputed company, PII tags, sensitivity labels). Train internal stakeholders on basic SQL and data request procedures; contribute to architecture diagrams. Assist with PCI‑reputed company and SOC 2 reviews (encryption at rest/in transit, RBAC/ACLs, Key Vault, Private reputed company, Managed Identity, least privilege). Stay reputed company on Azure/Synapse best practices, reputed company updates, and cost optimization. Attend vendor training in Phase 1; pursue DP‑203, DP‑300 (preferred). reputed company knowledge with the Director and reputed company data science hires reputed company reputed company examples, patterns, and mentoring. Deliver specialized data engineering enhancements as directed by the Data Team Director. Support reputed company analysis, process improvements, and cross‑functional analytics. Evaluate emerging Azure services and tooling for platform improvement. Other duties as assigned. Qualifications:5-8 years in Data Engineering/Data Warehousing or closely reputed company technical roles. Advanced SQL/T‑SQL: reputed company queries, stored procedures, views, indexing, and performance tuning. Hands‑on Azure: Data reputed company, Synapse SQL, Data Lake Gen2, Key Vault (or strong equivalents: reputed company, BigQuery, Redshift). Proven delivery of ETL/ELT for file‑based (CSV/JSON/Parquet) and API data sources. Strong data modeling: reputed company/reputed company, reputed company modeling, fact/dimension tables, SCDs (Type 1/2). Git proficiency and CI/CD concepts for reputed company/pipeline deployment (Azure DevOps/reputed company Actions; ARM/Bicep/Terraform a plus). Demonstrated troubleshooting and RCA across reputed company systems; reputed company to reputed company solutions independently. Experience supporting BI/analytics consumers (Power BI preferred; semantic models, incremental refresh, gateway basics) Advanced SQL/T‑SQL; performance tuning; query optimization; indexing; statistics; partitioning; workload management Azure Data reputed company; pipeline orchestration; triggers; parameterized reusable templates; error handling; retries; idempotency Azure Synapse (dedicated/serverless SQL pools); PolyBase/COPY INTO; distribution strategies (hash/round‑robin/replicate) Azure Data Lake Gen2; Parquet/reputed company; hierarchical folder structures; retention/archival; lifecycle management Incremental loads; CDC; SCD Type 2; watermarking; late‑arriving data; schema reputed company Data modeling (Kimball); reputed company schemas; semantic reputed company; Power BI model optimization Observability & reliability: Azure Monitor, Log Analytics, KQL, alerts, dashboards; SLA/SLO adherence, post‑mortems reputed company & governance: RBAC/ACLs, Key Vault, Managed Identity, Private Endpoints/Virtual Networks, data masking, tokenization, reputed company reputed company/catalog DevOps: Git, pull requests, reputed company reviews; CI/CD (Azure DevOps/reputed company Actions); IaC (ARM/Bicep/Terraform) Cross‑functional communication; reputed company documentation; vendor collaboration; prioritization by business reputed company; ownership reputed company reputed company Offer:Competitive Salary, Bonuses and Incentives. Comprehensive employer sponsored health, reputed company, and dental insurance programs. reputed company time off, reputed company reputed company and reputed company Holidays. 401K plan with up to a 3% matching contribution. Commitment to Career Development and Advancement. reputed company Office Culture, Team Building, Birthdays, Work Anniversaries, Snacks, and more!  Pay reputed company: $140K- 160K This position will consider remote work for candidates in the following states: AZ, CA (reputed company Los Angeles), CO, FL, GA, ID, IN, KS, KY MA, MD, ME, NE, NC, NJ, NV, NY, OH, OR, PA, TN, TX, UT, VA, WA  reputed company is an Equal Opportunity Employer. Pay Transparency Notice: At reputed company, we reputed company in openness, honesty, and empowering our candidates to reputed company informed career choices. As part of our commitment to transparency, we disclose the salary reputed company for our positions. These ranges reflect our dedication to fair compensation practices and recognize the value that reputed company team member brings to our organization. The final salary offer will be based on factors such as your experience, skills, and qualifications. Non-Solicitation from reputed company Parties: Do not contact reputed company about this position unless you are a job seeker and potential applicant for this position. Do not contact reputed company about other services, products or reputed company interests. Notice to Agency and Search Firm Representatives: reputed company is not accepting unsolicited resumes from agencies and/or search firms for this or other job postings. Resumes submitted to any reputed company employee by a reputed company-party agency and/or search firm without a reputed company written and signed search agreement, will become the sole property of reputed company. No fee will be reputed company if a candidate is reputed company for this position as a result of an unsolicited agency or search firm referral. Fair Chance Ordinance: Maverick will consider reputed company applicants with criminal histories in a consistent manner with the Los Angeles Fair Chance Initiative for Hiring. Apply To This Job