IT Functional Database Consultant

Turn Data into Decisions – Join Us as an IT Functional Database Consultant!! Now Hiring: IT Functional Database Consultant Company: Allegiance Supply Inc. Location: Sacramento County, CA – 100% onsite. Term: April 1, 2026 – March 31, 2027 (with possible one-year extension) Work hours: 8:00 AM to 5:00 PM Work schedule: Monday through Friday, 40 hours per week. Allegiance Supply Inc seeks one (1) IT consultant specializing in database and Extract, Transform, Load (ETL) testing, SQL Server Integration Services (SSIS), business intelligence, and data warehouse operations handling large data volumes. Experience in SQL Server Reporting Services (SSRS) testing is required. You must demonstrate expert-level ability in designing and executing structured queries, functional testing, and interface testing for enterprise applications following industry best practices. Applicants must reside within the Sacramento, El Dorado, San Joaquin or Yolo counties. Local candidates are strongly preferred. Relocation assistance is not available for this position. Job Description: Under the direction of the Application Services Manager or delegate, you will provide support, mentoring, and training in database/ETL and functional testing. Key Responsibilities: Collaborate with stakeholders to review and analyze functional and non-functional requirements. Develop test plans, test cases/scripts, and test summary reports for manual, integration, regression, and database testing. Work closely with development teams to analyze critical business scenarios. Execute test cases and report bugs using Azure DevOps. Participate in sprint planning, retrospectives, and daily stand-ups; communicate timely status and potential risks. Provide training and assistance to the Application Services team. Create SQL stored procedures for test validation of Key Performance Indicators (KPIs) under the Verification and Remediation project. Conduct SQL Server Reporting Services (SSRS) report testing and validate large data volumes in a data warehouse. Refactor and optimize SQL stored procedures as needed. Perform comprehensive knowledge transfer to designated staff to include communication of personal, technical, and operational knowledge or information that enables or enhances the staff's ability to maintain and operate the applicable systems and to include OJT (on-the-job training) hands-on instruction, and all necessary documentation to ensure staff can adequately sustain, maintain, and operate the delivered solutions. Provide a written manual/guide containing all materials, processes, and system information developed. The customer may reproduce such documentation as needed to ensure project continuity. All information, documentation, and materials produced shall be the property of the customer. Additional Requirements to Include: Submit written status reports in MS Word format via email to the manager or designee. Reports should include: Summarize of completed work vs. planned tasks. Highlight tasks behind schedule, remedies applied, and overall project impact. Provide status of overall engagement, including risks, issues, and proposed solutions. Provide tasks planned for the next reporting period. Account of your work hours to date. Required Skills and Qualifications Bachelor's degree in Computer Science, Information Technology, Software Engineering or related scientific discipline or equivalent combination of education and experience. Expert-level (minimum 5 to 8 years) experience in SQL, SSIS, ETL processes, and database testing. Experience with business intelligence and data warehouse environments handling large datasets. Proficiency in SQL Server Reporting Services (SSRS) report testing. Strong analytical and problem-solving skills; ability to translate business requirements into testable solutions. Familiarity with Azure DevOps for test case execution and defect reporting. Excellent communication, mentoring, and collaboration skills. The successful candidate must possess strong communication skills, including the ability to read, write, and speak English at a level sufficient to perform the duties of the position effectively. The successful candidate must maintain a valid driver's license if required for job-related travel. The successful candidate must have access to reliable transportation to report to assigned work locations as required. The successful candidate must successfully complete all required pre-employment screening, including a comprehensive background check and Live Scan fingerprinting. The successful candidate must successfully complete Tuberculosis (TB) testing and maintain current TB clearance in accordance with State and departmental requirements. Required Competencies The successful candidate must demonstrate the following knowledge, skills, and abilities in performing the duties of the position: Communication Skills: Effectively communicates information in writing and verbally; demonstrates strong planning and organizational skills; adapts to changing priorities; maintains attention to detail; delegates tasks appropriately; and maintains effectiveness under work-related stress. Problem Solving: Identifies and resolves issues promptly; gathers, evaluates, and analyzes information to support sound decision-making. Interpersonal Skills: Collaborates effectively with colleagues; resolves conflicts constructively; maintains confidentiality; exercises professional judgment. Oral Communication: Actively listens, seeks clarification when necessary, and provides clear, appropriate responses to questions and feedback. Teamwork: Balances individual responsibilities with team objectives; contributes to a positive and collaborative work environment. Professionalism: Demonstrates accountability for assigned tasks; follows through on commitments; adheres to workplace standards of conduct. Quality of Work: Produces accurate, thorough, and high-quality work; seeks opportunities to improve processes and outcomes. Attendance and Punctuality: Maintains reliable attendance and reports to work as scheduled. Dependability: Follows instructions and responds appropriately to direction from supervisors; willing to work additional hours when required to meet operational objectives. Initiative: Takes independent action when appropriate; exercises sound judgment in assuming calculated risks; proactively seeks or provides assistance to support team or project goals. Physical & Functional Requirements: Physical Requirements: Ability to perform essential job functions that involve sitting for extended periods while using a computer. Sufficient manual dexterity to operate office equipment, including keyboards, mice, and other peripherals. Visual ability to read computer screens, printed documents, and forms accurately. Hearing and speaking ability to communicate effectively in person, by phone, or via virtual conferencing. Ability to move around the work environment as needed to access files, equipment, or attend meetings. Ability to lift and carry light office materials and equipment (typically up to 10–20 pounds). Functional Requirements: Proficiency in operating computers, laptops, and related peripherals. Experience using standard office software (e.g., Microsoft Office Suite, email, and collaboration tools) and any job-specific applications or databases. Strong attention to detail for accurate data entry, reporting, and recordkeeping. Ability to troubleshoot basic hardware or software issues or escalate as necessary. Effective verbal and written communication skills to collaborate with team members, management, and customers. Ability to maintain focus and concentration for extended periods while performing repetitive tasks. Ability to prioritize and manage multiple tasks and meet deadlines efficiently. Knowledge of and adherence to information security protocols, confidentiality policies, and applicable State regulations. Equal Opportunity Employer Disclaimer Allegiance Supply Inc. is a Disabled Veteran Owned Enterprise and an Equal Opportunity Employer. We provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any kind. Employment decisions are based on business needs, job requirements, and individual qualifications—without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.