Senior Data Engineer, SQL Server and Tableau (NYC, onsite)

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

Job summary

Gambit Technologies in New York City is seeking a Senior Data Engineer to own end-to-end data pipelines and BI dashboards in a hands-on role.

You will build ETL/ELT pipelines, design dimensional models, and develop Tableau dashboards with published data sources for leadership reviews. This onsite position emphasizes collaboration with stakeholders and incremental modernization of the SQL Server environment.

Qualifications

• Advanced SQL with window functions and plan analysis.
• Python for pipelines and automation work.
• Production experience on SQL Server or PostgreSQL.
• Hands-on Tableau development and published data sources.
• Dimensional modeling and defining grain of fact tables.
• Git and CI/CD as part of your workflow.

Responsibilities

• Build and maintain ETL/ELT pipelines end-to-end.
• Design dimensional models for reporting workloads.
• Develop Tableau dashboards and publish data sources.
• Tune dashboards when they slow down and optimize queries.
• Collaborate with business stakeholders to translate requests.

Job description

Senior Data Engineer, SQL Server and Tableau (NYC, onsite)

Seeking a Senior Data Engineer for a mission-driven organization in New York City. Small technology team, real ownership, and reporting that leadership reads every week.

This is a hands-on build role. You own the pipelines and the dashboards, start to finish. Nobody hands you tickets.

What you'll do

Build and maintain ETL/ELT pipelines in Python and SQL. Design dimensional models that hold up under real reporting load. Develop Tableau dashboards and published data sources, then tune them when they get slow. Sit with business stakeholders and turn a vague reporting request into something people use. Help move a legacy SQL Server environment toward the cloud.

What you need

• Advanced SQL. Window functions, query tuning, reading an execution plan and knowing what to do about it.
• Python for pipeline and automation work.
• Production experience on SQL Server or PostgreSQL.
• Hands-on Tableau development. You've built dashboards, published data sources, written LOD expressions, and fixed a workbook that took 30 seconds to load.
• Dimensional modeling. You can tell me the grain of a fact table you designed and defend the choice.
• Git and CI/CD as part of how you work, not something a platform team does for you.

Nice to have

Snowflake, Microsoft Fabric, Azure Synapse, or Databricks. Airflow, Azure Data Factory, or Prefect. Power BI. Experience migrating a legacy reporting environment onto something modern.

What this is not

Not remote. Not hybrid. This is onsite in Manhattan, and the team wants it that way.

Not a data analyst role. You're building the platform underneath the reporting.

Not a pure infrastructure job either. Half of this is BI development and talking to the business.