Data Warehouse Architect in New York, NY at Engage Partners, Inc.

Date Posted: 1/17/2021

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    New York, NY
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    1/17/2021

Job Description

Summary: Under the supervision of the Director of Infrastructure & Development, the Data Warehouse Architect will collaborate with stakeholders from within and outside the organization and maintain an enterprise data strategy and information architecture supporting business objectives. He/she will primarily be responsible for activities related to the architecture, design, development, implementation, and support of the data warehouse. Essential Duties and Responsibilities:  Acts as a technical conduit with internal stakeholders to onboard new data sources to the DW.  Translates business requirements into functional and technical design specifications.  Leads discussions across business areas and teams and communicates business and technical requirements in terms that are understandable for technical and non-technical audiences.  Designs the technical and information architecture for the data warehouse (DW), including all information structures (staging area, data warehouse, data marts, and operational data stores).  Focuses on enterprise-wide data modeling and database design.  Creates logical and physical data models, mapping logical to physical.  Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.  Coordinates with other Data Warehouse stakeholders to ensure overall health and performance of the data warehouse environment.  Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment.  Assists in the evaluation, selection, testing, and optimization of business intelligence (BI)/DW related hardware and software products.  Develops and applies sound fundamental design, analysis, and data administration concepts, practices, and procedures.  Designs and develops BI reporting deliverables.  Provide support after hours and on weekends, when necessary. Qualifications:  Bachelor's degree with 7+ years of work experience in design and implementation of data models for complex data warehouse initiatives.  Minimum 4 years of experience working with healthcare data and other data models.  Minimum 4 years of strong experience to design scalable data models and data flows.  Mandatory Skills: ETL, MDM, Cloud (Azure, AWS), Data Analytics and Governance.  Desired Skills: Oracle Database Integration, Agile (Scrum), Enterprise Data Lake (EDL), CI/CD, and Java/Camel.  Proficiency with some leading data profiling tools (such as SQL, BI tools, etc.).  Experience with Enterprise Data Warehouse initiatives including Data Model development, Semantic/Data Access Layer Development, Reporting and Dashboard Creation; developing solutions for shared data usage.  Experience with a Data Modeling tool and in developing processes to manage data model development, principles, and standards.  Exposure to and understanding of Analytical Architectures.  Consulting and facilitation Skills.  Advanced decision-making and problem-solving skills.  Business acumen, knowledge and professionalism.  Strong analytical, problem solving, and work management skills.  Customer-focused ability to communicate across all levels of the organization.  Proactive Leadership style; self-starter and strong attention to detail.  Proficient in MS Office (Word, Excel, Access, PowerPoint, MS Project, Visio, SharePoint). Education: Bachelor’s degree in Computer Science or similar relevant field