Senior Data Engineer & Analytics Developer

Pay Rate $65.00

This position is Remote

Questions for Candidate:
These questions along with their answers must be submitted with the resumes, if they are not your candidate will be rejected.
1. How many Tableau dashboards have you built from scratch, not modified, but built end to end including the data layer behind them? And how did you build them?
2. How familiar are you with Cloud Composer? When would you use it over something simpler like a scheduled notebook or a cron job?
3. Have you ever had to combine data from multiple sources into a single dataset for reporting? Pick one example and tell me how you decided to structure it.

Top 3 things to look for when reviewing resumes:
1. Hands-on experience with SQL, Python, GCP, Big Query, Cloud Composer, GCS, Cloud Functions, Jupyter notebooks — not just listed as keywords but demonstrated through pipeline builds, dataset design, or architecture decisions in prior roles.
2. Evidence of scalable data architecture thinking — look for candidates who talk about reusable models, layered architectures (medallion, star schema), and consolidation rather than listing dozens of one-off projects.
3. Tableau dashboard development paired with data modeling — candidates who have built both the data layer and the visualization on top of it, not just one or the other

Role Summary
We are seeking a Data Engineer with strong analytics capabilities who can own the full data lifecycle — from scalable pipeline development to polished Tableau dashboards. The ideal candidate is someone who thinks architecturally, designs datasets for reuse and longevity, and resists the urge to create one-off tables for every new request. They bring a builder's mindset grounded in efficiency, modularity, and long-term sustainability of the data platform.

They must be highly proficient in both Python and SQL as their primary working languages and tableau for reporting.

Core Competencies Data Engineering and Pipeline Development

• Deep, hands-on experience with Google Big Query — including dataset design, partitioning/clustering strategies, materialized views, and cost-optimization techniques.

• Proficiency in Cloud Composer (Apache Airflow) for orchestrating complex, production-grade data pipelines with proper scheduling, retry logic, and dependency management.

• Experience building and maintaining Vertex AI Pipelines for ML workflows and data transformation at scale.

• Advanced SQL skills — able to write complex, performant, and maintainable queries across large datasets including window functions, CTEs, recursive queries, and query optimization.

• Strong Python proficiency — comfortable building data transformation scripts, pipeline logic, custom Airflow operators, API integrations, and automation tooling.
Data Architecture and Scalable Design

• Proven ability to design layered data architectures using patterns such as Medallion (bronze/silver/gold), Dimensional Modeling (star schema), Data Vault, and targeted denormalization — and knows when to apply each based on the use case.

• Track record of building modular, multi-purpose datasets rather than project-specific tables — thinks in terms of canonical models and shared dimensions.

• Understands when to create new tables versus when to extend, view, or restructure existing assets to avoid unnecessary duplication and table sprawl.

• Applies best practices around naming conventions, schema organization, documentation, and lifecycle management so that the architecture remains navigable as it scales.
Tableau Dashboard Development

• Hands-on experience building production-quality Tableau dashboards — from data source configuration and extract optimization to interactive visual design.

• Ability to translate business questions into clear, intuitive visualizations that non-technical stakeholders can self-serve from.

• Familiarity with Tableau performance tuning, published data sources, and server/cloud publishing workflows.

• Understands the relationship between upstream data modeling decisions and downstream dashboard performance — designs the data layer with the visualization in mind.
Technical Stack

• Cloud Platform:
Google Cloud Platform (GCP)

• Data Warehouse:
B…