Under general supervision, this position exists to assist the organization in data management including consolidation, structuring, analyzing, manipulating, tracking and reporting to support strategic data-related decisions. This position takes an active leadership role as both as a consultant and as a high-level database programmer (responsible for data extraction, transformation, loading and Business Intelligence reporting).
Essential Functions:
- Directs the development of outcomes and process measures, including technical specifications, to enable population measurement, guideline implementation, and evaluation.
- Builds and maintains complex statistical SAS routines using macros, vendor software, and software written by self and others.
- Designs, develops, implements and supports complex data extraction, translation and loading processes.
- Automates end-to-end data extraction, manipulation, analysis and reporting.
- Tests and maintains data integrity across multiple relational databases (may include Oracle, Teradata, internal SAS, DB2, VSAM; external: Adobe, Excel, flat files, SAS parsing routines, COBOL).
- Builds sophisticated statistical models and forecasting tools using these databases.
- Designs and enhances databases.
- Designs menu systems that are effective and user-friendly.
- Develops reports with accurate, easy to read, useful information that satisfies the client's needs.
- Designs and generates tracking and monitoring tools.
- Designs research plans for data gathering and analysis; participates significantly in interpreting analyses and developing action plans accordingly.
- Defines and frames complex multi-dimensional healthcare issues and develops time tables/processes for decision making.
- Interacts with healthcare analysts, service providers and partners and physicians to translate needs, issues, and ideas into effective strategies and action plans.
- Formulates specific implementation plans and evaluates the effectiveness of actions/programs implemented.
- Develops creative alternative solutions.
- Communicates results/recommendations to project sponsors, clients and various senior level audiences.
- Participates in technical analysis and troubleshooting of database and data quality issues.
- Oversees application maintenance and production support.
- Sets the strategic direction of projects.
- Determines goals and priorities with team, clients, or project management sponsors (when appropriate).
- May coordinate team/project activities and schedules.
- May establish team membership and project participants, provide leadership to multidisciplinary project teams, as well as manage work of outside consultants when used.
- May participate in the development and management of the department, including coaching and recruiting for consultants/analysts and other departmental activities.
Qualifications:
Basic Qualifications:
- Master's degree in technology, statistics, economics, finance, health care administration, public health administration, statistics, mathematics, operations research, or related field required, or equivalent. Bachelor's degree and five (5) years additional relevant work experience in lieu of a Master's degree.
- Minimum of five (5) years programming in SAS, SQL, VBA, .net, RDBMS systems, Oracle PL/SQL, Teradata SQL, database stored procedures and triggers or equivalent statistical analytical programming language (Department may identify specific programming needs.)
- Minimum of five (5) years experience with analytical manipulation and interpretation of large databases required (ETL Informatica, Abinitio, SAS and other BI tools).
-Minimum of five (5)years of related analytical consulting experience, healthcare experience preferred. Broad familiarity with medical practices, especially population management and process and outcomes measurement.
- Experience with Unix, Windows, MVS/TSO operating systems required. Microsoft Office skills required.
- Exceptional analytic and critical thinking skills, writing skills, communication skills, consulting skills, and ability to work within a team. Ability to express complex analytical and technical information to senior management or to audiences with clinical training. Must be an independent self-starter.
- Proven leadership in consulting and, for some areas, project management. Must exhibit efficiency, collaboration, candor, openness, and results orientation.
- Must be able to work in a Labor/Management Partnership environment.
Preferred Qualifications:
- Project management experience.
- Knowledge of JCL and Unix Shell Scripting.
- Experience in query tuning and system performance improvement.
External hires must pass a background check/drug screen.
We are proud to be an equal opportunity/affirmative action employer.