Job Description

Ability to build, test, and maintain ETL architecture and processes using strong modular system design skills Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements Work with other members of the team and make sure that routine data loads are completed properly without any issues and report weekly load status to supervisor. Ability to work independently on routine data loads with a minimal amount of supervision. Analyze and QA data from different sources and ensure that it is properly loaded into our systems Investigate data quality issues and implement appropriate solutions Responsible for performance tuning of database functions, SQL queries, stored procedures and SSIS packages to ensure scalability demands are satisfied and will be responsible for monitoring the production jobs, and other database activities (Backups, recovery, etc), Ability to manage individual priorities and tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks. Go-Live and Production Support - Need to work after business hours as needed basis., will be monitoring the production jobs & processes and will fix any issues and work with peers and supervisor and track the issues in in-house task system Requirement gathering – frequent interaction with the Data & Database Systems Managers, Technical Managers, Data Architect, Database administrators, Application Users – all belonging to different departments and divisions of to ensure smooth implementation and running of the application Knowledge of health system functions, terminology and standard coding systems preferred. Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Qualifications

Experience with relational database systems in an operational environment and particularly with Microsoft SQL Server 2008 or later. Strong experience in extraction, transformation, and load processes from multiple source format files and systems into operational systems into the data warehouse. Experience in multi-server data management and database administration functions Excellent work ethic, organizational, analytical, planning, problem solving, and communication skills are must Must be authorized to work in the United States on a full-time basis for any employer Bachelor's degree in computer science engineering, mathematics, statistics, science, information technology, Business Administration required Or Master Degree in computer science, computer application or Business Administration preferred Minimum 6 + years of extensive experience in Data Migration, Data Load & Management, SQL Server Integration Services (SSIS) and other equivalent ETL tools and ETL design and development & T-SQL programming using SQL Server 2016/2014/2012/2008.

Additional Information

All your information will be kept confidential according to EEO guidelines.