SQL Developer Data Analyst 4180

Profile

SQL Developer Data Analyst (4180)
Irvine, CA
HMS Holdings Corp. is a national leader in cost containment and program integrity services for government healthcare programs. In 2006, HMS recovered more than $1.0 billion from third parties and other funding sources for its clients, and provided data that assisted them in saving billions more. HMS serves the Medicaid programs of 40 states, 65 Medicaid managed care plans, SCHIP, child support agencies, and the Veterans Health Administration. Together, the Company's service offerings benefit our clients by enhancing revenue and reducing costs.
Job Description
This position is responsible for the management of all data loading and processing; communicating issues, successes, and failures to internal and external clients.
This position is responsible for the successful on-boarding of data, communicating with internal and external clients concerning job status, issues and metrics.
Responsibilities
Manage process, coordination and scheduling of ETL data loads
Provide support for ensuring proper data loading and processing (24x7)
Provide monitoring and support for the intake and export of data within HMS
Report issues or delays with data loads to internal/external clients
Troubleshoot and identify issues with ETL data, file formats and jobs
Perform data quality checks and report to internal/external clients
Maintain documentation of ETL process and support procedures for each client
Work with client to make minor changes in data file layouts
Maintain, streamline and improve SSIS packages
Required Skills
Strong background with T-SQL
Ability to develop complex stored procedures for data loading
Ability to create/modify SQL Server Integration Services (SSIS) packages or other ETL tools
Experience with Business Intelligence Development Studio (BIDS)/Visual Studio
Strong ability to communicate effectively verbally, in writing, and fluently in English.
Strong ability to provide a high level of problem solving and technical troubleshooting skills.
Ability to work independently to meet objectives.
Ability to communicate technology into business terms with customers at all levels.
Strong ability to actively collaborate with other support teams for problem resolution.
Strong ability to analyze information and use logic and process to address work-related issues and problems.
Ability to provide careful attention to detail.
Ability to multi-task and prioritize workload.
Ability to perform well in a team environment, with staff at all levels, to achieve business goals.
Maintain and secure sensitive/confidential information.
Experience Required
- Advanced knowledge of Excel/Access
- Exposure to large data volumes (>1TB)
- Prior usage of 3rd party ETL tools
- General technology skills, including networking, hardware, protocols, security
- Preferred experience in the “healthcare claims processing” field
Advanced knowledge of Excel/Access
Exposure to large data volumes (>1TB)
Prior usage of 3rd party ETL tools
General technology skills, including networking, hardware, protocols, security
Preferred experience in the “healthcare claims processing” field
HMS proudly supports our Military Veterans
Equal Employment/Equal OpportunityHMS is committed to providing equal employment and individual advancement opportunity to all job applicants and employees without regard to race, creed, color, national origin, sex, age, medical condition, disability, veteran or marital status, sexual orientation, citizenship status, or any other unlawful criteria.
Company Overview
find more jobs with this company

Company info

Sign Up Now - WashingtondcCrossing.com