Job Description
SoHo Dragon represents an investment bank with offices in New York, NY that needs to hire a Director Level Architect to lead and assist with MS Azure technical support, design and development of ETL pipelines and transformation routines, testing and validation and support for the IT organization.
Major Responsibilities:
- Experience designing and developing Enterprise Data Warehouse solutions.
- Demonstrated proficiency with Data Analytics, Data Insights
- Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process
- Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.
- Improve DevOps initiatives
- Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence
- to established standards.
- Establishing and monitoring Operational Level Agreements for the health and performance/cost of the warehouse environment (Loads, queries, data quality)
- Mentor and guide staff members towards reaching their goals
Skills:
- 10+ years - Enterprise Data Management
- 10+ years - SQL Server based development of large datasets
- 7+ years with Data Architecture
- 5+ years’ experience in Finance / Banking industry – some understanding of Securities and
- Banking products and their data footprints.
- 5+ years Python coding experience
- Proficient with Data Visualization tools
- Hands-on experience with Snowflake utilities such as SnowSQL and SnowPipe
- Working knowledge of MS Azure configuration items with respect to Snowflake.
- Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
- Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
- Previous experience leading an enterprise-wide Cloud Data Platform migration.
- Strong architectural and design skills
- Capable of discussing enterprise level services independent of technology stack
- Experience with Cloud based data architectures, messaging, analytics
- Interest in leading a cutting-edge team, driving the technical vision for a large enterprise
- Superior communication skills
- Cloud certification(s)
Education
- Minimally a BA degree within an engineering and/or computer science discipline
- Master’s degree strongly preferred