The Enterprise Data Architect will play a significant role in design, development and maintenance of the operational and data warehouse systems. The Data Architect is responsible for being the thought leader to define strategy and standards for improving and extending data architecture, security, and scalability within the enterprise platform. The Data Architect is responsible for working with the product operation, software development team, and product management to share in responsibilities for database and software architecture and meeting product service levels. Their purpose is to create a high level of customer satisfaction by assuring the quality, stability, and performance of the software product infrastructure and offerings.
Provide technology leadership for architectural governance across multiple data management efforts.
Propose options to meet enterprise SaaS data management needs using core enterprise data architecture principles. Demonstrated through diagrams and other written artifacts.
Communicate effectively with various business and technical groups to understand, document and communicate design changes to application and reporting data architecture.
In collaboration with DBA and developers, build and maintain high quality, scalable and performance database packages, processes and data structures including the OLTP, Data Warehouse Models and Data Interchange.
Produce an appropriate set of documentation must be maintained to facilitate redundant coverage of critical processes.
Contribute to maintenance of database dictionaries and integration of systems throughout the enterprise data architecture.
Work with team to develop and govern best practices, policies and design of the database systems.
Assist BI developer with design, development, documentation, mapping and building data loading and transformation processes.
Ability to handle difficult situations with diplomacy and tact
Ability to communicate clearly to varied audiences in writing, by phone, and in person
Strong motivation to create customer satisfaction through the delivery of high quality end-user applications and by solving real problems for real users
Self-starter able to work with little supervision
Proven analytical and problem-solving abilities.
Ability to diagnose and solve problems creatively
Must work well in fast-paced, constantly changing environment
Bachelors degree in information technology, computer science, or related field
Advanced enterprise database architecture experience
Minimum 7-10 yrs progressive experience working with Microsoft SQL server 2008 or better, including SQL Svr, SSIS, SSAS.
5-7 years of experience developing and working understanding of SaaS systems spanning multiple data centers.
Working knowledge in transactional and dimensional database modeling and development.
Familiarity with performance optimization techniques.
Good understanding of algorithms and data structures.
Extensive database and operating system experience with SQL server
Extensive experience with data interchange and data integration.
Flexible and adaptable in regards to learning and understanding technology.
Strong written and oral communication skills.
Healthcare industry experience desirable.
VanderHouwen & Associates, Inc. (VHA) was founded in 1987 to provide Professional Staffing Services to Portland, the Pacific Northwest, and...