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 5 years additional relevant work experience in lieu of a Master's degree.
- Minimum of 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 5 years experience with analytical manipulation and interpretation of large databases required (ETL Informatica, Abinitio, SAS and other BI tools).
-Minimum of 5years 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.