Info Design Architect I/II-007020

Summary:

The Information Design Architect creates solutions that provide quality information to enable informed analytic business decisions. The Information Design Architect understands business needs and requirements and translates them into solutions. He or she consults with business and technology teams to ensure alignment between solution definition and enterprise architecture for the Excellus organization.

This position provides leadership, direction, and planning in support of the goals and objectives of the Enterprise Information Technology (EIT) organization, with a primary focus on the design and implementation of analytic solutions in a complex enterprise environment. This includes analytic solution designs for Business Intelligence (BI), Data Warehouse (DW), Operational Data Store (ODS), and decision support Data Marts/Applications. These solutions and their related components are aligned with Enterprise Information & Data Strategy and Enterprise Architecture standards. The Information Design Architect works collaboratively with Data Integration Engineers, Data Administrators, Enterprise Architects, Solution Architects, Data Architects, Business Intelligence Analysts, and others to assure all aspects of the solution are well-thought-out.

Essential Responsibilities and Accountabilities

Level I:• Works with Business Sponsors and Stakeholders to ensure analytic and information requirements are clearly defined, documented and broadly communicated. At times, this may include assisting and/or contributing in the creation of a Business Requirement Documents (BRD).• Identifies / designs required changes to data model within the analytic environment (EDW or other database) taking into account the analytic business needs, and the ability to develop, support and query against the data model. Normally documented in a Function Approach Document (FAD) and/or similar type of documents.• Identifies appropriate sources of data that meet the business requirements and confirms data is of appropriate quality, completeness, etc. Typically accomplished via data profiling and captured in a Source to Target (STT) mapping document. • 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.• Conducts peers reviews of all Analytic Solution Design deliverables including BRD, FAD, and Source to Target mappings, and change requests.• Participates, as appropriate, in ETL Design reviews, testing approach / test case reviews.• Responsible for final work product within assigned projects as related to data, data design, transformations and quality of results.• Conducts analysis of production fallout to determine if production code is working as designed and how data issues should be prioritized and corrected.• Participates in rotating on-call support schedule working with DW Operations team as level 2 support.• Meets with management, sponsors, and project teams to review project scope/progress and resolve project issues. • Identifies, designs and implements contingency approaches as needed to address schedule revisions, data/system availability, resource adjustments, funding allocations, and work requirements.• Adheres to corporate, divisional and departmental policies, standards and procedures.• 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. • Develops and maintains current, personal knowledge and skills on industry and professional trends and activities in Information Management, Data Warehousing and Business Intelligence. Shares learning and coaching experience through knowledge transfer between peers and outside contractors.• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct.• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.• Regular reliable attendance is expected and required.• Performs other functions as assigned by management.

Level II - in addition to Level I responsibilities:• Leads research, analysis, and design activities to ensure analytic solutions are appropriate and directly support the business, enterprise information and data strategies, with a focus on Data Warehousing, Operational Data Stores, Master Data Management and Business Intelligence. • Leads prototyping activities, as needed, and makes recommendations for the overall solution design.• Leads data profiling activities, and engages others within IT and the business as appropriate.• Often fills role of project spokesperson. Writes and speaks fluently on all aspects of work. Communicates effectively with business customers, colleagues across a range of disciplines, and all levels of management. Directly negotiates with and functions as a liaison between other IT resources, business stakeholders and external vendors/partners.• Provides thought leadership to envision new ways of leveraging information. Strong influencing and change management skills are critical to success.• Acts as a point person when multiple Information Design Architects are assigned on a project. • Leads efforts across the organization to improve design processes/procedures to improve the quality and make us more efficient. • Serves as mentor/coach for less experienced Information Design Architects.• Acts as a liaise with the business community as a technical expert for understanding the data in the repositories.

Minimum Qualifications

NOTE:

We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.

Level I:• Bachelor's degree in Computer Science, Information Technology or relevant field (or four additional years related work experience in lieu of bachelors).• Eight years of strong technology implementation/related experience with at least three years in multiple full lifecycle BI/DW/ODS implementations required. • Demonstrated experience with Data Warehousing / Data Analytics.• Must have complete lifecycle experience in data warehousing with multiple projects. • Demonstrated experience with conceptual or logical data modeling.• Demonstrated skills in implementing application and process solutions utilizing a structured SDLC.• Demonstrated skills in quality principles especially root cause analysis and problem solving.• Demonstrated business process development skills and strong technical problem solving skills.• Ability to interact favorably with internal and external audiences. • Extensive knowledge of analytics concepts and technology.• In-depth knowledge of application delivery, management structures, and reporting procedures.• Excellent written and verbal communication skills - highly effective communicator with a strong customer satisfaction orientation.• Demonstrated experience in integrating enterprise applications.• Demonstrated analytical experience such as data analysis, data usage analysis, and/or business data analysis. • Ability to learn and apply intermediate to advanced SQL skills• Demonstrated experience with ad-hoc analysis tools such as TOAD, SAS, Cognos, Access, and/or other type of analytic tool. • Must have a strong understanding of what is involved in and how to deliver an end-to-end analytic solution. • Experience with ETL tools such Informatica a plus.• Experience working in an Oracle strongly preferred.• Experience working in an Teradata preferred. • Experience with Service Oriented Architecture (SOA) a plus.• Experience with HTML and HL7 a plus.• Experience with Master Data Management a plus.• Knowledge of Healthcare Payer industry a plus.• Capable of successfully delivering on multiple projects and priorities simultaneously.• Strong team player with a high level of interpersonal skills.• Demonstrated competence in team leadership/technical leadership, facilitation, and project leadership tasks.• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct.• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.• Regular reliable attendance is expected and required. • Performs other functions as assigned by management.

Level II - in addition to Level I Qualifications:• Eleven years of strong technology implementation/related experience with at least five years in multiple full lifecycle BI/DW/ODS implementations required.• Strategic vision in alignment with business objectives.• Demonstrated experience in a leadership role with high levels of user interaction, analytics design, and solution delivery. • Ability to work effectively with minimal supervision and serve as a mentor to other team members.

Physical Requirements:• Ability to travel across regions.

The Lifetime Healthcare Companies aims to attract the best talent from diverse socioeconomic, cultural and experiential backgrounds, to diversify our workforce and best reflect the communities we serve.

Our mission is to foster an environment where diversity and inclusion are explicitly recognized as fundamental parts of our organizational culture. We believe that diversity of thought and background drives innovation which enables us to provide leading-edge healthcare insurance and services. With that mission in mind, we recruit the best candidates from all communities, to diversify and strengthen our workforce.

OUR COMPANY CULTURE:

Employees are united by our Lifetime Way Values & Behaviors that include compassion, pride, excellence, innovation and having fun! We aim to be an employer of choice by valuing workforce diversity, innovative thinking, employee development, and by offering competitive compensation and benefits.

In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)