ETL Professional Application Designer Job at Educology Solutions in Washington

ESI is seeking a Professional Application Designer that will be responsible for designing and developing processes that translate data from various sources to destinations and presents findings to appropriate team members, clients and vendors. Escalate concerns to management and follows team standards.ESSENTIAL FUNCTIONS• Duties and Responsibilities (List all essential duties and responsibilities in order of importance)o Solutions ETL-related technical tasks, identifies potential issues, resolve issues, and drives tasks to successful completion on or ahead of schedule.o Understands and follows processes and procedureso Informs Management of project issues; escalates issues in a timely manner, and asks for assistance when needed.o Prioritizes ETL tasks, ensuring that tasks are completed on or ahead of scheduleo Develops, tests, manages, and implements ETL packages and applications within the standards set by the team.o Tunes and troubleshoots ETL applications.o Performs standard ETL administration tasks such as deployment, package migration and relocation, and managing metadata.o Prepares ETL packages for deployment to development, test, and production environments following all Release Management policies.o Participates in the on-call rotation.• Knowledge, Skills and Abilities ( List all knowledge, skills and abilities that are necessary to perform the job satisfactorily)o Analytical skills in a SQL environment using T-SQLo ETL design and development knowledge using the Microsoft BI tool set, specifically SSIS and T-SQLo Database knowledge and ability to query complex data setso Excellent verbal and written communication skillso Ability to abide by policies and valueso Ability to maintain attendance to support required quality and quantity of worko Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)o Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customersRequired Education: Bachelor's Degree or equivalent experienceRequired Experience:1+ years ETL design and development experience,1+ years Analysis experience using SQL1+ years database knowledge utilizing SSIS and T-SQLPreferred Licensure/Certification:Microsoft Business Intelligence certification(s)