JOB DESCRIPTION

Roles and Responsibilities : Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements. Develop data warehouse process models, including sourcing, loading, transformation, and extraction. Create or implement metadata processes and frameworks. Proficiency in design and implementation of data warehouse inMSBI stack (SQL server, SSIS,SSAS,SSRS, Power BI). Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. Design and implement warehouse database structures. Develop and implement data extraction procedures from other systems, such as administration, billing, or claims. Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases. Implement business rules via stored procedures, middleware, or other technologies. Map data between source systems, data warehouses, and data marts. Evaluate all data and perform various tests on data warehouse and ensure effective implementation. Administer all data and ensure compliance to standards and policies. Maintain high quality of all deliverables and provide efficient guidance to all database architecture. Review all new tools and methodologies on various data processes for warehouse. Communicate how data (structured & unstructured) is created, modified, consumed and flows through the enterprise. Communicate how to maximize the value of information to the organization Ensure that the appropriate level of architecture diligence is applied across all initiatives in a consistent manner Coordinate closely with business owners, solution teams and design teams to ensure that solution architectures are fit-for-purpose and adequately meet data requirements Manage and continuously improve the design and implementation of Information and Data Architecture processes and artifacts Understand and advocate information/data architecture and Enterprise Architecture (EA) principles and be prepared to "sell" the information/data architecture process, its outcome and ongoing results Coordinate closely with technical and Business analysts to ensure EA and business interests are taken into account Coordinate closely with business data architects to ensure adherence to documented procedures and standards Responsible for guidance on high level solutions for information/data architecture requirements Assist, coach and mentor information/data architecture practitioners. Experience working with health organizations Excellent interpersonal skills in areas such as teamwork, facilitation and negotiation Strong written and verbal communication skills Excellent skills in data management, data modeling, data services, reporting, and analytics as well as the tools used to support these areas Ability to understand the long-term ("big picture") and short-term perspectives of situations Ability to translate business needs into architecture requirements Understanding of business process principles and tools Understanding of application development methodologies Experience in data integration and data conversions preferred Ability to quickly comprehend the functions and capabilities of new technologies Knowledge of Enterprise Architecture Fundamentals; exposure to Enterprise Architecture software tools desirable