Senior SQL Developer – Data Pipelines & BI (Onsite NYC)

Atlas Search; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

Atlas Search, an investment firm in New York, is seeking a SQL Developer to join the team and help build a Valuations Aggregation tool to replace a third‑party vendor product. You will migrate and reconcile data from the vendor platform, validate pricing and quantity data for accuracy, and build SQL views and stored procedures on SQL Server (on‑prem) for the app and downstream reporting.

You will also create SSIS pipelines and support the Power BI reporting layer.

Responsibilities

• Migrating and reconciling data from the vendor platform into the new tool
• Validating pricing and quantity data for accuracy and completeness
• Building and maintaining SQL views/stored procedures on SQL Server (on-prem) for the app and downstream reporting
• Tracing data lineage end-to-end — from a value on the UI back to its source
• Building/maintaining SSIS pipelines from external sources
• Supporting the Power BI reporting layer

Job description

Atlas Search, an investment firm in New York, is seeking a SQL Developer to join the team and help build a Valuations Aggregation tool to replace a third‑party vendor product. You will migrate and reconcile data from the vendor platform, validate pricing and quantity data for accuracy, and build SQL views and stored procedures on SQL Server (on‑prem) for the app and downstream reporting.

You will also create SSIS pipelines and support the Power BI reporting layer.