IT Consultant V, Solutions - Oracle or SQL Server Databases, SAS, PowerAutomate, Python, R
Responsible for guiding advanced data modeling and SQL query development, technical architecture and solution design, completing and influencing business requirements, reviewing and analyzing existing systems and processes, and building out of technical specifications. Conducts gap analyses to document discrepancies between business requirements and system capabilities. May develop project plans and ensure plan adherence. As system development progresses, will have input into reporting requirements/report development, user interfaces, and coordinates or conducts UAT and the final evaluation of the system solution. Serves as liaison between line business (client) and the IT organization.
Essential Functions:
·Requirements definition and analysis: collects and researches specific client requirements for projects, identifies requirements, gathers workflow data and basic system and reporting specifications. Develops, implements, and supports common business processes and tools. Recommends basic alternatives to address problems.
·Project planning and execution: participates in project management process, including participating in project meetings. May document issues, action items, user requirements, or deliverables from project meetings. Performs a variety of project related activities, including analysis or preparation of documentation and presentations. Accomplishes all work within established methodologies and standards.
·Business User/Owner Application Support: 1st point of contact for customers when issues arise with data / reports. Works with business and technical teams to determine root cause. Influences client and gains commitment to changes required.
·Business and Process Improvement: Identifies opportunities for business or process improvement; makes associated recommendations and implements as appropriate.
·Guides and advises developers and testers on database design, generating data models and writing SQL queries.
- Minimum two (2) years experience in software or system testing across multiple IT environments.
- Minimum one (1) year software or application development experience.
- Bachelors degree in Business Administration, Computer Science, CIS or related field and Minimum eight (8) years experience in IT consulting, business analysis, or a related field. Additional equivalent work experience may be substituted for the degree requirement.
- Certified Business Analyst Professional (CBAP) or other comparable business analyst or IT consulting certification
- Three (3) years experience in large scale software implementations
- Either Oracle or SQL Server databases
- Either Oracle PL/SQL or T-SQL
- Either Oracle or SQL Server Performance Tuning
- Familiarity with Tableau Prep, SAS, PowerAutomate, Python, R are pluses
- ETL, Data Validation
Pleasanton Tech Cntr Building A, 4460 Hacienda Dr. Bldg. A, Pleasanton,California, 94588
Corona Data Center Admin, 1830 California Ave., Corona,California, 92881
Greenwood Plaza IT, 6560 Greenwood Plaza Blvd., Greenwood Village,Colorado, 80111
Pershing Point Plaza IT, 1375 Peachtree St. NE, Atlanta,Georgia, 30309
New Carrollton Administration, 4000 Garden City Dr., Hyattsville,Maryland, 20785
Renton Administration - Adams, 2921 Naches Ave. SW, Renton,Washington, 98057
Hawaii Remote Workers Location, 415 S Beretania St, Honolulu,Hawaii, 96813 Scheduled Weekly Hours: 40 Shift: Day Workdays: Mon, Tue, Wed, Thu, Fri Working Hours Start: 08:00 AM Working Hours End: 05:00 PM Job Schedule: Full-time Job Type: Standard Worker Location: Flexible Employee Status: Regular Employee Group/Union Affiliation: NUE-IT-01|NUE|Non Union Employee Job Level: Individual Contributor Department: KPIT ADMIN - DA ADMIN - 9601 Pay Range: $131600 - $170280 / year Kaiser Permanente is committed to pay equity and transparency. The posted pay range is based on possible base salaries for the role and does not include the value of our total rewards package. Actual pay determined at offer will be based on years of relevant work experience, education, certifications, skills and geographic location along with a review of current employees in similar roles to ensure that pay equity is achieved and maintained across Kaiser Permanente. Travel: Yes, 5 % of the Time
Kaiser Permanente is an equal opportunity employer committed to fair, respectful, and inclusive workplaces. Applicants will be considered for employment without regard to race, religion, sex, age, national origin, disability, veteran status, or any other protected characteristic or status.
Navigating the Hiring Process
We're here to support you!
Having trouble with your account or have questions on the hiring process?
Please visit the FAQ page on our website for assistance.
Need help with your computer and browser settings?
Please visit the Technical Information page for assistance or reach out to the web manager at kp-hires@kp.org.
Do you need a reasonable accommodation due to a disability?
Reasonable accommodations may be available to facilitate access to, or provide modifications to the following:
- Online Submissions
- Pre-Hire Assessments
- Interview Process
If you have a disability-related need for accommodation, please submit your accommodation request and someone will contact you.
Jobs For You
There are currently no featured jobs.
You have no recently viewed jobs
You currently have no saved jobs
Join Our Talent Community
Join our Talent Network today to receive email notifications about our career opportunities that match your skills.
Connect With Us