Create a Job Alert.

Enter your email below to save this search and receive job recommendations for similar positions.
Thank you. We'll send jobs matching these to
You already suscribed to this job alert.
No Thanks
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply on company site

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
Data Warehouse Architect at Engage Partners, Inc.

Data Warehouse Architect

Engage Partners, Inc. New York, NY Full-Time
Apply on company site
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.
  • 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).
Bachelor’s degree in Computer Science or similar relevant field

Recommended Skills

Data Warehousing
Business Intelligence
Data Extraction
Extract Transform Load (Etl)
Data Profiling
Mobile Device Management
Get job alerts by email. Sign up now! Join Our Talent Network!

Job Snapshot

Employee Type



New York, NY

Job Type



Not Specified

Date Posted


Job ID

Apply to this job.
Think you're the perfect candidate?
Apply on company site