Business Data Architect

Job Description

About the Role

Title: Business Data Architect

Location: Ny United States

Job Description:

About Us:

The Community Preservation Corporation (CPC) believes stable and sustainable affordable housing is the foundation of strong communities and we strive to contribute to comprehensive neighborhood revitalization through our lending and partnerships. A nationally recognized leader in affordable housing finance, CPC has provided a consistent source of capital to underserved housing markets throughout New York State since our inception in 1974.

Today, CPC stands as the largest CDFI solely committed to investing in multifamily housing, having invested more than $15 billion to finance the creation and preservation of more than 230,000 units of quality housing in neighborhoods across New York State and beyond. CPC has a robust construction lending platform, a mortgage bank, and equity and impact investment platforms that focus on our three goals: Expanding Affordable Housing, Closing the Racial Wealth Gap and Investing in the Green Economy.

As a member of our team, you’ll have the opportunity to work on impactful projects that make a real difference in people’s lives. We’re looking for talented individuals who are passionate about our mission and share our values of commitment, respect, excellence, accountability, and collaboration.

Role Summary:

The Business Data Architect brings a strong technical background and expertise in designing and developing scalable enterprise solutions. This includes extracting data from source systems, transforming it based on business rules and data management (MDM) standards, and loading it into operational and presentation models.

You will collaborate with data engineers and Product owners, including business stakeholders to understand data requirements, define data standards, and ensure data integrity and accessibility across the organization. The Business Data Architect will help build a robust data environment to support analytics, reporting, and data-driven decision-making. This role requires strong understanding of database methodology, data analysis and advanced SQL along with their business intelligence application.

What You’ll do:

Utilize your expertise in SQL and ETL processes implementing enterprise data solutions from inception to completion for high levels of data availability, reliability, integrity, dissemination and security.

Utilize your knowledge of structured data, such as entities, classes, hierarchies, relationships and metadata to build processes and reporting.

Utilize your expertise of database management system (DBMS) including tables, joins and SQL querying to capture, build data pipeline/processing strategies with structured data design.

Design and develop a scalable data architecture framework to support current and future business requirements.

Define data models, metadata, and data integration strategies.

Ensure alignment of data architecture with enterprise architecture standards and best practices.

Combine data from multiple sources when needed for analysis.

Create and maintain documentation for data models, architecture diagrams, and data management procedures.

Utilize your knowledge in relational and dimensional data modeling and working in a multi-tier data delivery environment for pipeline buildout.

Serve as a key team member, working closely with the Director of Business Data Architecture to support cross-functional initiatives and provide backup support as needed to ensure seamless operations.

Skills and Experience:

Bachelor’s degree in Computer Science, Computer Engineering, Data Science, Information technology or equivalent required.

Master’s degree in Computer Science or Engineering preferred.

Overall, at least 10+ years of hands-on technical experience with 5+ years encompassing data analytics, data architecture, data warehousing, data management and data modelling, with a broad range of enterprise wide implementation across data platforms.

5+ years of at least one ETL tool experience required.

5 + years of Business Intelligence application delivery required – Experience in Microsoft stack (SSIS, SSAS, SSRS, SQL Server) preferred

Proficiency in data modeling and design principles for enterprise data, including SQL development and data warehouse management.

Ability to implement common data management and reporting design, as well as the basics of columnar and NoSQL databases

Solid understanding of BI reporting tools, PowerBI preferred

Knowledge of programming languages such as Python or Java is a plus.

Experience with Microsoft Azure Platform – Emphasis on Power Platform, Azure Data Services (SQL Server, Data Lake, DataVerse) a plus

What We Offer:

Competitive compensation

401(k) retirement plans with employer match

Medical, dental, and vision benefits for employees and their dependents

Commuter benefits

PTO for vacation, personal days, sick leave, holidays, jury duty, bereavement, parental leave, and disability

Tuition assistance program

Two “work from anywhere” weeks per year

Summer Fridays

Collaborative working spaces

Service days to support our communities

Employee development and engagement events

More about our offerings and culture here

This is a full-time, hybrid role where you will work from the Manhattan office two – three days a week. The salary range is $115,000 – $140,000, dependent on experience.

The Community Preservation Corporation is an Equal Opportunity Employer and all employment-related decisions including recruitment, selection, evaluation, promotion, compensation, training and termination are made without regard to race, creed, color, national origin, sex, disability, marital status, status as a veteran, sexual orientation or gender identity, or any other protected status.