Reg: Data Warehouse Architect-3 days onsite in NYC, NY-Only w2

Title: Data Warehouse Architect

Location: 3 days onsite in NYC, NY

Duration: 12 month contract

Must haves:
Design systems built around complex data;

ability to influence and lead by example;

ability to clearly articulate ideas and positions

Job Description:
Requires advanced expertise in stored procedure programming, data modeling, replication, performance monitoring and optimization, and database administration. Collaborate effectively in a small, fast-paced, team environment. Assist in designing .Net data tier components for multiple multi-tiered systems using Microsoft and/or Oracle and Java technologies. Estimate database/data tier development efforts. Design and optimize database schemas for a variety of applications and processes. Work with developers and system architects to design high performance, highly reliable data systems. Document and implement data tier/database Standards and Operational Procedures (SOPs). Design and implement Data Access Layers (DAL) components using Stored Procedures. Ensure developers use good coding techniques in both application development and stored procedures (database and DAL code review process). Interface with infrastructure teams to ensure monitoring and appropriate maintenance procedures are followed. 10+ years' relevant work experience required.

• Data governance - enhance the PtB process to integrate data governance concepts to ensure adherence to established data standards.

• Data analytics - provide architectural guidance on business intelligence, data analytics, and data transformation tools.

• Provide design leadership on projects to adopt new technologies such as Snowflake, Collibra DQ, Alteryx, Thoughtspot, etc.

• Participate in the PtB process for new technologies and changes to existing production systems.

Manager Release Notes:

• Is the goal to convert the candidate to FTE? Yes, contract to hire

• How many years of experience are required? 10 years' related experience

• Is previous experience in the financial services industry required? Not required but helpful

• Is a college degree required? If so, what type? No, relevant experience is more important

• How many days per week will this candidate work onsite? 3

• Can candidates sit in other BNY locations such as Pittsburgh or Lake Mary? Pittsburgh is a possibility

• Can this candidate work 100% remotely supporting EST hours? No

• What are the top 3 skills required? Design systems built around complex data; ability to influence and lead by example; ability to clearly articulate ideas and positions

Thanks & Regards,

Rakesh