Job Title: Application Architect & Data Engineer
Location: Sacramento, CA 95811 (Hybrid – Onsite 3 days/week)
Duration: 1-Year Contract
Preference: Local to California
We are seeking a highly experienced Application Architect & Data Engineer for a long-term contract engagement. This role is deliverable-based and focuses on enterprise system enhancements, data integration, and ongoing technical support for a large-scale governmental system. The selected candidate will be embedded within the Enterprise Solutions development team, playing a key role in critical system change initiatives.
Gather and document technical and user requirements.
Propose design options with LOE (Level of Effort) estimates and timelines.
Document selected design solutions for approval and implementation.
Develop and implement changes within approved environments.
Conduct unit testing and support user acceptance testing (UAT).
Enhance and maintain synchronized system documentation.
Conduct ongoing knowledge transfer to internal stakeholders.
Facilitate regular sessions and document system processes, best practices, and lessons learned.
Ensure artifacts are stored and accessible via shared repositories.
Participate in regular project meetings and report status updates.
Maintain detailed documentation of business processes, incident resolutions, and test results.
Collaborate with the contract manager to ensure deliverables are documented and transferred to internal teams.
15+ years of experience in data systems design and programming.
15+ years of experience as a Solution Architect.
15+ years of experience with governmental retirement systems (CalPERS preferred).
Advanced expertise with Oracle (11g/19C), PL/SQL, and SQL.
7+ years of experience with actuarial systems.
Extensive experience in ETL development for large datasets.
Proficiency with Power BI for reporting and visualization.
Working experience with Snowflake.