Sr Data Warehouse Engineer

Location: Pittsburgh

Job Type: Contract

Job Description: Under general direction, primarily responsible for activities related to the 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). – Maintains and updates 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 – Strong database schema design experience – Working knowledge of data warehouse approaches 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 – Experience developing data warehouses using AWS cloud based ETL, storage and analytic services. Athena, Glue, RDS, RedShift, etc. – Experience with MySql – Experience in Healthcare sector. – Strong knowledge of policies and best practices governing the handling of PHI