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

Date Posted: 9/11/2020

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    New York, NY
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
    9/11/2020

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