Sr Data Systems Analyst

Data Systems Analyst

Randstad is looking for an experienced Data Systems Analyst to join the DSW team at WellMed. This role supports projects and operational enhancements for Data Warehouse environments. This includes pulling data into enterprise DW, producing BRD, and supporting throughout the entire SDLC using waterfall methodology.

Job Duties

• Supports projects and operational enhancements for Data Warehouse environments. The team is responsible for onboarding CDO's and other orgs into the WellMed model. This includes pulling data into enterprise DW, producing BRD, and supporting throughout the entire SDLC using waterfall methodology.

• Develops test cases/documents and performs testing as needed.

• Ensures implementation plan passes review and manages dates/change requests.

• Analyzes business needs, documents requirements and translates needs into functional, non-functional and/or technical specifications.

• Delivers requirements, performs analysis, and evaluates downstream business, systems, process, and/or organizational impacts.

• Plans and assists with oversight of testing processes and activities including defect identification and resolution.

• Analyzes charts and/or diagrams of the problem to be programmed and defines system requirements in terms of system capabilities.

• Develops or assists in the development of work plans, time schedules, and project task items and schedules and assists with estimating resource needs for analysts, programmers, user personnel, consultants, equipment, and prepares routine project status reports.

• Assists in the development of project cost and benefit estimates to establish project worth including the development of alternative considerations. This will result in recommendations for the installation of new systems or equipment, or to change existing systems and equipment.

• Advises the appropriate people on the implications of existing IT systems that can be applied to a problem. Identifies risks and issues, and seeks approval on complex matters.

• Checks, instructs, assigns work, and otherwise functionally directs technical staff in order to achieve desired end-results on complex problems.

• Provides subject matter expert and operational support to internal business partners.

• Performs all other related duties as assigned.

Job Requirements

• 5+ years of experience writing complex SQL queries.

• Solid understanding of using SQL for ETL in a Data warehouse. Understanding what it means to move data through systems, and has worked directly with data (not just via reports).

• Experience doing data analysis and leveraging SQL server to navigate through tables to research, test and analyze data.

• Experience using Query analyzer (tool).

• 5+ years of experience in developing requirements and performing system analysis.

• 2+ years of experience of major software systems implementation experience.

• Strong understanding of the Software Development Lifecycle (SDLC).

• Ability to analyze and document process and data flow.

• Ability to clearly communicate ideas and solutions.

• Ability to effectively work with both internal and external clients.

Desired Skills & Experience

• Experience with data models, data warehouse, data management and data movement.

• Knowledge of Health Care Industry and related business functions.

• Experience in Medicare Claims and Medicare Risk Adjustment.

• Experience with project management and project control methodologies.

• Experience process re-engineering and best practice implementations.