Enterprise Data Architect & Modeler

Overview

Senior Technical Recruiter at 32BJ Benefit Funds : Hiring IT Professionals who directly impact the lives of 100K+ Union Workers. This is a full-time position that requires working onsite in NYC.

About Us

Building Services 32BJ Benefit Funds (the Funds) administer Health, Pension, Retirement Savings, Training, and Legal Services benefits to over 100,000 SEIU 32BJ members. Our mission is to make significant contributions to the lives of our members by providing high quality benefits and services. We embody five core values : Flexibility, Initiative, Respect, Sustainability, and Teamwork (FIRST). The Funds oversee and manage billions in assets and engage with multiple sources including property owners. For 2025 and beyond, we drive innovation, equity, and technology insights to help our members and their families. We use cutting edge technology such as : M365, Dynamics 365 CRM, Dynamics 365 F&O, Azure, AWS, SQL, Snowflake, QlikView, and more.

Please watch our video to learn more about our culture and contributions : youtu.be / hYNdMGLn19A

Job Summary

Reporting to the Assistant Director of Data Architecture & Data Governance, the Enterprise Data Architect & Modeler will lead the design, development, implementation, and management of data architecture and modeling initiatives within the Funds to ensure data is organized, integrated, and accessible across the organization. The role will develop enterprise data solutions enabling seamless integration, accessibility, and governance of critical data assets across hybrid cloud and on-prem environments.

The ideal candidate will have hands-on experience in data modeling, data warehousing, and data pipeline development, working with Microsoft SQL Server, Azure, Databricks, and AWS ecosystems. This role collaborates with IT teams and business stakeholders to build and optimize enterprise data models, ensure data integrity, and support master data management (MDM) and data governance initiatives.

Essential Duties and Responsibilities

• Lead development of conceptual, logical, and physical data models that meet business and technical requirements while balancing normalization, performance, and maintainability.
• Produce implementation artifacts (ER diagrams, dimensional models, data dictionaries, model change impact analyses) to guide engineering, analytics, and operations teams.
• Apply modeling best practices and patterns and define partitioning, indexing, and retention strategies to optimize query and storage performance.
• Translate logical models into platform-specific physical designs for Microsoft SQL Server and cloud targets (e.g., Databricks Delta Lake), including recommendations for table design, materialized views, and aggregation layers.
• Document architectural tradeoffs (performance, storage, consistency) and versioning / change-control for models.
• Architect ETL / ELT and ingestion patterns for structured and unstructured data, including batch and streaming approaches.
• Define reusable integration templates and data contracts for source teams and downstream consumers; support ingestion from CRM, member portals, payroll / financial systems, and third-party APIs.
• Specify orchestration and operational patterns (e.g., Azure Data Factory, Databricks Jobs) covering idempotency, retry / backoff, checkpointing, and partitioning for scale and recoverability.
• Embed observability and quality : schema evolution handling, automated profiling, validation gates, lineage capture, monitoring / alerting, and SLA definitions.
• Advise on performance and cost tradeoffs and recommend optimization strategies.
• Design and operationalize MDM approaches to establish authoritative records and a Single Source of Truth (SSOT) for core domains (e.g., member, provider).
• Define entity resolution, deduplication, survivorship rules, and stewardship workflows for record reconciliation and updates.
• Collaborate with Data Governance on metadata management, lineage, and data quality metrics, and recommend remediation and monitoring strategies.
• Ensure models and pipelines incorporate privacy, security, and compliance controls (e.g., PII tagging, RBAC, encryption), supporting applicable frameworks (e.g., HIPAA, SOC 2) where relevant.
• Define stewardship roles, SLAs for issue remediation, and integration points between MDM and business glossary / downstream consumers.
• Translate complex data concepts into business-friendly terms to facilitate understanding across non-technical stakeholders.
• Partner with business owners, analytics, engineering, and operations to translate requirements into data products and model designs; present tradeoffs and recommended approaches in business-facing terms.
• Produce clear documentation and training artifacts (data dictionaries, runbooks, design briefs) to drive consistent adoption and model transparency.
• Mentor and coach technical staff, data stewards, and analysts on modeling standards, architecture principles, and data literacy; support training sessions to increase adoption of governance practices and promote a culture of continuous learning.
• Facilitate model reviews, architecture governance sessions, and stakeholder sign-offs for critical changes.
• Research and evaluate new database, lakehouse, modeling, and integration technologies and lead POCs to validate technical and business value.
• Advocate for DataOps / CI-CD practices around tests, automated deployments, and reproducibility for pipelines and model artifacts.
• Conduct periodic architecture and model reviews, identify process / technology gaps, and lead initiatives to increase operational maturity, reliability, and scalability.

Qualifications (Competencies)

Soft Skills (Interpersonal Skills)

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, or equivalent experience.

Language Skills

Speak, read, write, and understand English.

Reasoning Ability

High

Certificates, Licenses, Registrations

Salary Range

$175,000.00 - $180,000.00 (USD) Annually

Seniority level

Employment type

Job function

Referrals increase your chances of interviewing at Building Service 32BJ Benefit Funds by 2x

Get notified when a new job is posted.

J-18808-Ljbffr