Data Architect (Senior Consultant MIS Lvl C), Data Sciences and Support

Empower Every New Yorker - Without Exception - to Live the Healthiest Life Possible

NYC Health + Hospitals is the largest public health care system in the United States. We provide essential outpatient, inpatient and home-based services to more than one million New Yorkers every year across the city's five boroughs. Our large health system consists of ambulatory centers, acute care centers, post-acute care/long-term care, rehabilitation programs, Home Care, and Correctional Health Services. Our diverse workforce is uniquely focused on empowering New Yorkers, without exception, to live the healthiest life possible.

At NYC Health + Hospitals, our mission is to deliver high quality care health services, without exception. Every employee takes a person-centered approach that exemplifies the ICARE values (Integrity, Compassion, Accountability, Respect, and Excellence) through empathic communication and partnerships between all persons.

Job Description

The Data Architect is primarily responsible for the design, implementation and maintenance of data models to support the needs of data warehouses and data marts. The position is responsible for recommending and adopting best practices to ensure high data quality standards, repeatability and scalability of data models are designed and maintained and data redundancy is reduced.

Duties & Responsibilities

• Understand and translate business needs into data models to satisfy enterprise analytics & reporting needs
• Work with the EIM team to design and implement data strategies, build data flows and develop conceptual, logical and physical data models.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to enterprise standards

Minimum Qualifications
1. A Baccalaureate Degree from an accredited college or university with a major in Computer Science, Systems Engineering, applied Mathematics, Business Administration, Economics/Statistics, Telecommunications, Data Communications, or a related field of study; and
2. Five (5) years of progressive, responsible experience in the field of data processing, computer systems and applications.
Operations Specialty requires supervisory experience (5 years).
Network Services requires a telecommunications background and experience.
3. Broad knowledge and expertise in the characteristics of computers, peripheral devices, communications systems and hardware capabilities, programming languages, E.D.P. applications, systems analysis methodology, data management and retrieval techniques; or
4. A satisfactory equivalent combination of training, education and experience.

Department Preferences

Knowledge, Skills, Abilities and other Requirements:

• Proficiency with some leading data profiling tools (such as SQL, BI tools, etc).
• Experience with Enterprise Data Warehouse initiatives including Data Model development, Semantic/Data Access Layer Development,
• Proficiency with some leading data profiling tools (such as SQL, BI tools, etc).
• Experience with Enterprise Data Warehouse initiatives including Data Model development, Semantic/Data Access Layer Development, Reporting and Dashboard Creation; developing solutions for shared data usage.
• Experience with a Data Modeling tools (such as Erwin) and in developing processes to manage data model development, principles, and standards.
• Experience with a Clinical industry focused data model preferred.
• Exposure to and understanding of Analytical Architectures.
• Consulting and Facilitation Skills.
• Advanced decision making and problem-solving skills.
• Business acumen, knowledge and professionalism.
• Strong analytical, problem solving, and work management skills.
• Customer-focused ability to communicate across all levels of the organization.
• Proactive Leadership style; self-starter and strong attention to detail.

Years of Experience:

• 7+ years of work experience in design and implementation of data models for complex data warehouse initiatives.
• Minimum 3 years of experience working with healthcare data and revenue cycle data models.
• Minimum 7 years of experience in designing scalable enterprise data models

Special Equipment/Machines/Applications Operated:

• PC and/or OS operating systems
• Microsoft Office (Word, Excel, Access, PowerPoint, MS Project, Visio, SharePoint)
• SQL, BI Tools
• EDW (Snowflake)
• Data Modeling Tool ex: Erwin

If you wish to apply for this position, please apply online by clicking the "Apply for Job" button.

If applying online, please include your cover letter in the same file attachment with your uploaded resume.

NYC Health and Hospitals offers a competitive benefits package that includes:

• Comprehensive Health Benefits for employees hired to work 20+ hrs. per week
• Retirement Savings and Pension Plans
• Loan Forgiveness Programs for eligible employees
• Paid Holidays and Vacation in accordance with employees' Collectively bargained contracts
• College tuition discounts and professional development opportunities
• Multiple employee discounts programs

Note: Candidates selected for a position are required to come to NYC as part of their onboarding.