DW BI Architect

Paradigm Infotech Inc.; Harrisburg (Dauphin County); On-site; USD 100,000 - 130,000; Full time

Job summary

Paradigm Infotech is seeking a Data Warehouse Architect to define and implement Enterprise Data Warehouse solutions. This role involves collaboration with various teams to create scalable and effective data warehousing solutions while ensuring adherence to industry standards. The ideal candidate will have significant experience in data architecture, management, and business intelligence tools.

Qualifications

• 8-12 years of experience in Data and Information architecture design.
• Hands-on experience with large EDW solutions.
• Expertise in RDBMS databases and ETL design.

Responsibilities

• Define Enterprise Data Warehouse solutions for diverse business intelligence capabilities.
• Lead Data warehouse Dimensional Modeling efforts.
• Document proposed solutions to present to management and stakeholders.

Skills

Data Architecture

Data Integration

Data Quality Assessment

Metadata Management

Data Management Life-cycle

Education

Bachelor's Degree in Computer Science or related field

Tools

Teradata

Oracle

SAP HANA

SAP Business Objects

Microstrategy

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.

Qualifications

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

Screening Questions:

1) Please describe the total number of years and type of experience with Business Intelligence/ Datawarehouse environment?

2) Please describe any experience developing Business Intelligence , Datawarehouse and Analytics Strategy for a organization?

3) Please describe any experience interacting with the business users to understand business requirements and translating those to BI Data Architecture Design

4) Please describe years of experience with implementing data warehouse solutions with HANA , Oracle , Teradata ..databases ?

5) Please describe your design and architecture experiencing with implementing data integration (ETL/ Data Quality) , Metadata Management solutions ?

6) Please describe your experience with leading Business Intelligence Tools ( SAP Business Objects … ?


7) Please describe your experience leading or managing project teams including team size for the various Business Intelligence project teams

8) Please describe any experience working with SAP Business Warehouse (SAP BW) Solutions which is a nice to have but not required for this role?