Senior Data Engineer (Python)

Gambit Technologies; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Gambit Technologies in New York is seeking a hands-on data engineer to design the data model, write Python data pipelines, and build Tableau dashboards for decision making.

You will own end-to-end data flows from source systems to a SQL warehouse, implement tests and CI/CD, and migrate toward a modern cloud platform.

Join a small, mission-driven team with real ownership and opportunities to shape how data drives impact.

Qualifications

• Proficient Python for data pipelines and automation.
• Strong SQL with ability to tune queries and read execution plans.
• Hands-on data modeling and defining grain for fact/dimension tables.
• Experience building Tableau dashboards and data sources end-to-end.
• Experience with Git and CI/CD as part of workflow.

Responsibilities

• Design data models including star schemas and slowly changing dimensions.
• Build Python pipelines pulling from APIs, databases, and flat files into a SQL warehouse.
• Develop and publish Tableau dashboards and data sources atop modeled data.
• Implement automated tests, monitoring, and CI/CD for reliable operations.
• Migrate from legacy SQL Server environment to a modern cloud platform.

Skills

Python

SQL

Tableau

Git

CI/CD

Data modeling

Tools

Snowflake

Databricks

Airflow

dbt

Job description

I'm hiring a hands-on data engineer for a well-known, mission-driven organization in New York. Small team, real ownership. You design the data model, write the Python that feeds it, and build the Tableau layer people use to make decisions. Nobody else is doing that part for you.

What you'll build

• Python pipelines that pull from APIs, databases, and flat files into a SQL warehouse.
• Dimensional models (star schema, fact and dimension tables, slowly changing dimensions) that reporting can trust.
• Tableau dashboards and published data sources on top of those models.
• Automated tests, monitoring, and CI/CD so the whole thing runs without babysitting.
• The path from today's SQL Server environment to a modern cloud platform.

What you bring

• Python you'd be comfortable having another engineer review. Pipelines, automation, API integrations.
• Strong SQL. Window functions, query tuning, reading an execution plan. SQL Server experience is a plus.
• Real data modeling. You can name the grain of a fact table you built and defend it.
• Hands-on Tableau. You've built the dashboards yourself, not just the data behind them.
• Git and CI/CD as part of how you work.

Nice to have

Snowflake, Fabric, Databricks, Airflow, dbt, Azure Data Factory, or a legacy migration under your belt.