The Datawarehouse Architect will be primarily responsible for activities related to the architecture, design, development, implementation, and support of the data warehouse.

RESPONSIBILITIES

• Participate 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)
• Focus on enterprise wide data modeling and database design
• Create logical and physical data models, mapping logical to physical
• Design, develop, test, monitor, manage, and validate data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes
• Coordinate with business, operations and engineering stakeholders to ensure overall requirements, health and performance of the data warehouse environment
• Work with end users to translate business questions and requirements into applications that employ the appropriate reporting tools
• Assist 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
• Develop and apply sound fundamental design, analysis, and data administration concepts, practices, and procedures
• Design and develop BI reporting deliverables

REQUIREMENTS

• Bachelor's 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
• Handson 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
• 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

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.