JOB SUMMARY:
Under general supervision, supports software applications by creating new and maintaining existing data integration programs, and writing ad hoc reports for Kaiser Permanente’s Prevention organization customers. This position functions as a Senior Analyst/Programmer supporting health care prevention activities such as managing data integration for Kaiser Permanente member medical screenings, disease management and other prevention programs.
Compliance: (DO NOT EDIT) Maintains and supports a culture of compliance, ethics and integrity. Maintains knowledge of policies and procedures and performs in accordance with the Principles of Responsibilities and applicable regulatory requirements, external laws and accreditation standards. Appropriately reports observed fraud or abuse. In addition to defined technical requirements, accountable for consistently demonstrating service behaviors and principles defined by the Kaiser Permanente Service Quality Credo, the KP Mission as well as specific departmental/organizational initiatives. Also accountable for consistently demonstrating the knowledge, skills, abilities, and behaviors necessary to provide superior and culturally sensitive service to each other, to our members, and to purchasers, contracted providers and vendors.
POSITION REQUIREMENTS:
Required Skills:
5 or more years experience in SAS Data Step and Macro programming
Experience tuning SAS programs
3 or more years experience using ANSI SQL in an enterprise relational database
SQL query tuning experience
Some supervisory experience required.
Good written and oral communication skills. Strong problem solving skills.
Preferred Skills:
Experience in a health care environment
System Data Integration experience
Business Intelligence
SAS/ACCESS and SAS/CONNECT experience
Previous experience with all aspects of the software development lifecycle
Experience with MVS/ TSO - IBM mainframes
Essential Responsibilities
- Designs and maintains data integration programs using SAS Data Step, SAS Macro, SQL and other technologies.
- Supports and fixes existing data integration programs. Tests and maintains data integrity.
- Extracts data from many different data sources from RDBMS such as SQL Server, Oracle, Teradata, and DB2. Coordinates with database administrators, data stewards, business analysts, subject area experts and others to verify data accuracy and program logic.
- May supervise small teams on projects as assigned Mentors peers both inside and outside of department in roles such as data analyst, statistician and data consumer with SAS programming and data semantic questions and issues.
- Translates user requirements, issues, and ideas into effective data integration programs. Formulates specific IT implementation plans and evaluates their effectiveness. Develops creative alternative solutions to user problems.
- Assists in the determination of goals and priorities with team, clients, or project management sponsors.
- Codes, tests, and maintains new and existing computer application systems independently and teaches others these skills.
- Provides complete resolution of user production problems.
- Delivers professionally written analysis of user requirements; documents programs, systems and procedures.
- Leads team members in full cycle development including collection of requirements, design, construction, testing, and production deployment. Supervises other technical analysts as assigned.
Functional and Environmental Factors available on request.
