IT Solution Designer

PRINCIPAL RESPONSIBILITIES:

IT Solution Designer is responsible to ensure the suite of applications being used within the Alliances IT department is scalable, reliable, available and manageable. This role requires a blend of technical expertise, creativity, and strong communication skills to translate healthcare business requirements into scalable and efficient IT solutions, with a particular focus on AWS, SSIS, and Oracle technologies.

Engage with stakeholders from both IT and healthcare sectors. Provide clear communication, comprehend their expectations, and offer sustainable and balanced solutions that span across different applications. Work towards a mutual understanding with interdisciplinary stakeholders, discern and record suitable solutions, and convey intricate designs effectively within the existing framework.

Offer expert leadership and direction throughout the development process of the solution. Execute initiatives for designing solutions that demonstrate tangible business improvements aligned with the company's strategies. Must possess comprehensive responsibility and ownership over the solution design and its architectural elements. Must create solution design roadmaps and develop frameworks for the technology architecture, efficiency, data consolidation, and application layers in the context of the company's wider systems environment. Responsible for crafting solutions in projects, advancing technological abilities, and various operational sectors. Ensure that solutions align with healthcare regulations, architectural standards, security policies, and best practices.

Principal responsibilities include:

Develop a Roadmap and a high-level systems design document to outline application and systems integration, and the overarching design strategy for stakeholders such as IT Management, DBAs, IT Infrastructure personnel, Application Managers, Developers, IT Security staff, Business Stakeholders, and Project Teams.

Create database models and designs to meet organizations strategic needs. Strong understanding of database concepts and database modeling techniques.

Perform analysis of business requirement and develop physical and logical data model for Datawarehouse to support them.

Translation of conceptual architecture to logical and technical architecture diagrams and solutions which can be implemented by the dev team.

Give comprehensive solutioning and designs that focus on scalability, manageability and reusability in terms of the existing database structures/modules.

Develop approaches for warehouse implementation, data acquisition and archive recovery strategy.

Create technical documentation, reports, and diagrams that depict the present and future state of data integration, as well as application and interoperability solutions.

Have technical understanding of data models, data standards and business glossary.

Must possess a wide range of skills in designing solutions, encompassing database and data warehousing, front-end technology and frameworks, infrastructure factors, and API integration. Ensure clear communication with various stakeholders and achieve agreement to embrace and execute the solution designs that backs key IT and business strategies.

Ability to articulate Current State and Propose Future state with a feasible migration path to stakeholders.

Proven experience in designing and implementing complex IT solutions, including software applications, integrations, and infrastructure in the healthcare domain.

Collaborate with the Data Integration Director and other IT stakeholders on Infrastructure, Data Security, and Data Governance to create architectural artifacts that adhere to both regulatory and AAH's internal standards and policies.

Design ETL integration solutions and produce all design phase deliverables including technical design documents, flowcharts, mappings and evaluating impacts to performance and scale to support SLA as required.

nalyze data issues, identify, and articulate the business impact of data problems.

Develop a Data Integration Solution design for EDI and Data Systems, including Data Warehouse, ODS, Vendor platforms, among others.

[]{style="line-hei

"}