Senior Enterprise Data Warehouse Architect

Paradigminfotech; Harrisburg (Dauphin County); On-site; USD 100,000 - 130,000; Full time

Job summary

A global IT solutions provider is seeking a Data Warehouse Architect to define EDW solutions and collaborate with various teams. Responsibilities include leading data integration efforts, development, and documentation of best practices, and resolving complex performance issues. Candidates should have 8-12 years of experience in data architecture and be skilled in ETL design and the use of major databases like Teradata and Oracle. Excellent communication skills are essential.

Qualifications

• 8-12 years of technical experience in Data and Information architecture design.
• Hands-on experience in Data Warehouse technical development.
• In-depth understanding of data integration best practices.
• Comprehensive knowledge of relational and dimensional data modeling.
• Expertise in RDBMS databases like Teradata, Oracle.
• Prior experience with ETL design and query performance tuning.
• Excellent communication skills for technical translation.

Responsibilities

• Define EDW solutions for diverse business intelligence capabilities.
• Collaborate with stakeholders to develop scalable EDW solutions.
• Lead Dimensional Modeling efforts and ensure standardization.
• Document proposed solutions and prepare functional specifications.
• Participate in resolving performance issues and recommend solutions.
• Provide technical mentoring to support and user teams.

Skills

Data Warehouse design

Data integration best practices

Data modeling

ETL design

Stakeholder collaboration

Business Intelligence Tools

Communication skills

Tools

Teradata

Oracle

SAP HANA

SAP Business Objects

Job description

A global IT solutions provider is seeking a Data Warehouse Architect to define EDW solutions and collaborate with various teams. Responsibilities include leading data integration efforts, development, and documentation of best practices, and resolving complex performance issues. Candidates should have 8-12 years of experience in data architecture and be skilled in ETL design and the use of major databases like Teradata and Oracle. Excellent communication skills are essential.