SQL Developer

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

We’re working with an investment firm that needs a SQL Developer to join their team.

The team is building a Valuations Aggregation tool to replace their third‑party vendor product.

The ideal candidate will have:

• 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

5+ years of experience

3 days onsite in NYC – must be local/commutable. Not accepting remote candidates