DW BI 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

Paradigm Infotech. Inc is a global IT solutions provider focused on delivering customer value through high Quality Processes and Cost-efficient solutions. Paradigm has been one of the trendsetters in global delivery practices with our Client-Centric Model for customer management and delivery.

Job Description

Role Summary:
The Data Warehouse Architect is responsible for defining Enterprise Data Warehouse (EDW) solutions that deliver diverse business intelligence capabilities for use in syndicated products, custom projects, and ad‑hoc analysis. This includes establishing architecture and standards, metadata strategy, data quality strategy, ETL, Master Data Management (MDM), as well as Enterprise Information Integration (EII) strategy and standards. Works closely with Core Systems, Operations, Sales and Marketing and other technical and business teams to deliver data warehousing solutions that are reliable, flexible, scalable, and provide low cost ownership.

Essential Duties and Responsibilities

• Leverage data architecture and warehousing skills to build a leading edge EDW encompassing the entire life‑cycle including data integration, transformation, logical and physical design implementing industry best practices.
• Collaborate with TEIS teams and other stakeholders to assess business and system requirements to develop and implement scalable EDW solution that meets current and future needs.
• Lead Data warehouse Dimensional Modeling efforts including defining the Data Model Design and Naming standards from the Database to the BI Layer to ensure consistency.
• Participate in the design, development, documentation and application of best practices and procedures that govern EDW implementations and operations.
• Document and diagram the proposed solutions to present to management, IT groups and project stakeholders. Prepare functional specifications and data dictionaries.
• Participate in the resolution of complex performance issues or enterprise failures involving critical business processes. Help to provide root cause analysis and recommend solutions.
• Provide technical mentoring, guidance, and training to EDW support and user teams throughout the organization.
• Stay informed of current technologies and best practices.

Qualifications

• 8‑12 years of technical experience in Data and Information architecture design delivering large (multi‑terabyte) EDW solutions integrating many heterogeneous data sources.
• Hands‑on experience in Data Warehouse technical development with strong understanding of data management life‑cycle in establishing end‑to‑end data warehousing, data management, and business intelligence architecture.
• In depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc.
• Comprehensive knowledge of relational and dimensional data modeling practices and implementation techniques and where they are best utilized.
• Expertise in one of the RDBMS databases (Teradata, Oracle…). SAP HANA In‑Memory database experience is a plus.
• Prior experience with ETL design, query performance tuning and process optimization skills.
• Experience with one of the Leading Business Intelligence Tools (SAP Business Objects, Microstrategy, …).
• Prior experience using SAP ERP as a data source to the Datawarehouse would be a plus but not required.
• Excellent communication skills and ability to translate complex technical issues to a non‑technical audience.

Additional Information

• Please describe the total number of years and type of experience with Business Intelligence/Datawarehouse environment.
• Please describe any experience developing Business Intelligence, Datawarehouse and Analytics Strategy for a organization.
• Please describe any experience interacting with the business users to understand business requirements and translating those to BI Data Architecture Design.
• Please describe years of experience with implementing data warehouse solutions with HANA, Oracle, Teradata ..databases.
• Please describe your design and architecture experience with implementing data integration (ETL/Data Quality), Metadata Management solutions.
• Please describe your experience with leading Business Intelligence Tools (SAP Business Objects …).
• Please describe your experience leading or managing project teams including team size for the various Business Intelligence project teams.
• Please describe any experience working with SAP Business Warehouse (SAP BW) Solutions which is a nice to have but not required for this role.