Application Architect & Data Engineer

Job Title: Application Architect & Data EngineerDuration: 12 months with possible extensionsWork Mode: Hybrid (3 days per week)Location: Sacramento, CA 95811Interview: In-personJob Description: The consultant will work with the Enterprise Solution development team and undertake duties and responsibilities as an Application Architect and Data Engineer on critical system change efforts and provide ongoing support for the delivery of robust and reliable solutions. The consultant will design and implement solutions within the organization to solve complex business problems. The consultant will serve as a subject-matter expert in data management; research, analyze, recommend, and select technical approaches for solving exciting, complex development and integration problems.The consultant will be responsible for gathering user requirements, technical design, and implementation; implementing and maintaining stored procedures and data packages to process large volumes of data and reviewing the designs of the other developers to ensure the solution meets the solution/architecture guidelines set by the project. Additional duties and responsibilities include but are not limited to: performing data analysis work; defining technical requirements; creating or updating existing technical design artifacts.Responsibilities: Analysis and Design, Implementation, Testing and Support, Knowledge TransferDocument requirements and technical design to meet the requirements. Propose one or more design options as appropriate to each situation, including a level- of-effort estimate and target delivery date. Document the design option selected by client. Develop approved application changes within the existing technical environments, using the approved promotion path and QA/testing methodology. Performing internal unit/QA testing and facilitate user acceptance testing. Update and enhance system documentation to keep it synchronized with system and environment changes. Contractor will provide knowledge transfer of reporting efforts, escalated system issues, and application changes and enhancements. Knowledge transfer to take place at client via regular scheduled meetings and review of documentation. Documentation to include best practices and lessons learned during the project. Minimum QualificationMust have a minimum of (15) years of experience in electronic data processing systems study, design, and programming; at least ten (10) years of said experience shall have included responsibility on a project basis for analyzing operational methods and developing computer programs to meet desired results. Must have minimum of fifteen (15) years of experience working as a solution architect, in providing solutions that aligns with enterprise architecture and aligns with business process in use. Must have a minimum of fifteen (15) years of experience working with public pension systems or experience with Governmental Retirement Benefits and processes. Must have a minimum of fifteen (15) years of experience with Oracle 11g, Oracle 19C, PL/SQL, SQL Must have minimum of seven (7) years if working on new or maintaining existing IT actuarial systems. Must have a minimum of fifteen (15) years of experience implementing Stored procedures and PL SQL to process large volume of data and ETL. Experience with data reporting using Power BI Experience with data storage and analytics in Snowflake Other Evaluation Criteria PointsOverall Expertise C Experience Project Leadership, Decision Management, and Execution Resource, Schedule, Budget, and Benefit Planning and Optimization Stakeholder Engagement, Change Management, and Team Collaboration Progress Communication and Transparency Risk, Issue, and Progress Management Innovation and Continuous Improvement