Data Warehouse Architect

Location: Pittsburgh

Job Type: Contract to Hire

Job Description Under general direction, primarily responsible for activities related to the architecture, design, development, implementation, and support of the data warehouse. Essential Duties: – Participates in the design of the technical and information architecture for the data warehouse, 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 business, operations and engineering stakeholders to ensure overall requirements, health and performance of the data warehouse environment. – Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools. – Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment. – Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products. Additional Duties: – Develops and applies sound fundamental design, analysis, and data administration concepts, practices, and procedures. – Designs and develops BI reporting deliverables. – Performs other duties as required. Qualifications – Bachelors degree in Computer Science or related field; or, an equivalent combination of education and relevant business experience. – Five or more years of experience with data warehousing and business intelligence and/or large and complex database management systems. – Strong relational and dimensional data modeling and database design skills. – Hands-on experience using ETL tools. – Possesses interviewing, observing, questioning, and analyzing skills. – Working knowledge of data warehouse approaches, architecture and development. – Customer-oriented with excellent interpersonal communication skills. – Highly effective analytical, decision-making, and written/verbal communication skills. – Ability to investigate complex business problems, develop effective recommendations, negotiate and/or present solutions, and resolve problems in a highly professional and tactful manner. – Highly organized and able to set priorities effectively. Preferred candidate experience – Working knowledge of AWS services and best practices. – Experience developing data warehouse strategies using AWS cloud based ETL, storage and analytic services. – Experience in Healthcare sector. – Strong knowledge of policies and best practices governing the handling of PHI

APPLY NOW