Data Warehouse Engineer

🕒 il y a 6 jours

🏄 California – Distant

🏄 California – Remote

💵 $140 000 - $160 000 / an

⏰ Temps Plein

🟡 Intermédiaire

🟠 Senior

🚰 Ingénieur Data

🦅 Parrain de Visa H1B

Cette entreprise a parrainé des visas H1B par le passé.

Postuler Maintenant

Trouver des Emplois à Distance Similaires

Configurer une alerte email pour les nouveaux emplois

📊 Vérifiez votre score de CV pour ce poste

Améliorez vos chances d'obtenir un entretien en vérifiant votre score de CV avant de postuler.

Télécharger le CV

Maverick Payments

Site WebLinkedInTous les Emplois

51 - 200 employés

💼 Conseil

📦 Logistique

💳 Fintech

Consulting • Logistics • Fintech

Maverick Payments est un prestataire de services de paiement à part entière, offrant des solutions de paiement alimentées par la technologie. Spécialisée dans le traitement des paiements en ligne et en personne, Maverick Payments dispose d'outils avancés tels qu'un tableau de bord complet, des capacités de prévention de la fraude, l'analyse et le reporting. L'entreprise fournit des solutions de paiement en marque blanche et permet aux entreprises de traiter des transactions via leur API, un terminal virtuel et d'autres services intégrés. Avec un accent sur les marchés émergents et offrant des fonctionnalités avancées telles que les transactions ACH et sans carte, Maverick Payments aide les entreprises de toutes tailles à gérer les rétrofacturations, à étendre leur portée et à optimiser l'acceptation et la gestion des paiements. L'entreprise opère comme une division de Maverick BankCard, Inc. et s'associe à plusieurs banques pour des opérations simplifiées.

Description

• 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 external implementation resources in Phase 1 and then own daily operations, reliability, and continuous improvement of the platform. • The role balances operational excellence (pipeline uptime, SLAs, observability) with platform development (new data pipelines, sponsor bank integrations, performance/cost optimization). • Your work enables the Maverick organization to access reliable, timely, and governed data for analytics, BI, and regulatory reporting. • 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. • Support 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 and build Azure Data Factory 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. • Onboard new sponsor banks and data sources against the Director’s roadmap; standardize patterns for file-based (CSV/JSON/Parquet/Delta) and API-based data. • Strengthen data quality and observability with validation checks, reconciliations, and anomaly detection. • Collaborate with vendors during Phase 1; participate in code reviews, document architecture decisions (ADRs) and platform standards. • Create and maintain runbooks (“respond to X failure”), troubleshooting guides, and common query patterns. • Document pipeline architecture, data lineage, schemas, and transformation logic for knowledge transfer. • Maintain a data dictionary/metadata (descriptions, refresh cadence, PII tags, sensitivity labels).

🎯 Exigences

• 5-8 years in Data Engineering/Data Warehousing or closely 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).

🏖️ Avantages

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