SAS Programmer (Data Management Senior)

Owns the completeness and accuracy of Medicare Risk RATS Submissions for HI and NW regions; including transition with local IT teams.
Analyzes impacts of changes in source systems on Risk Submission systems. Consults with data source owners on any needed enhancements.
Project management, requirements definition, design, testing and implementation of any enhancements to Risk Submission extract programs.
Facilitates investigations into technical data quality issues. Works with regional partners to identify data issues and design solutions.
Ensures that Risk Submissions processes are adequately documented and auditable. Provides system information and consulting to auditors.
Co-owns the Medicare Overpayment Redactions process.
Works independently, able to contribute to decision-making on technical issues regarding the RATS extract programs.

Includes design, testing, implementation, control and maintenance of organization’s logical and relational databases across platforms and computing environments.

Essential Functions:

Project Management: Manages small to medium size projects. Develops and executes project plans. Provides project reporting to project sponsor under guidance of higher level resource.
Meta Data Repository: Develops data definitions consistent with data management standards and conventions. Defines meta data structures for information repository and performs model management.
Data Design (logical): Analyzes business information requirements and translates these into logical database designs. Collaborates with physical database designers to develop alternative solutions for meeting complex and conflicting requirements. Develops data definitions consistent with data management standards and conventions. Participates in model integration and convergence activities.
Database Development (physical): Develops, tests and implements the organization’s physical databases across multiple platforms, technologies and computing environments.
Database Performance: Provides support to Lead in capacity planning, forecasting, and tuning. Develops performance/tuning evaluation reports.
Communications: Communicates business/information models to clients, developers and database designers. Communicates database designs to data analyst and application programming staff.
Technology Evaluation: Researches and evaluates alternative database solutions and recommends the most efficient and cost-effective solution for the project, ensuring consistency with enterprise direction.
Methodologies and Standards: Recommends development of or adoption/incorporation of new methodologies and standards for supporting information management.
Database Management and Support Tools: Implements, configures and customizes database management and support tools.
Client Consulting: Consults with clients and development areas in the design and implementation of small to medium projects. Consults with clients to determine information management requirements.
Training/Mentoring: Provides direction, guidance, and technical support to clients, applications, and operations areas. Develops technical and analytical skills of lower level resources.
Data Transformation: Designs, develops and tests complex transformation extract s and load routines.
Database Maintenance: Provides second level diagnosis and resolution of database problems. Works with vendor personnel, if necessary, to achieve timely solutions of database problems. Escalates as necessary and provides problem resolutions.