SoHo Dragon represents an investment bank with offices in New York, NY that needs to hire a SQL Server Developer - Reporting & Analytics.

• 5 years experience designing and developing Enterprise Data Warehouse solutions.
• 5 years proficient writing SQL queries and programming including stored procedures and reverse engineering existing process.
• Data Warehouse design principles and data modeling experience.
• 3 years leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, etc) to develop data pipeline solutions to ingest and exploit new and existing data sources.
• A significant contribution to an enterprise-wide Cloud Data Platform migration.
• Analyze and work from requirement to realization. 

Your expertise

• Strong analytical and problem-solving skills.
• Advanced SQL expertise.
• Data Warehouse concepts knowledge.
• ELT/ETL pipeline experience.
• Scripting language Python and or PowerShell experience.
• Ability to work both in a team and individually.
• Good written and spoken English communication skills.
• Jira ticketing system

Considered an advantage

• Previous experience with Axiom Reporting and Analytics Platform is strongly preferred.
• Azure Cloud platform experience.
• Azure Data Factory or similar ETL tool.
• Azure Data Bricks experience.
• Columnar Data Warehouse solution like Snowflake, RedShift, Vertica, Greenplum.
• Capital markets experience a plus.