Data Architect (Remote/Telecommuting-in NYS)

PLEASE NOTE: With limited exceptions, our company is requiring all employees to be vaccinated against COVID-19 by Jan. 1, 2022. We also currently mandate vaccinations for employees who enter our buildings. Please keep this in mind when applying for positions at our organization. SummaryKey responsibilities are to architect and design large scale, high volume, transaction processing and analytical data systems & solutions. This position leads/participates in defining Data Architecture Standards & Guidelines and the selection of Data Maintenance Tools for use across the organization. Responsibilities include providing prototypes, data architecture & design consultation and mentoring in all phases of the project lifecycle.Essential Responsibilities/Accountabilities Level I• Leads data architecture & design that drives development of large scale, high volume, transaction processing and analytical data systems & solutions• Collaboratively participates in the definition of the Data Architecture Standards & Guidelines by creating, communicating and promoting standards, methods and practice across the organization• Collaboratively participates in the selection/assessment of data management tools, and the development of standards, usage guidelines and procedures for those tools • Provides architecture & design, consultation and mentoring on Data solutions in all phases of planning, development, implementation and maintenance• Participates in prototype development to proof new Data solutions, new Data and ETL technology• Performs the job functions of the data modeler - identifies and organizes the required data logically and physically• Creates and maintains the Enterprise Data Object Reuse Inventory including database/ETL object components.• Assists in the development of overall project plans and timelines• Populates and maintains technical metadata repositories and related documentation• Produces detailed design documents from high-level requirements and functional specifications• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies'' mission and values, adhering to the Corporate Code of Conduct, and Leading to the Lifetime Way values and beliefs. • Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.• Regular and reliable attendance is expected and required.• Performs other functions as assigned by management.Level II - performs the duties of level I in addition to:• Leads the team in the definition of the Data Architecture Standards & Guidelines by creating, communicating and promoting standards, methods and practice across the organization• Provides leadership in the selection/assessment of data management tools, the development of standards, usage guidelines and procedures for those tools• Leads prototype development to proof new Data solutions, new Data and ETL technologyMinimum QualificationsNOTE: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 or relevant field • Demonstrated expertise in the architecture, design and development of large scale, large volume, transaction processing and analytical data systems & solutions• In-depth knowledge, expertise in database internals, data structures, principles and tuning strategies• Experience in SQL programming including advanced queries, stored procedures and triggers in two of the following database technologies: DB2, Oracle or SQL Server• Experience with Entity-Relationship and advanced Dimensional modeling (ERWin Data Modeler or equivalent)• Experience with two of the following: ETL Architecture & Tools (Informatica PowerCenter or equivalent), Data Maintenance Tools (Java or equivalent) and Business Intelligence/Reporting Tools (Cognos or equivalent)• Ability to analyze problems, sort through complex issues, provide a comparative analysis of alternatives and solution recommendations• Ability to work in a team environment and communicate effectively to management and peers, both written and verbalLevel II - requires all qualifications of level I in addition to:• Demonstrated lead expertise in the architecture, design and development of large scale, high volume, transaction processing and analytical data systems & solutions• Experience in SQL programming including advanced queries, stored procedures and triggers in the following database technologies: DB2, Oracle and SQL Server• Experience with the following: ETL Architecture & Tools (Informatica PowerCenter or equivalent), Data Maintenance Tools (Java or equivalent) and Business Intelligence/Reporting Tools (Cognos or equivalent)Physical Requirements************The Lifetime Healthcare Companies aim 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 support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position. Equal Opportunity Employer

Created: 2025-11-15