Senior Data Engineer (Nearshore)

Job Description

Company Description:

Mojo Trek, an Inc. 5000 company, delivers an unparalleled recruitment experience, grounded in transparency and integrity. From midsize technology innovators to Fortune 50 powerhouse corporations, we help our clients build technology teams that make a difference, push the change forward, and develop software critical to their success.

We’re looking for a Senior Data Engineer to design and deliver a scalable data integration and dashboarding pattern on Google Cloud Platform (GCP). You will integrate and standardize sales and product data from multiple international markets into BigQuery, build well-structured intermediate tables, and enable market-specific reporting through Looker dashboards—while thoughtfully handling schema differences and local reporting requirements.

Key Responsibilities:

• Data integration & standardization
• Ingest, integrate, and harmonize sales and product datasets from multiple international markets into GCP/BigQuery.
• Identify and resolve data schema differences across markets (e.g., field naming, grain, definitions, missing attributes).
• Define standardized/semantic data structures that support consistent reporting while allowing local variation.
• Data modeling & intermediate tables
• Design and build intermediate (curated) tables in BigQuery to support reliable downstream analytics.
• Implement clear transformation logic and consistent metric definitions to support cross-market comparability.
• Establish conventions for table naming, partitioning/clustering (as appropriate), and data quality expectations.
• Looker dashboarding enablement
• Deliver Looker dashboards based on business reporting needs, using the curated BigQuery layer.
• Support a “template + market customization” approach where dashboards can be copied and tweaked per market.
• Example adjustments: removing drive-through metrics in markets without drive-throughs, or excluding digital sales metrics where digital apps are not available.
• Partner with stakeholders to translate reporting needs into robust data models and dashboard definitions.
• Pattern establishment & scalability
• Create a repeatable integration + modeling + dashboarding pattern to onboard new markets efficiently.
• Design with an option to scale (e.g., increased workload, faster refresh needs, more markets) without re-architecting from scratch.
• Document patterns, assumptions, market-specific logic, and onboarding steps for maintainability.

Required Qualifications:

• 8+ years of experience in data engineering, including ownership of production analytics data pipelines.
• Strong experience with Google Cloud Platform, especially BigQuery (data modeling, performance considerations, cost awareness).
• Proven ability to standardize data across multiple sources/regions with varying schemas and definitions.
• Experience enabling BI/reporting use cases, ideally with Looker (dashboards and/or LookML concepts).
• Strong stakeholder communication skills—able to clarify ambiguous requirements and align on metric definitions.

Preferred Qualifications:

• Experience designing multi-tenant or multi-market analytics patterns (shared core + local customizations).
• Familiarity with best practices for analytics engineering (layered modeling, reusable transformations, testing/data quality).
• Experience with dashboard templating/versioning strategies and governance across markets.