Programmer/Analyst

Job Details
Job Location
Main Office - Santa Barbara, CA
Salary Range
$114,138.00 - $171,207.00
Description
California expected pay range: $114,138 - $171,207
Summary
To analyze, design and implement computer software; maintain assigned subsystems; plan, code, test and document application programs using structured and/or object-oriented methodologies. This position is critical to the success of CenCal Health efforts, in an environment that is driven by data and information.
Duties and Responsibilities

• Consults with users to finalize application requirements
• Identifies programming and output needs
• Verifies preliminary design and output
• Analyzing, designing, and implementing computer software and maintaining assigned subsystems
• Planning, coding, testing and documenting application programs using structured and/or object-oriented methodologies
• Recommending technical and procedural design for new or revised applications including flow charts
• Producing system specifications
• Follow programming guidelines and perform code reviews
• Reviews, modifies and/or writes program code and/or job control language as needed
• Writes documentation of system procedures and guidelines for application users as well as programs and program modifications
• Answers questions and provides technical assistance and/or training to application users
• Resolves problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting
• May serve as lead developer on a small application or assist the lead on larger applications
• Assists other employees in resolving certain technical problems
• Confers with other IT personnel in resolving problems involving procedural and technical matters
• Provides more advanced technical support for the customer
• Researches problems and recommends solutions
• Provides resource estimates and progress reports
• Serves on committees to develop technical standards and direction
• Meets with CenCal customers and technical staff to determine information needs and requirements
• Ensures that all work is accurate and in compliance with departmental or project quality standards
• Participates in training and professional development sessions
• Possible support on nights and weekends as needed
• Provides input for the planning and budget process
• Other duties as assigned

Qualifications
Skills/Knowledge/Abilities
Required

• Proficiency in SQL Server and/or Oracle products including (but not limited to): Oracle SQL*Plus, SQL, PL/SQL, , Java, JavaScript, HTML, XML, Linux/UNIX shell scripting; knowledge of Oracle RDBMS database, .Net Core, C#, Internet, and Intranets; experience with personal computers (PCs), MS Windows operating system, and MS Office Suite.
• Superior problem solving and troubleshooting capabilities
• Excellent verbal and written communication skills
• Ability to attend meetings and participate in small teams effectively
• Must be able to budget time and meet deadlines

Preferred

• SSRS & Cognos or similar reporting tools.
• Microsoft SQL Server

Education and Experience

• Bachelor's Degree in Computer Science or Information Technology, or equivalent experience
• Three to Five years of programming experience in a SQL Server and/or Oracle development environment
  • Three years hands-on Experience on large database development
  • Three years hands-on experience On databases applications
  • Three years hands-on experience with .Net Framework using C#.
  • Development using Packages, Stored Procedure, and Functions 3+ years of SQL and/or PL/SQL development experience
  • Unix Shell Scripting experience