Senior Data Platform Architect
3 days ago
Los Angeles
Job Description ABOUT THE ROLE: 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. Job Title: Senior Data Platform Architect Reports To: Application Development Manager Group: Information Technology Compensation Range: $145,000 to $169,000 annually FLSA Status: Exempt Benefits: Competitive benefits package including health, dental, vision, retirement plan, PTO, and more! KEY RESPONSIBILITIES: 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 healt, • 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 KEY REQUIREMENTS: Education: • Bachelor’s degree in computer science, Information Systems, or a related field required Experience: • 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 PREFERRED 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 SKILLS REQUIRED: • 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 communicationCompany DescriptionApply today to take the next step in your career with one of California’s most influential professional organizations. About THE CALIFORNIA ASSOCIATION OF REALTORS®: The CALIFORNIA ASSOCIATION OF REALTORS® offers a collaborative environment that will allow you the opportunity to work on impactful projects that make a difference. What we love the most about working here are the autonomy, collaborative team environment and commitment to a positive work/life integration. And we like so much more, but we’ll tell you about that later. 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. Company Description 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 remote/hybrid work arrangements, business casual wear, a health and wellness program including lunch and learns with guest speakers, and collaborative working areas. 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 . 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®.Apply today to take the next step in your career with one of California’s most influential professional organizations.\r\n\r\nAbout THE CALIFORNIA ASSOCIATION OF REALTORS®:\r\nThe CALIFORNIA ASSOCIATION OF REALTORS® offers a collaborative environment that will allow you the opportunity to work on impactful projects that make a difference. What we love the most about working here are the autonomy, collaborative team environment and commitment to a positive work/life integration. And we like so much more, but we’ll tell you about that later.\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\nCompany Description\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 remote/hybrid work arrangements, business casual wear, a health and wellness program including lunch and learns with guest speakers, and collaborative working areas. \r\n\r\nWhat else? (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 . \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®.