New York City, NY, USA
6 days ago
Data Warehouse Architect
Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed 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 Client 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.

Confirm your E-mail: Send Email