At Orlando Health, we are ordinary people with extraordinary individuality, working together to bring help, healing and hope to those we serve. By daily embodying our over 100-year legacy, we reinforce our reputation as a trusted and respected healthcare organization that delivers professional and compassionate care to our patients, families and communities. Through our award-winning hospitals and ERs, specialty institutes, urgent care centers, primary care practices and outpatient facilities, our 27,000 team members serve communities that span Floridas east to west coasts and beyond.

Orlando Health is committed to providing you with benefits that go beyond the expected, with career-growing FREE education programs and well-being services to support you and your family through every stage of life. We begin your benefits on day one and offer flexibility wherever possible so that you can be present for your passions. Orlando Health Is Your Best Place to Work is not just something we say, its our promise to you.

Job Summary The Data/BI Architect oversees the overall design of the data and systems architecture for the data warehouse, balancing optimization of data access with batch loading and resource utilization factors. Knowledgeable in all aspects of designing and constructing data warehouses, operational data stores, and data marts that enable informational, analytical management inquiry of well-integrated, subject-oriented historical data. Focuses primarily on logical and physical data modeling and database design, meta data definitions and models, with additional responsibility for business analysis, data acquisition and access analysis and design, DBMS optimization, recovery strategy and load strategy design, and implementation. Serves as team leader in the integration of solutions, constructing data warehouse applications, developing new business opportunities, and building relationships with clients.

Essential Functions

• Develops custom data models, algorithms, visualizations, and reports and builds measurement and predictive models related to business metrics.
• Design relational databases to perform well logically and physically for decision support
• Coordinate new data development and make sure it is consistent and well integrated with existing warehouse structure
• Know star/crystal schemata and fine tune very large databases (VLDBs) for complex queries
• Design key and indexing schemes
• Business analysis, event modeling, data modeling, logical and physical database design, data acquisition analysis and design, data access analysis and design, DBMS optimization, archive and recovery strategy, load strategy design and implementation, security, and change management
• Source data from legacy systems and load it into the warehouse
• Effectively adapt to and apply rapidly changing technology to business needs
• Experience in entity relationship data modeling, with experience using data modeling tools.
• Data acquisition (ETL) development and management
• Meta data management
• Analyze project needs and determine resources needed to meet objectives and solve problems that involve remote and elusive symptoms, often spanning multiple environments in a business area
• Participates in work stream planning process including inception, technical design, development, validation, and delivery of Business Intelligence (BI) solutions.
• Leads functional / project teams to identify areas of improvement, implement improvement initiatives, and monitor results.
• Establishes and maintains collaborative, supportive, and professional relationships with leadership, physicians, vendors, project stakeholders, and team members.
• Maintains reasonably regular, punctual attendance consistent with Orlando Health policies, the ADA, FMLA and other federal, state and local standards.
• Maintains compliance with all Orlando Health policies and procedures.

Education/Training

• Bachelors degree in Computer Science, Engineering, or related discipline.
• Associates degree and two (2) years of directly related work experience may substitute for the Bachelors degree (in addition to the requirements listed in the Experience section).
• High School Diploma or equivalent and four (4) years of directly related work experience may also substitute for the Bachelors degree (in addition to the requirements listed in the Experience section).

Experience

• Eight (8) years of experience in IT with relational database management systems (RDBMSs), with a minimum of four (4) years in data warehouse design of logical and physical models.
• Two (2) years of experience with business intelligence structures and systems (e.g. data mining, ODS, analytical tools).
• DBA experience with some or all: Unix, SQL, Informix, Oracle, Sybase. Business Intelligence: Extensive experience developing requirements for BI, Balanced Scorecard or Advanced Analytics applications.
• In-depth experience designing/implementing relational database solutions
• Experience in several of the following areas is essential:
  • Data modeling techniques
  • Data cleansing software
  • Data replication products and technology
  • Data access software
  • Database performance optimization
  • Mainframe data migration