Senior Data Architect & Analytics Leader

Child Care Resource Center (CCRC); West Chatsworth (CA); Hybrid; USD 63,000 - 65,000; Full time

Benefits offered by this job

Competitive compensation package

Robust benefits package

Hybrid work arrangement

Education reimbursement

Employee wellness programs

Job summary

Child Care Resource Center (CCRC) is seeking a Senior Database Developer to design, develop, optimize, and maintain the data warehouse and reporting solutions supporting agency operations and decision-making.

The role leads data governance, ensures data quality and security, and collaborates with stakeholders across Programs, Finance, Research, and other divisions in a hybrid, full-time capacity (40 hours weekly).

Qualifications

• Minimum 5 years of experience in SQL application and database development, database administration support, data management, reporting, and analytics environments.
• Advanced proficiency with Microsoft SQL Server and SQL Server Management Studio (SSMS).
• Advanced knowledge of T-SQL, stored procedures, views, functions, triggers, and database optimization techniques.
• Experience supporting data integration, ETL processes, and reporting environments.
• Experience developing and supporting business intelligence solutions, dashboards, scorecards, and KPI reporting tools.
• Strong understanding of relational database design principles, normalization, indexing strategies, and data modeling methodologies.
• Experience reviewing execution plans, identifying performance bottlenecks, and implementing database optimization strategies.
• Experience implementing data governance frameworks, data quality controls, and data stewardship best practices.
• Knowledge of data lifecycle management, data lineage, metadata management, and master data concepts.
• Understanding of database security, access controls, auditing, and compliance requirements.
• Experience gathering business requirements, conducting stakeholder interviews, and translating business needs into technical reporting and data solutions
• Ability to communicate technical and analytical concepts to non-technical audiences, including managers, directors, and executive leadership.
• Strong documentation, troubleshooting, and problem-solving skills.
• Experience working within Change Management and Software Development Lifecycle (SDLC) frameworks.

Responsibilities

• Data Architecture, Development, and Analytics (50%)
• Data Governance, Data Integrity, and Quality (25%)
• Stakeholder Partnership and User Enablement (15%)
• Data Advisory and Leadership Support (5%)
• Operational Excellence and Documentation (5%)

Skills

SQL Server

SSMS

T-SQL

Data Governance

ETL

Data Modeling

Analytics

Communication

Education

Bachelor's degree in Computer Science / Information Systems / Data Science

Tools

Power BI

SSRS

Tableau

Job description

Child Care Resource Center (CCRC) is seeking a Senior Database Developer to design, develop, optimize, and maintain the data warehouse and reporting solutions supporting agency operations and decision-making.

The role leads data governance, ensures data quality and security, and collaborates with stakeholders across Programs, Finance, Research, and other divisions in a hybrid, full-time capacity (40 hours weekly).