Data Architect

About the Metropolitan Museum of Art The Met presents over 5,000 years of art from around the world for everyone to experience and enjoy. The Museum lives in two iconic sites in New York City—The Met Fifth Avenue and The Met Cloisters. Millions of people also take part in The Met experience online. Since its founding in 1870, The Met has always aspired to be more than a treasury of rare and beautiful objects. We are committed to fostering a collaborative and respectful work environment with a staff as diverse as the audiences we engage. Our staff members are art lovers who are passionate about working toward a common goal: creating the most dynamic and inspiring art museum in the world. At The Met, every staff member – from security officers to researchers to scientists and beyond – lives by our core values of respect, inclusivity, collaboration, excellence, and integrity. Respect: Engage one another with collegiality, empathy, and kindness, always. Inclusivity: Ensure that all are and feel welcome and valued. Collaboration: Reach across boundaries to exchange ideas and work together toward our shared mission. Excellence: Lead the cultural world in quality and expertise—and inspire curiosity and creativity. Integrity: Hold ourselves to the highest moral standards, admit when we fall short, and then evolve. GENERAL STATEMENT OF RESPONSIBILITIES & DUTIES: You are a key player in supporting data infrastructure for current and future initiatives for the Institutional Advancement (IA) department, supporting the operations and prospecting for Development, Membership, External Affairs, and Special Events teams. You will be responsible for the design, deployment, and management of the department’s data infrastructure based on business needs and in collaboration with many stakeholders within The Met (e.g., Finance, Technology, Digital, Retail, Restaurants, Visitor Experience, Finance, etc.). You have exceptional technical skills and analytic thinking, experience working within complex organizational structures, and a communication style that enables the candidate to liaise across stakeholder groups and cultivate strong relationships. PRIMARY RESPONSIBILITIES & DUTIES: Design, deploy, and manage the department’s data architecture, including data inventories, data ingestion, ETL processes and flows, warehouse/data lake design, etc. Assist in defining standards for how data is stored, consumed, integrated, and managed across the department and translate into functional data models; Collaborate with stakeholders to understand structural and model requirements for business needs; Design and build performant data models in response to business needs; Work with in-department analysts on translating data architecture into end-user tools (e.g. data visualizations and custom applications) and provide technical oversight to ensure tools adhere to architecture governance standards; Implement systems and monitoring to ensure data quality, accuracy, performance, and security; Manage roadmap of architecture changes across the department, and work with Museum-wide stakeholders on defining future architecture initiatives; Evaluate existing data and analytics stack for best practice, security, performance and usability, and provide recommendations for improvement; Provide oversight and mentorship to analysts on data architecture, integration, and pipelines; Assist in the production, review, and audit of daily, weekly, monthly, and other ad-hoc reports using T-SQL and SQL Server Reporting Studio (SSRS); Other duties as assigned. REQUIREMENTS & QUALIFICATIONS: Bachelor's Degree or equivalent work experience 5 – 7 years of related experience in data architecture and at least 5 years of experience working with a CRM Extensive knowledge of CRM databases; Tessitura experience preferred Extensive experience with T-SQL and Azure required; C# experience preferred Extensive experience with Azure Data Factory, Azure Storage Explorer, Azure Data Lake, and related Azure stack required Experience with SSRS and PowerBI preferred Experience working with modern data architecture and engineering Experience with annual giving programs and fundraising practices preferred COMPENSATION RANGE: Pay Range : $150,000 - $170,000 / Annually The advertised pay scale reflects the good faith minimum and maximum salary range for this role. The advertised pay scale is not a promise of a particular wage for any specific employee. The specific compensation offered to a candidate may be dependent on a variety of factors including, but not limited to, the candidate’s experience, education, special licensing or qualifications, and other factors. Location Requirements At time of employment, employees are expected to be located within commuting distance of the Museum. “Commuting distance” means that they are located in one of following states: New York, New Jersey, Connecticut, or Pennsylvania (the “Tri-state and PA” areas), and be able to commute to and from the Museum in a single day. Benefits Offerings The Museum provides competitive compensation, and generous benefits and perks for all eligible employees. Note: Benefits Offering may differ based on Employee Status. Medical, dental, vision and life insurance 403(b) basic retirement plan and optional matching retirement plan with an outstanding employer match Considerable paid time off, including annual leave, sick leave, and 13 Museum holidays Long-term disability coverage Flexible Spending Accounts & Health Savings Account (pre-tax income for eligible health care expenses) Commuter benefits (pre-tax income for parking or mass transit expenses) Free financial-planning services Financial assistance for relevant coursework, seminars, and training programs 25% discount for staff in Museum shops A subsidized staff cafeteria Access to the Museums Council pass, which grants free admission to various museums and cultural institutions Research shows that women and people from underrepresented groups often apply to jobs only if they meet 100% of the qualifications. We recognize that it is highly unlikely that someone meets 100% of the qualifications for a role. If much of this job description describes you, then please apply for this role. The Met is committed to the full inclusion of all qualified individuals. As part of this commitment, The Met will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed in this process, please contact benefits@metmuseum.org. The Metropolitan Museum of Art provides equal opportunity to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, national origin, ancestry, age, mental or physical disability, pregnancy, alienage or citizenship status, marital status or domestic partner status, genetic information, genetic predisposition or carrier status, gender identity, HIV status, military status and any other category protected by law in all employment decisions, including but not limited to recruitment, hiring, compensation, training and apprenticeship, promotion, upgrading, demotion, downgrading, transfer, lay-off and termination, and all other terms and conditions of employment. The Metropolitan Museum of Art provides an opportunity for employees to enrich and develop their love of the arts while contributing their specific skills and talents to the mission of the Museum. Career opportunities at The Met are as varied as the cultures represented in the Museum’s collection, and require all levels of training, experience, and education. We are committed to fostering a collaborative and respectful work environment with a staff as diverse as the audiences we engage. Our staff members are art lovers who are passionate about working toward a common goal: creating the most dynamic and inspiring art museum in the world. At The Met, every staff member – from security officers to researchers to scientists and beyond – lives by our core values of respect, inclusivity, collaboration, excellence, and integrity. If you share our community’s values, please apply to one of our exciting opportunities! Respect: Engage one another with collegiality, empathy, and kindness, always. Inclusivity: Ensure that all are and feel welcome and valued. Collaboration: Reach across boundaries to exchange ideas and work together toward our shared mission. Excellence: Lead the cultural world in quality and expertise—and inspire curiosity and creativity. Integrity: Hold ourselves to the highest moral standards, admit when we fall short, and then evolve. The Museum provides competitive compensation, and generous benefits and perks for all eligible employees. Benefits Offering may differ based on Employee Status. Transparency in Coverage UnitedHealthcare creates and publishes the Machine-Readable Files on behalf of the Metropolitan Museum of Art in compliance with the Transparency in Coverage Rule. To link to the Machine-Readable Files, please click on the URL provided: http://transparency-in-coverage.uhc.com/

Salary : $150,000 - $170,000