Our Insurance client is looking for Data Integration Architect in Rochester, NY who will be able to designs the way to link data files, stores and repositories together to deliver data as a strategic enterprise asset. Description: As such, they are responsible for the Data Integration Architecture across master, transactional, operational, reference, unstructured, and meta data domains via reusable data services and solutions. The Data Integration Architect must understand and communicate how to integrate data in support of EHP current and future business operations and capabilities. They must be able to explain the effects future integrated processes will have on the use of data at EHP. Responsibilities / Accountabilities: Works with data integration analysts and business analysts to understand the business use cases that the integration solution must support Works with data architects to choose a reference architecture or data integration style to meet the needs of each project, for example, bulk data delivery, data federation, message-oriented movement or real-time data, and conducts peer reviews of Data Integration Architecture deliverables Works hand-in-hand with the project teams to ensure the integration architecture is aligned with and capable of supporting business strategy. Ensures that the data integration reusable services are leveraged, created, or amended in support of the Project’s requirements. Also includes coordinating all Data Integration Architecture deliverables as per the Project Delivery Methodology and providing estimates for work efforts based on priority and scope- Designs integration high level solutions that fit within the enterprise’s larger data integration strategy or initiative, including the choice of data integration tool(s) Interacts with database administrators and data integration developers to meet requirements for volume and performance Understands implementation issues from both business and technical perspective which would require knowledge of, if not deep understanding of, process controls and corporate data governance Functions on multiple levels - from strategic, to tactical implementation Works with data services administrators to develop the data objects and data models to support data services in service-oriented architecture Communicates at multiple levels of an organization, from business leaders, to accountants, to developers within IT Anticipates, identifies and analyzes problems, accepting nothing at face value, instead gaining knowledge through examination of the truth and validity of arguments, classifying the relative importance of ideas, and applying reason, logic and judgment to determine the merits of arguments; ability to develop solutions and decide on the most appropriate solution to achieve the desired outcome in a collaborative manner Fosters an environment of continuous improvement. Constantly exploring ways to increase efficiencies and productivity, reducing waste, and reducing costs Acts professionally at all times and encourages professional standards among team members Works with data stewards to ensure the integration solution meets data delivery and quality SLAs, including performance, in both batch and real-time scenarios Leads the selection of data integration tools Design the movement, enhancement, integration, quality and availability of data throughout the enterprise. Communicate the impact that changes to data have upon these factors to a wide range of stakeholders at all levels of the company Models the future state of the data integration architecture and development of best practices, guidelines and standards for Data Integration Architecture Establishes metrics for tracking and measuring the value of data integration architecture initiatives. For example, measures SLA for data availability, data integration approach impact on project costs or improved data consistency across diverse initiatives Identifies common issues associated with integrating these subject areas in lieu of MDM, and given an MDM implementation: where the issues arise, what the impacts are, and experience in remediating the issues Understands business drivers and uncover the value proposition posed by issue remediation and data integration implementations Documents requirements that are understandable, develops diagrams that can resonate with both business and IT audiences, and develops presentations that both educate on data integration as well as articulate potential gains in business value from successful data integration Understands issues from business perspective based on limited information and ability to analyze situations and develop plans and road maps based on assumptive models driven by available (sometimes limited) information Minimum Qualifications: Bachelor’s degree in Computer Science, Information Technology or relevant field (or four additional years related work experience in lieu of bachelors) 11 years related work experience 7 years of Data Integration Architecture or Data Architecture experience with demonstrated experience utilizing Data Federation and/or Spoke and HUB integration models 7 years of Healthcare experience (preferably with a healthcare payor) Experience in Data Modeling (Conceptual, Logical and Physical). A plus if familiar with master data concepts such as Party, Product, Location, Agreement as well as patterns such as Data Vault 5 years experience with ETL and Data Services platforms such as Informatica Familiar with Data and Enterprise Modeling tools (CA Erwin Data Modeler) Experience working in an Oracle, Teradata, and/or Hadoop QL Expertise, ability to use query tools such as TOAD- Familiar with Data Virtualization Tools such as Composite Familiar working with Messaging Platforms such as MQ Experience with data integration technologies, solutions and patterns required, including Service Oriented Architecture (SOA), Data Warehouse (Kimble, Inmon, Data Vault), Operational Data Stores (ODS), Enterprise Service Bus (ESB), and Change Data Capture. Knowledge of when, where and how these components fit into an enterprise data architecture environment Experience in Leading Data Integration teams and processes Familiarity with real time integration platforms such as WebSphere MQ, Message Broker or equivalent Experience with ETL and Data Services platforms such as Informatica Knowledge of a variety of integration protocols and formats such as SOAP, REST, EDI, HL7, JSON, Copybook Experience with NoSQL technologies is desirable Experience with Big Data and CEP tools such as Hadoop or Storm is desirable Familiar with Master Data Management Solutions- Experience with the use cases, business purposes and quality of the data Experience with process/workflow modeling and application integration Ability to interact favorably with internal and external audiences Strong team player with a high level of interpersonal skills Excellent written and verbal communication skills - highly Effective communicator with a strong customer satisfaction orientation Capable of successfully delivering on multiple projects Familiar with master data concepts such as Party, Product, Location, Agreement as well as patterns such as Data Vault Experience with Data and Enterprise Modeling tools (CA Erwin Data Modeler) Experience with Data Virtualization Tools such as Composite Experience working with Messaging Platforms such as MQ Experience with real time integration platforms such as WebSphere MQ, Message Broker or equivalent Advanced knowledge of a variety of integration protocols and formats such as SOAP, REST, EDI, HL7, JSON, Copybook. Serves as mentor to other team members. Ability to align strategic vision with business objectives. Demonstrated experience in a leadership role. As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws