The Datawarehouse Architect will be primarily responsible for activities related to the architecture, design, development, implementation, and support of the data warehouse.
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
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.
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.