Senior Data Platform Architect in Los Angeles

The CALIFORNIA ASSOCIATION OF REALTORS® (C.A.R.) is seeking a hands-on Senior Data Platform Architect to architect the future of enterprise analytics within the Information Technology group at the California Association of REALTORS®. You will design, build, and operate the Association's data lake and analytics data platform as a trusted, secure, and scalable enterprise asset.

The role owns data architecture, modeling standards, ingestion patterns, and governance practices that enable reporting, analytics, and future AI use cases. In addition to data lake ownership, this role is accountable for the reliability, security, and performance of the Association's production database environments. The position will report to the Application Development Manager and partner closely with Application Development, IT Operations, Research, and business stakeholders to ensure that data is accurate, accessible, and decision ready., Ingestion and Data Engineering

• Design, build, and operate ingestion and ELT ETL pipelines from SQL Server, SaaS platforms, and file-based sources
• Implement scheduling, retries, error handling, and operational logging using approved tooling
• Partner with developers and analysts to onboard new datasets and evolve existing ones

Database Administration and Operations

• Own and administer production SQL Server environments including security, backup and recovery, monitoring, performance tuning, and capacity planning
• Enforce least privilege access, auditing, encryption, and retention policies across databases and data platforms
• Continuously monitor and tune performance across databases and data pipelines to meet business expectations
• Automate routine operational tasks and maintain clear runbooks and documentation

Data Platform and Lake Architecture

• Design and own the data lake architecture including raw, curated, and consumption layers
• Define and maintain canonical data models for members, transactions, products, engagement, and finance
• Establish, maintain, and govern standards for data organization, naming, partitioning, retention, and lifecycle management, including ongoing stewardship to ensure standards are consistently applied, periodically reviewed, and evolved as platform, regulatory, and business needs change.
• Ensure data quality, lineage, and documentation suitable for leadership and enterprise reporting
• Enable downstream analytics, reporting, and self-service use cases

Governance, Security, and Reliability

• Apply data governance fundamentals including access controls, retention, and compliant use of data
• Support audits and reviews through clear documentation and traceability
• Implement monitoring and alerting for database and data pipeline health
• Participate in incident response and root cause analysis related to data platforms

Collaboration and Enablement

• Partner with Application Development, IT Operations, Research, and business stakeholders
• Translate business questions into durable data structures and models
• Provide guidance and standards that reduce one off reporting and manual extract

• Bachelor's degree in computer science, Information Systems, or a related field required, * 7 plus years of experience in data engineering, data architecture, analytics platforms, or database administration
• Strong hands-on experience administering production SQL Server environments including security, backup restore, HA DR, monitoring, and performance tuning
• Strong SQL and data modeling experience for analytics and reporting use cases
• Experience designing and operating data lake or data platform workloads
• Hands on experience with ingestion and ETL and ELT pipelines including scheduling and operational support
• Strong understanding of database design, data warehousing concepts, and analytics modeling techniques
• Proven ability to troubleshoot complex data and system issues

EXPERIENCE:

• Experience with Microsoft Azure data services including Azure Data Lake, Azure Data Factory, and Synapse
• Familiarity with Lakehouse or modern analytics architectures
• Experience supporting BI tools such as Power BI
• Experience in regulated or complex enterprise environments
• Experience in real estate, membership-based organizations, or nonprofit environments, * Production SQL Server administration including installation, configuration, patching, and capacity planning
• Backup and recovery management and HA DR planning
• Security administration including RBAC, auditing, encryption, and access reviews
• Performance tuning and troubleshooting across databases and data workloads
• Data lake and data platform operations including ingestion patterns and data organization standards
• ETL ELT pipeline operations including retries, error handling, and operational logging
• Automation and scripting using T SQL, PowerShell, SQL Server Agent, or orchestration tools
• Clear documentation, runbook discipline, and cross team communication

Compensation Range: $145,000 to $169,000 annually FLSA Status: Exempt Benefits: Competitive benefits package including health, dental, vision, retirement plan, PTO, and more!

At CALIFORNIA ASSOCIATION OF REALTORS®, we believe in the power of relationships. With 200,000 members across California, we're dedicated to supporting REALTORS® as they help communities thrive. We foster innovation, collaboration, and a healthy work-life integration while offering meaningful opportunities for growth., Company DescriptionApply today to take the next step in your career with one of California's most influential professional organizations. The CALIFORNIA ASSOCIATION OF REALTORS® is a statewide trade association dedicated to the advancement of professionalism in real estate. The Association develops and promotes programs and services for its nearly 200,000 members and keeps the public informed about real estate in California. Leading the Way...TM isn't just a slogan at the CALIFORNIA ASSOCIATION OF REALTORS® (C.A.R.). As one of the largest state trade organizations in the United States, C.A.R. provides members with tools to help complete transactions, information to keep them nimble in the marketplace and a strong clear voice on the government steps in Sacramento. How do we do it? We start by hiring friendly, talented people committed to working toward those common goals. Headquartered in Sacramento, C.A.R. offers flexible work-from-home/hybrid work arrangements, business casual wear, and health and wellness program including lunch and learns with guest speakers. What else? (*The following pertains to employees who regularly work at least 30 hours per week.) *Medical, dental, vision, vitamin reimbursement, 401(k) retirement plan, 12 paid holidays, and more. C.A.R. staff stand by a set of core values that make us the best in the business. Take a look for yourself and see what we are all about www.car.org. C.A.R. and/or its subsidiaries and agents will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, Sorry! Due to the heavy volume of resumes we receive, only candidates being considered will be contacted directly. We appreciate your interest in employment opportunities with the CALIFORNIA ASSOCIATION OF REALTORS®.Company DescriptionApply today to take the next step in your career with one of California's most influential professional organizations.\r\n\r\nThe CALIFORNIA ASSOCIATION OF REALTORS® is a statewide trade association dedicated to the advancement of professionalism in real estate. The Association develops and promotes programs and services for its nearly 200,000 members and keeps the public informed about real estate in California.\r\n\r\nLeading the Way...TM isn't just a slogan at the CALIFORNIA ASSOCIATION OF REALTORS® (C.A.R.). As one of the largest state trade organizations in the United States, C.A.R. provides members with tools to help complete transactions, information to keep them nimble in the marketplace and a strong clear voice on the government steps in Sacramento. How do we do it? We start by hiring friendly, talented people committed to working toward those common goals. \r\n\r\nHeadquartered in Sacramento, C.A.R. offers flexible work-from-home/hybrid work arrangements, business casual wear, and health and wellness program including lunch and learns with guest speakers.\r\n\r\nWhat else? (*The following pertains to employees who regularly work at least 30 hours per week.)\r\n\r\n*Medical, dental, vision, vitamin reimbursement, 401(k) retirement plan, 12 paid holidays, and more. \r\n\r\nC.A.R. staff stand by a set of core values that make us the best in the business. Take a look for yourself and see what we are all about www.car.org. \r\n\r\nC.A.R. and/or its subsidiaries and agents will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance\r\n\r\nSorry! Due to the heavy volume of resumes we receive, only candidates being considered will be contacted directly. We appreciate your interest in employment opportunities with the CALIFORNIA ASSOCIATION OF REALTORS®.