Description: The Business Intelligence Data Architect is responsible for assisting with the development of the Electronic Medical Record (EMR) reporting strategy in support of the overall JPS reporting strategy; including overall responsibility for the design, build, and testing of Epic reporting workbench, clarity and enterprise data warehouse (EDW) reports, and providing the overall guidance and structure for creating and maintaining data solutions at JPS. The Analytics and Reporting Data Architect is responsible for establishing and maintaining a cohesive data architecture strategy for internal and external data. This role is also responsible for working with internal customers to set priorities and partner with them to provide strategic direction and optimization of assigned data needs. They bring best practice from industry resources and vendors. In addition, they support and enhance assigned data architecture providing leadership to Reporting Analysts and customers.

Typical Duties:

1. Serves as a lead for the development and execution of the EMR reporting strategy & data architecture strategy, working with the Reporting Manager and Director.
2. Coordinates the analysis of current state reporting requirements.
3. Meets regularly with EMR Team Leads, Managers and Director to identify reporting needs & impact on data architecture.
4. Coordinates input from all EMR teams related to reporting needs and availability of data for reporting.
5. Defines process to identify the reporting data source based on the request type: Epic Workbench, Clarity, Data Warehouse, or other.
6. Develops architecture documentation for the management and executive teams. Designs conceptual and logical data models and flowcharts
7. Analyzes structural requirements for new software and applications.
8. Migrates data from legacy systems to new solutions.
9. Optimize new and current database systems.
10. Assists team members with data design of Clarity and Data Warehouse reports.
11. Works with Sr. BI Analysts to define reporting data marts on top of the Data Warehouse to ease report development and maintenance.
12. Works with the Reporting BI Manager and Infrastructure team using available tools to ensure consistency across reporting infrastructure.
13. Contributes to development of projects, training and testing plans; participate in integrated testing.
14. Oversees the identification and resolution of reporting related issues, and facilitate appropriate escalation of issues for timely resolution
15. Monitors and manages reporting related project management tasks; Report project progress to management.
16. Ensures completion and high quality of deliverables assigned to the team including but not limited to design documentation, build audits, testing plans and scripts, and activation plans.
17. Reviews final product for identified functionality and completeness.
18. Performs other related duties as assigned.