Senior Back End Developer (Python, Data Platform/BI Modernization)

Gambit Technologies; New York (NY); Hybrid; USD 150,000 - 230,000; Full time

Job summary

A leading tech firm based in New York City is seeking a Senior Software Engineer to drive the modernization of their Business Intelligence and data platform. The role involves transitioning to a cloud-native data architecture and requires strong programming skills in Python, experience with data pipelines, advanced SQL skills, and familiarity with cloud platforms. Candidates should also have experience with orchestration tools and designing scalable architectures. This hybrid position offers the chance to work on critical data systems.

Qualifications

• Strong programming skills in Python.
• Experience with data pipelines and data warehouses/lakehouses.
• Advanced SQL performance tuning and modeling skills.

Responsibilities

• Lead modernization of Business Intelligence and data platform.
• Design and implement a modern data architecture.
• Ensure stability and reliability of BI systems.

Skills

Strong programming skills - Python

Experience building and operating data pipelines

Advanced SQL skills

Experience with cloud platforms (AWS, Azure, GCP, Snowflake, Databricks)

Experience with orchestration tools (Airflow, Prefect, Dagster)

Experience designing microservices-based architectures and APIs

Familiarity with Business Intelligence tools (Tableau, Qlik, Power BI)

Tools

Airflow

Dagster

Tableau

Power BI

Snowflake

Databricks

Job description

Senior Software Engineer (Data Platform / BI Modernization)

Hybrid New York City Office

We’re looking for a Senior Software Engineer to help lead the modernization a Business Intelligence and data platform for a large hedge fund as they transition from a traditional on‑prem SQL Server environment to a cloud‑native data architecture.

This is a hands‑on engineering role for someone who enjoys building systems the right way. You will help define the future data platform strategy, design and implement a modern data warehouse or lakehouse architecture, and ensure the stability and reliability of the BI systems the business depends on today.

You’ll need to have

• Strong programming skills - Python is our primary language
• Strong experience building and operating data pipelines, data warehouses and/or data lakehouses
• Advanced SQL skills, including performance tuning and dimensional modeling
• Strong experience working in at least one cloud platform (AWS, Azure, GCP, Snowflake, Databricks)
• Experience with orchestration tools (Airflow, Prefect, Dagster, etc)
• Experience designing microservices‑based architectures and APIs to build platforms that are flexible, scalable, and resilient
• Familiarity with Business Intelligence tools (Tableau, Qlik, Power BI)